Passing shared variables based on group totals in sub report to main report
Hi,
I am passing parameters from the main report (run as of date & item code range, category code range) to sub report
and then need to pass back shared variables based on group totals from the sub report to the main report.
I have setup formula in the main report calling the shared variables from the sub-report, however the totals from the sub report are not calculating & passing through properly.
The values of the last record in the sub report are passing to the main report, not the group totals or the grand total.
On the main report, the sub report is placed in the section above shared variable formula.
In the sub-report I have 3 group totals. –
Item - This is the sub report being place on the main report.
Category – Have setup shared variables for these, placing in a group below the sub report
Grand totals. – Have setup shared variables for these, placing in the report footer in the main rpeort
Could someone please let me know why the shared variables from the sub report are only printing the values of the last record in that group instead of the group totals?
Is it possible to pass multiple group totals from a sub report into a main report via shared variables?
Report is like this
Main report
Group footer #3 Item code <Sub report group footer 2 of Item totals> <other fields>
Group footer #2 (other sort)
Group footer #1 Category totals <@vCatSalesAmt>
Report Footer (Grand totals) <@vGTSalesAmt>
Sub report: Sales file – sorts category, then item code
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.