Home > SSRS > Hide Report Header on page 1 only – SSRS

Hide Report Header on page 1 only – SSRS


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.

 

 

Advertisements
  1. Nush
    June 17, 2013 at 1:16 am

    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?

    • June 17, 2013 at 10:43 am

      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.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: