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.
Hello! I have an issue. I have a main report with 5 subreports. Subreport 4 is an image and does not need a page number or a footer. I have removed the page footer for this subreport but I can’t do the same for the page number. Can you please help?
You have removed the page footer in the sub-report. But, the parent report has the footer and it shows the page number. We need to hide the footer using some code.
You should have a text box in the parent report footer and write an expression to print the page number as follows.
=IIF(Globals!PageNumber = 4, “”, cStr(Globals!PageNumber))
I hope this will help you.