Sub-Report Question 1

[itsgenekramer]

If I have a report with an embedded sub-report, is it possible to take a data field from the sub-report and insert it into the main report?

Thank you.
Gene

 

[lbass]

You can "share" the subreport field with the main report by setting it up as a shared variable. In the subreport, create a formula {@sharedvar}:

whileprintingrecords;
shared numbervar amt := {subreport.field};

You must place this formula somewhere on your subreport canvas. Then in the main report, you can reference this field and do calculations with it, as in the following which sums the subreport amount in the main report:

whileprintingrecords;
shared numbervar amt;
numbervar grtot := grtot + amt;

The shared variable must be used in a section of the main report lower than the one in which the subreport is located.

To display the grand total of the shared variable, you would use a formula like the following in the main report footer:

whileprintingrecords;
numbervar grtot;

-LB

 

[itsgenekramer]

Thanks. Have a nice weekend.