Skip to Content
avatar image
Former Member

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

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?



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    Add comment
    10|10000 characters needed characters exceeded