suppressing columns based on some condition

[iamsiraj]

Hi,
Can some one tell me, how do we suppress the Column based on some condition using CrystalReport 9.0 ?
For example i have 6 columns on my report. Based on some condition i want to show only 4 columns at run time,so how do i hide the other 2 columns.

Actually i tried suppressing the Field values which matches the condition,but it suppress only only those field values which matches the condition not the entire column !

Can any body help me ?

Thanks for taking time to read my query
regards
Siraj

 

[mbarron]

Create the follong formula:

true<-formula name

whilereadingrecords;
numbervar tof;
if {your.field} = something then tof:=1;

Then condionally suppress the columns using:
Sum ({@true})>=1 Mike

Before: After