Combine Two Reports and Collate Them?

[VoluptuousVegan]

I have two reports: one shows states' monetary figures WITH attorney firms and one shows states' monetary figures WITHOUT attorney firms. What I need to do is print the page for With attorneys for Alabama then print the page for Without attorneys for Alabama, then Arkansas, Arizona, etc. etc. I have tried inserting the Without Attorneys report as a subreport and suppressing other sections in the With attorneys but this isn't working. Let me put it another way: The way it's being done now is people are printing the With Attorneys report. Then they print the Without Attorneys report. They "collate" them by hand (put the alabamas together, then the AR, then the AZ, so on and so forth) and then go scan them in to Adobe format to send to management. I need Crystal to do automatically what they are doing by hand! Help!

 

[MJRBIM]

You should be able to use the linked-subreport method if you insert the subreport into the group footer for STATE and pass the STATE value as the link.

ALABAMA (with Att.)
<sub>ALABAMA (without Att.)
ARKANSAS (with Att.)
ARKANSAS (without Att.)

etc
etc
etc</sub>

 

[VoluptuousVegan]

That didn't work. :>(

 

[MJRBIM]

Can you be more specific about HOW it didn't work....?

 

[VoluptuousVegan]

Well, many ways - the most important of which it didn't pass the state value onto the subreport so everything is blank! I'll have to look at it some more. This is very troubling.

 

[MJRBIM]

Look at the LINKING method between the main report and the sub-report, you need to pass the STATE value from the main report to the sub-report on each GroupFooter.

 

[lbass]

Why do you need a subreport? What tables and fields are you working with? If you have a table containing the states and a separate table with the attorneys, then you could use a left join from the states to the attorneys, and then insert a group on states and a second group on this formula:

if isnull({attorneys.linkingfield}) then
"Without Attorney" else
"With Attorney"

Then you would just add a page break after each group #2 footer.

-LB