SSRS Miscellaneous

Introduction

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

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

How can the question mark (?) be removed from the 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 from 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.

The table header should be visible on each page screen in an SSRS report.

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

Step 1. Go to the SSRS report design page's bottom and 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 the output on every page.

Page 1. We can see the table header on the first page.

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

Display 10 records on each page of the Report

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

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 automatically created when creating 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 this window's Sorting tab, delete Sort By, and click OK.

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

Then we can see the output here.

Every page of the SSRS report displays 10 records.