Suppress Printing based on sub report

[kalnkato]

I am creating an Aging report that uses 4 sub reports to get payment, adjustment, dispute and credit transactions. The report is Grouped by Invoice number. After the sub reports are processed (located in the group footers), the main report calculates the total net amount using shared variables. The variables are calculated when each of the sub reports is processed and are used to calculate the total net amount (located in the group footer after the sub reports) on the main report. Here is the calculation for total net:

shared numbervar SumAmount := Sum ({INVOICE_SUMMARY.INS_CURRENT_CHARGES}, {INVOICES.INV_INVOICE_NUMBER}) - {@PymtAmt} - {@DisputeAmt} - {@AdjustmentAmt} - {@OCCAmt};
sumAmount

How can I suppress printing of the information for an invoice on the main report and the sub report information when the total net amount is zero?

 

[SurfingGecko]

You wouldn't be able to stop the printing itself, but what I would look at doing is suppress the section(s) [see format section] based on this result. If there is nothing showing there would be nothing to print.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[kalnkato]

I tried suppressing the sub-reports (at the Group level) that are used to determine if the sub-reports should be suppressed and this caused some of the Payment data to be associated with the wrong invoice. In one example, the payment that belonged to invoice 123 was associated with invoice 124.

Your help is appreciated