Passing shared variables based on group totals in sub report to main report

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* 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.