Monday, July 15, 2013

how to handle visibility of controls in SSRS report

Sometimes we wish to hide the control(in order to reduce space) if the control field value is null or empty. Use the below steps:

1. Open the report project in Visual Studios
2. Go to report design
3. Right click on the control and go to properties











4. select visibility tab and add the condition

=iif(Fields!fieldName.Value = "",True,False)

5. Save, rebuild and deploy report.

No comments:

Post a Comment