hi, how can i hide the header and footer when there are no rows displayed in a table?

Hi, Could you please be more specific. Do you want to hide the page header or a group header of the report? Regards, Ram

Simply go to the text box property ( all textboxes used in header and footer) --> Visibility --> add expression by selecting any field from the dataset ex: =IIF(First(Fields!FieldName.Value, "DataSet1")= 0, True, False) That means if the field has no value, those textboxes will not be visible. Thanks Please mark as Answer if your problem is resolved.

Thats not working for me....

=IIF(count(Fields!Fields.Value, "Dataset")> 0, False,True) worked for me.. thanks

=IIF(count(Fields!Fields.Value, "Dataset")> 0, False,True) worked for me.. thanks

=IIF(count(Fields!Fields.Value, "Dataset")> 0, False,True) worked for me.. thanks