SSRS Miscellaneous

Introduction

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

SSRS Miscellaneous

  • 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.

SSRS Miscellaneous

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

SSRS Miscellaneous

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

SSRS Miscellaneous

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

SSRS Miscellaneous

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

SSRS Miscellaneous

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.

SSRS Miscellaneous

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

SSRS Miscellaneous

Then set the RepeatOnNewPage properties value to True.

SSRS Miscellaneous

Then we can see the output on every page.

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

SSRS Miscellaneous

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

SSRS Miscellaneous

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.

SSRS Miscellaneous

Step 2. Click on the fx button.

SSRS Miscellaneous

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

=Ceiling(Rownumber(nothing)/10)

SSRS Miscellaneous

Step 3. Go to Tablix and right-click on the Group1 column automatically created when creating a group. Then select Delete Columns.

SSRS Miscellaneous

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

SSRS Miscellaneous

Step 4. Then go to Group1 Properties.

SSRS Miscellaneous

Check the page break option from here.

SSRS Miscellaneous

Then go to this window's Sorting tab, delete Sort By, and click OK.

SSRS Miscellaneous

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

SSRS Miscellaneous

Then we can see the output here.

Every page of the SSRS report displays 10 records.

SSRS Miscellaneous


Similar Articles