Sub Reports Linking

[MikeCitizens]

Hello,

I have a small issue trying to bring data together from three different sources. I think sub-reports is the best answer to do this, but Im unsure of how exactly to pull it off.

Here is what I need to do

Example

Sub Report #1 (product #1)

Country #1
Bank # 1 Risk Amount
Bank # 2 Risk Amount
Bank # 3 Risk Amount

Country # 2
Bank # 4 Risk Amount
Bank # 5 Risk Amount

Sub Report #2 (product #2)

Country # 1
Bank # 1 Risk Amount
Bank # 6 Risk Amount

Country # 2
Bank # 5 Risk Amount
Bank # 7 Risk Amount

Sub Report #3 (product #3)

Country # 1
Bank # 1 Risk Amount
Bank # 2 Risk Amount
Bank # 6 Risk Amount
Bank # 8 Risk Amount

MAIN REPORT (Desired results)

Prod#1 Prod#2 Prod#3 Total
Country # 1
Bank # 1 RiskAmt RiskAmt RiskAmt Total
Bank # 2 " " " " " " " "
Bank # 3 " " " " " " " "
Bank # 6 " " " " " " " "
Bank # 8 " " " " " " " "

Country # 2
Bank # 4 RiskAmt RiskAmt RiskAmt Total
Bank # 5 " " " " " " " "
Bank # 7 " " " " " " " "




If there a way to pull the totals from subreports, inserting them into another report, while having the correct country and bank tags with them, and all grouped nicely together?

Please let me know

Mike

 

[MColeman]

This looks like a cross-tab report would work for this.

 

[MikeCitizens]

Yes I agree it should be a cross tab, but how do I pull in data from the 3 different areas, if there are no consistant linking fields. Every month the countries and banks can and will change.

Thanks for your help.

Mike

 

[Madawc]

In Crystal 8.5, you can use a formula field that looks for data on three or even more possible sources, finally ending with "Nothing found" if all of these fail. Does this help?

Failing which, Shared Variable will pass back data from a subreport. Do a keysearch if you don't already know how to use them. But remember thatthe Shared Variable will only have a useable value in the section after the section that calls the subreport.

Madawc Williams
East Anglia, Great Britain