Count of , but if zero then do not show zero

[jack91]

hi,

I am counting a bunch of rows, but if the count is zero then I don't want to see it.

Where would i put this and how?

thanks
jk

 

[CRCRCR]

Right click on the field, and you'll find a "suppress if zero" check somewhere.

format field, number tab, and "suppress if zero"

Or change "Font" Colour to white if your field = zero

etc..

k.

 

[dgillz]

Do you simply not want to see the zeros, or do you not want to count them as well?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[jack91]

I am counting rows 1 thru 10 and the count is zero == so when i make the count total in the group footer I don't want to see anything unless it has a value more than zero.

I hope i am clear

thanks
Jk

 

[jack91]

I found the suppress if zero - this really helps.

thanks
Jk