90 Minds Community

I have a Sage Intelligence non-financial union report based on 6 subreports. In three of the subreports are date range prompts. For each of the prompts, the user's response would be the same. Does anyone know of a way to "share" a parameter across subreports so that the user doesn't have to respond to three different prompts that come up at three different times?

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------

Are you trying to use it in the subreport links?  If you can't link to more than one sub report field from that parameter, you may have to have a few formulas (where it's just equal to the parameter, whatever they put in) and link on those. 
As far as passing the value INTO the subreports, you'd do that with a shared variable in the main report which you reference in the sub reports.  You typically initialize those guys in the report header  or group header if they need to reset, and then (y'all correct me if I'm wrong) you have a formula for them somewhere in a section above the subreport's section.  I put it on the report and then put it in a white font since it's not relevant at that point) .  Example of the formula. 
shared numbervar totalBoxes;
totalBoxes
Then in the sub-report, you'll use the same language in a subreport formula.
That formula may look like this:
shared numbervar totalBoxes;
Newtotal:= boxes.this.order + totalBoxes

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Thanks Rhonda and Joni!  I really have not worked with pass-through variables before.  Time to get acquainted!

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-08-2020 15:47
From: Rhonda McNamara
Subject: Sage Intelligence "Shared" Prompt Across Subreports

Are you trying to use it in the subreport links?  If you can't link to more than one sub report field from that parameter, you may have to have a few formulas (where it's just equal to the parameter, whatever they put in) and link on those.
As far as passing the value INTO the subreports, you'd do that with a shared variable in the main report which you reference in the sub reports.  You typically initialize those guys in the report header  or group header if they need to reset, and then (y'all correct me if I'm wrong) you have a formula for them somewhere in a section above the subreport's section.  I put it on the report and then put it in a white font since it's not relevant at that point) .  Example of the formula.
shared numbervar totalBoxes;
totalBoxes
Then in the sub-report, you'll use the same language in a subreport formula.
That formula may look like this:
shared numbervar totalBoxes;
Newtotal:= boxes.this.order + totalBoxes

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------

Susan, if you don't find a good solution for this subreport challenge, contact DataSelf. Our framework usually handles subreporting needs so much more efficiently (easier to setup, run faster, more ad hoc capabilities, and can be accessible anytime and anywhere). Thanks, Joni Girardi.

------------------------------
Joni Girardi
Dataself Corporation
------------------------------

Whoa!  I read the question wrong.  My answer pertains to Crystal.  I'm so sorry.  I humbly retract my answer.

------------------------------
==================
Rhonda McNamara
Customer Success Manager
Stewart Technologies, Inc.
rsm@stewarttechnologies.com
------------------------------