cancel
Showing results for 
Search instead for 
Did you mean: 

How to suppress a group with a sum of $0

Former Member
0 Kudos

Post Author: MarkO

CA Forum: General

Hi

I am trying to develop a report with groups of account numbers and amounts. The detail section is suppressed leaving only the group footer showing the account number and group total $. I would like the report to only show groups where the total $ is not equal to $0 without leaving any gaps or spaces in the report. BTW I am fairly new to crystal reports.

Thanks,

Mark

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Post Author: Jagan

CA Forum: General

Alternatively, use the group selection formula to remove groups with a zero sum, e.g.

sum({table.amount}, {table.account}) <> 0

Former Member
0 Kudos

Post Author: Jagan

CA Forum: General

As you want the sum of amounts per account, use

sum({table.amount}, {table.account})

See the help on Sum functions for parameters

Former Member
0 Kudos

Post Author: Aron Sereny

CA Forum: General

this is really easy to do, you need to bring up the section expert and in there under the formule for suppress enter your suppress condition...somethink like

sum( account) = 0

the suppress needs a boolean, so this will return a true or false