RE: Report totals problem

[Rommel Relosa]

Oops...

That should have been a SELECT DISTINCT in the sub-select...

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rommel Relosa
Sent: Wednesday, December 19, 2001 2:06 PM
To: [EMAIL PROTECTED]
Subject: RE: Report totals problem

Dan,

 

Depending on the driving table of your report...

 

You can limit the result set report by using a sub-select with a group by and having sum(column) <> 0.

 

Kind like...

 

PRINT MyReport WHERE CustID IN +

(SELECT CustID FROM Invoice GROUP BY CustID HAVING SUM(InvoiceTotal) <> 0)

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Goldberg
Sent: Wednesday, December 19, 2001 1:13 PM
To: Rbase-L
Subject: Report totals problem

I have a report that totals at the end. If the total equals 0, I would like it to display nothing.

 

Does anyone have any ideas??

 

 

Dan Goldberg