Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress the whole page if the group total is equal to zero 1

Status
Not open for further replies.

PeterConnick

Programmer
Nov 26, 2002
21
US
Crystal 8.5
Oracle DB

In my group footer I am using a running to sum all transactions.

There are time when I have a payment (+ $50.00) and a return ( - $50.00)

End result being $0.00.

I what to be able to suppress the entire page as I am doing on page break on this group.

I can suppress the footer but I can not figure out how to suppress the detail and the header information.

Any thoughts
 
You'd use a conventional 2nd pass summary in Crystal as opposed to a Running Total.

So the criteria for the suppress formulas would be something like:

sum({table.value},{table.group}) = 0

This is also how you could display aggregates in lieu of using Running Totals.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top