Passing group totals from subreport to main report

[KingTechMary]

Bear with me - I'm new at this.

I'm trying to use a shared variable to pass a group total from a subreport back to the main report. In each report I have the data grouped by year; the main report is from one table and the subreport is from another table, but the years used in each are from the same (a third) table.

The subreport is in the Header of the main report.

In the subreport I have:
Shared numberVar Enrollments:= Count ({KTI_PFND_Workflow.cmp_code}, {@Fiscal Years});

In the main report I have:
Shared numberVar Enrollments;

I can see the correct totals in the subreport (using the fomula), but when I put the formula into the main report I get the same number over and over, which is the last total in the list on the subreport.

My ultimate goal is to chart the yearly values of each against each other. Hope all of this makes sense! Thanks in advance....

 

[lbass]

Please do not start multiple posts on the same topic--even if in a different forum. The subreport should be placed in a group header or footer based on the year group, and then linked on the year field. Charting on print-time formulas is complex, but perhaps you are aware of that. There is a white paper on this that might be helpful:

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/40e7130d-aa1e-2b10-ce9f-eee2a54ff4cd

-LB