My requirement is conditional hiding of column headers based on column values. If a particular column doesn't display any values then that column header should be hide.

 

For this i did a work around like below ...

 

first i created a variable as

numbervar x:=0; -- placed this in page header.

 

created a second variable like ...

whileprintingrecords;

x:=x+(if isnull(column) then 0 else 1)  -- placed this in detail section

 

created third variable sum like ...

whileprintingrecords;

numbervar x;  -- placed this in page footer.

This sum will display no of values displayed in that column per page in the page footer.

 

hiding condition is

 

if ( isnull(column) and {sum}=0) then true else false.

this condition is working for some pages not working for some pages.

 

 

Please help me in this issue.