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

Suppressing in Cross Tab reports

Status
Not open for further replies.

clydejones

Programmer
Jan 11, 2001
153
US
Hi All,

I have a cross tab report that appears to be working great. However, I want to suppress the 0's of the summarized field. In the format editor where you write your conditions to suppress. I wrote the statement "count({formulaName}) = 0", but nothing happens. What's goin on?

Clyde
 
Not sure if this helps but doesnt a crosstab require some information even a zero to work, if you remove the 0 then no data at all will be returned
 
Mark,
Thanks for your reply. I don't care if 0 values are returned I don't want to see them. From the Format Editor I can suppress all values, but I only want to supress the zeros. Thanks again for your reply

Clyde
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top