passing shared variables from subreport to mainreport

[crystal82]

Hi,

I have a report which has two subreports - one for revenue transactions and one for expense transactions.
The main report is grouped by Job Number (with each subreport sitting underneath this group). Both subreports are linked to the main report by job number.

Each subreport has a total amount which are being passed as shared number variables back to the main report - and is being displayed in the group footer of the main report.

Everything is working fine except for - when there is no revenue (or expense) transactions for a particular job, the amount (of the shared variable) does not display as 0, it displays as the amount of the previous job.

Any idea as to why this is the case?

Any help would be greatly appreciated!

 

[IanWaterman]

Its bcause the Var is being rest in Sub Report and not in main report. If SR does not execute VAR remains unchanged.

Add a reset formula to main report in hidden section underneath Subreport.

Ian

 

[crystal82]

Thanks Ian. Perfect!