Passing data from a Sub Report to a Main Report

[McChops]

Crystal reports 9

- I have a subreport embedded in a main report
- The report and subreport is connected to the same SQL DB
- The report and subreport use different tables from the DB
- The subreport has a distinct count on all records returned

What I would like to do is pass this number (distinct count of the number of records returned) from the subreport to the main report, and display this in the main report header.

I have tried using subreport links, with several variations of parameters and formula's, but to no avail.

Is this possible?

Thanks.

 

[Madawc]

You need a Shared Variable. Do a keyword search to find some examples. Crystal Help says nothing about them, unfortunately, at least not anywhere I've been able to find.

Madawc Williams
East Anglia
Great Britain