Sub-report total: (report subtot - sub report subtot)

[lsantos]

Hi,

I have a report + sub-report totalling question:

I have a report that per group prints receipts details and receipt amounts and a sum for every receipt group. I was asked to also provide a list of payments and payment sum per group in the same report. Note that both receipts and payments are coming out of the same database file. In simple world I could include both payments and receipts in the same report. But since the receipts have an additional file link that doesn’t apply to payments I created a sub-report containing the payments and a payment sum per group and linked the two.

My questions are:

1. How can I pass the receipts sub-total to the payments sub-report so I can provide a group total = (receipts group total – payments group total) ?

In the Crystal Reports help under "How to link a sub report to the main report without modifying the selection formula" it states that "...For instance, you may want the main report to pass in a summary value that can be used in calculations by the sub report, or you may want the main report to pass in the title of the sub report."

2. My main report has a parameter “Year” that I will need to pass on to the sub-report to only include payments for the same year without prompting the user for it.

Thanks in advance.

LS

 

[Madawc]

For Crystal 8.5, Subreport Links under [File] lets you pass values from the main report to the subreport. And 'Shared Variables' lets you pass them back, a keyword search will get you details. Does this help?

Madawc Williams
East Anglia, Great Britain

 

[synapsevampire]

There's a special edition of CR for Peachtree:

http://www.peachtree.com/crystalreports/

-k