How to Suppress Empty Data in SSRS
The "null" database value displays no content when you display a report in Microsoft SQL Server Reporting Services. SSRS is a reporting platform that uses the .NET framework to dynamically create reports that users can view on an intranet website. To suppress empty data, you add a hidden text box on the form that hides any empty values on the report.
Other People Are Reading
Instructions
-
-
1
Open the Visual Studio software on your reporting services desktop and open the project you want to edit. Double-click the SSRS form you want to edit.
-
2
Drag and drop a text box to the form. Click the new text box and notice the properties panel displays options for the text box in the right Visual Studio panel. Select "False" in the "Visible" property option section.
-
-
3
Copy and paste the following code to the text box on the form:
=Fields!ExampleField1.Value & IIF(Fields!myfield.Value.ToString().Length >0,vbCrLf,"")
Replace "myfield" with the column on the SSRS report that is displaying blank data you want to hide.
-
4
Click "Save" to save the form changes. Click "Run" to execute the report in the debugger, so you can view the changes.
-
1
