Skip to Content
avatar image
Former Member

Crystal 2013 Shared Variable results offset by 1 row

I have created a shared variable from a subreport. I have placed the shared variable formula in the footer of the sub report. I then created a formula referencing the shared variable in the main report. I have created a section above the details and put the subreport there. I have put main variable formula into the details section below the subreport. Details A contains the subreport. Details B contains the main fields and formulas. However, the variable field displays results that are off by one row. (Row 1 is blank. Row 2 contains the result for Row 1, Row 3 contains the results for Row 2 and so on). The subreport is actually reflecting the correct values. There's definitely something wrong with the variable but I can't figure it out.

Sub Report Variable Formula

whileprintingrecords; Shared DatetimeVar Var_RdyForTest:= Date(0,0,0); Var_RdyForTest:={AUDIT_LOG.AU_TIME}; Var_RdyForTest;

Main Report Variable Formula

whileprintingrecords; Shared DatetimeVar Var_RdyForTest; Var_RdyForTest;

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 03, 2016 at 07:24 AM

    Hi Scot,

    Would you be able to attach a copy of the report 'with saved data'?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded