[RESOLVED] Is there a way to hide columns in report if they contain zeros

[Proctor]

Hello: My sql stored procedure is returning several columns and some times certain columns may only contain zeros. if this happens, i would like to hide the entire column but didn't know if this was possible in a crystal report.

thanks,
Proctor

[brucevde]

There are a few ways to do this in Crystal Reports.

1) Right click on the report object and select Format Field. On the Format screen -> Number tab click the Customize button. On the Custom Style screen -> Number Tab check the "Suppress If Zero" box.

2) Set the Object Visibility formula. On the Format Screen -> Common Tab click the button beside the Suppress checkbox. Enter a formula similar to
{DatabaseTable.FieldName} = 0

[Proctor]

brucevde: Hello - I'm finally getting around being able to try out your suggestions and so I tried suggestion #1 and it's working great!!!

I would also like to supress the header that's associated with it. do you know if there's also a way to do this?

Thanks again for your help!!!
Proctor

[Proctor]

Brucevde:

i used your suggestion #2 to suppress the column headers and so now I'm all set!!!

Thank you again for showing me how to do this.

Proctor

[jlbantang]

great post!