Shared variables

[sgk17]

I have a report with 2 subreports. Each subreport as well as the main report includes the same list of customers but in different order. Each subreport has a formula that assigns a number to each customer. I want to grab both of these numbers from the subreports and display them in the main report. Ex.
Subreport 1:
John Doe 3
Jane Doe 2
Subreport 2:
Jane Doe 9
John Doe 12
Main Report
John Doe 3,9
Jane Doe 2,12

Is this possible? I'm trying to use shared variables but I can't get it to work. Also, if they're in different orders will the shared variables automatically match to the correct customer in the main report? Any ideas would be helpful. Thanks.

 

[IdoMillet]

If this is your design then the shared variable must be an array that contains both the Cust_ID as well as the associated value (use some delimiter to combine these 2 values into one).

In the main report, loop through the shared variable array, split the value of each entry and locate the entry that matches each customer.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com