Main rpt has cond'l suppression on accnt, sub report still shows all 1

[trsquared]

I'm using ODBC connections to two different oracle databases with Crystal 8.5.

I've got a main report that provides data on invoice amounts, tax amts, etc. I have a sub report that pulls site data from another database. While I'm linking the sub report to the main report on the account number, the sub report is still showing account numbers that don't appear on the main report. I believe this is because I'm suppressing account numbers in the main report based on this formula:

If Sum ({@Invoiced}, {ACCOUNT.ACCOUNT_NUMBER})=0 and
Sum ({@Collected}, {ACCOUNT.ACCOUNT_NUMBER})=0 and
Sum ({@Outstanding}, {ACCOUNT.ACCOUNT_NUMBER})=0 and
Sum ({@Tax}, {ACCOUNT.ACCOUNT_NUMBER})=0 and
Sum ({@Adjustments}, {ACCOUNT.ACCOUNT_NUMBER})=0
then 0
else 1

So if "0" don't show the account number on the main report.

I'm trying to match account, site name, site id from sub report to the data that appears in the main report.

Is there any way to make the main report only show accounts from the sub report that match those that aren't suppressed.(the sub report data source does not have any billing information)

 

[hilfy]

Right-click on the subreport and select Format. Set up the suppression formula for the subreport to match that of the main report.

-D

 

[trsquared]

hilfy:

Thanks so much, that worked!