Business reports always have special requirements. Because, it will be given to customer or head of the organization.
SQL Server Reporting service has the property to hide the report header on the first page and last page. This property may be helpful for some people intent for report printing.
Implementation
Summary: this step by step process is to create a multiple page report to show how to disable report header one the report first page.
Step 1: Create a SSRS report
Step 2: Go to report menu and click Add Report Header
Step 3: Add a text box with a string “SQL Server Rider “and add another text box with page number expression in the header section
Page number expression
Step 4: Now click on report body layout, add two text box and a rectangle control from the report tool box as shown in the below picture. Set page break end to rectangle control.
Step 5: Now go to report header and change the property PrintOnFirstPage value to false.
Step 5: Click on report preview tab and navigate report pages.
Thanks for reading.
