Best way supressing entire page based on a condition

[geoffreyg]

I created a customer statement.

Sometimes I want to print statements with zero balances, other times I do not. I created a parameter called SuppressZero.

What is the best way to suppress invoice printing based on the parameter (SuppressZero) and the "InvoiceTotal" field?

Thanks!

 

[kenhamady]

If the zero balance is a group subtotal you can put the following into your group selection formula:

If {?Print0} = True
then True
else sum({field}, {Groupfield}) > 0

This will eliminate the records from that group so they don't print. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal