on 07-30-2007 7:29 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.