SSRS Miscellaneous

This article explains how to remove a question mark (?) from a report viewer page number control.

• A page header should be visible on each screen of a page of a SSRS report.
• Display 10 records on each page of the report.

How to remove question mark (?) from report viewer page number control

For this issue we need to use the following procedure.

Step 1: Insert a page header into the report.
Step 2: Insert a Text box in the header section of the report.
Step 3: Then right-click on the TextBox and select Expression.



Step 4: Then select this option from the expression window and finally select OK.



Step 5: Then right-click on the TextBox and select TextBox properties.



Select the Visibility option from the TextBox properties window and then select the Hide option form the visibility tab.



After all that you can see the output in the review report. You can see there is no ? mark appearing near the page number.



Table header should be visible on each screen of a page in a SSRS report

Now we will learn how to make a visible table header on every pages of a SSRS report.

Step 1: Go to the bottom of the SSRS report design page and then select Advanced Mode.



Step 2: Then go to the right pane and press F4 (for properties).



Then set the RepeatOnNewPage properties value to True.



Then we can see output in every page.

Page 1: We can see the table header in the first page.



Page 2: The header has been made visible here also.



Display 10 records on each page of Report

Now we will learn how to control the number of records on every page of the report.

Step 1: Again go to the bottom of the SSRS report design page. Then add a parent Group here.



Step 2: Click on the fx button.



Then write this function in the expression window and then click OK.

=Ceiling(Rownumber(nothing)/10)



Step 3: Go to Tablix and right-click on the Group1 column that is automatically created when we create a group. Then select Delete Columns.



After clicking on Delete Columns select Delete Columns Only from this window and click OK.



Step 4: Then go to Group1 Properties.



Check the page break option from here.



Then go to the Sorting tab of this window and delete Sort By and then click OK.



After completing that entiore procedure please ensure the properties look like this.



Then we can see output here.

Every page of the SSRS report displays 10 records.