Reporting Services conditionally hide fields

Question

I have a report where I have about 5 fields right next to eachother that dont return data in about 90% of the reports. Is there a way to hide these fields if they are empty otherwise display them if they do contain data?

Thanks

Answer 1

Yes, you can write VBScript in the RDL file to display the field if it is not Nothing and the like.

Answer 2

You can suppress columns conditionally in the report designer in SSRS, by selecting the table column and editing the Visibility>Hidden property (in the Properties window) to be the suppression condition.

Note that if the suppression condition is False at any point in the report, the columns will be displayed throughout the whole report.