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

[Former Member]

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?

Thanks,

Jordan

[vitaly_izmaylov · Accepted solution]

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.