How to Hide a Row in an SSRS Report
SSRS reporting displays all values queried from your database server, so you may want to restrict some rows, such as duplicate records, from the user's view. You use SSRS expressions to further filter records and columns after the report displays the data from the database.
Other People Are Reading
Instructions
-
-
1
Open Visual Studio and open the SSRS report project you want to edit. Double-click the form that contains rows you want to hide.
-
2
Right-click the section you want to edit and select "Properties." Then click "Visibility" and "Expressions." A window opens for you to type your expression.
-
-
3
Copy and paste the following template to the expressions panel:
=IIF(Parameters!Param = “value”,False,True)
Replace "value" with the value you want to use to hide the data. For instance, if you only want to display records in which the last name is "Smith," type "Smith" as the value.
-
4
Click the "Save" button and click "Run" to execute the report in the SSRS debugger to view the results.
-
1
