Skip to Content

Not sure if I'm approaching my sub-report correctly with a variable?

Dec 21, 2017 at 09:15 AM


avatar image

I have a main report that is always ran in the previous plan year, so

{RPTFROMDATE}=01/01/2016 and {RPTTODATE}=12/31/2016

I have a subreport that is to be ran on 2017 and I am hoping to create a variable to send the 2017 ending balance to the main report.

First I was just trying to get the 2017 balance to show up correctly but I'm struggling with that part. I tried creating a variable to dateadd, and that didn't seem to work. I then tried to record select based on a formula that had a dateadd and that failed as well.

What would you suggest be the best approach?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vitaly Izmaylov
Dec 29, 2017 at 06:19 PM

The only way to pass values from subreport to the Main report is to use Shared Variable.

Note: Shared variables work only in WhilePrintingRecords evaluation time, so the subreport should be located before you use the value in the Main report like in Reports Header.

10 |10000 characters needed characters left characters exceeded