How to Limit the Number of Rows Displayed in a Tablix Using RowNumber
Published:
Updated:
Bold Reports allows you to use the RowNumber function in the Hidden visibility property to restrict the number of rows displayed in a tablix. This approach provides precise control over row visibility in reports and is useful for creating summaries or space-constrained layouts where only a specific number of records should be displayed.
Step-by-Step Instructions
Step 1: Open the Groupings Panel
- Select the tablix report item in your report to open the groupings panel.
- In the Groupings panel, locate the detail row group (for example,
Details1) under Row Groups and select it.
Step 2: Configure the Visibility Expression
- Click the Settings icon to open the Properties panel.
- Navigate to the Visibility section. Click the expression button next to the Hidden property and select Expression to open the expression editor.
- Enter the following expression to hide rows beyond a specific count (example to show the first 20 rows) and click OK to save the changes.
=RowNumber("DatasetName") > X
Replace DatasetName with your dataset name and X with the maximum number of rows to display. For example: =RowNumber("CustomerDetail") > 20
Step 3: Preview the Report
Click Preview on the top toolbar and verify that only the specified number of rows are displayed.
Download the sample report here.
