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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress shared variable when value= 0

Status
Not open for further replies.

ceej

IS-IT--Management
Jun 20, 2001
46
US
I have a couple of subreports that are totaled in a formula on the main report. basically inventory counts. Main formula Total is Shared Variable varSales + Shared Variable varCosts.

How do I suppress the printing of the main report formula (which uses the shared subreport variables) when the value is zero/0?

Suppress when Evaluateafter(Total)= 0, doesn't work.

Thanks.
 
You should be able to format the formula the usual way: format field->number->customize->suppress if zero.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top