Add Headers and Footers to SSRS Report

In this article we will show you, How to add Headers and Footers to SSRS Report, Or How to add or remove Page Headers and Footers on SSRS Report. Both Headers, and Footers will be repeated in each and every page generated by SSRS Report. These are very helpful to place the Report Title, Company Logo, Company Address, Report Generated Time, Page Numbers etc.

For this example, We are going to use below shown Data Set. Please refer Shared Data Source and Dataset articles to understand the steps involved in creating Shared Data Source, and Dataset that we used for this report.

and the Custom SQL query that we used in the above Data set is:

SQL Query

-- Add, or Remove Headers and Footers on SSRS Report
SELECT Prodcat.EnglishProductCategoryName,
       prodSubcat.EnglishProductSubcategoryName,  
       prod.EnglishProductName, 
       prod.Color, 
       fact.[TotalProductCost],
       fact.SalesAmount, 
       fact.TaxAmt,
       fact.[OrderDate],
       fact.[ShipDate] 
FROM dbo.DimProduct as prod 
  INNER JOIN 
dbo.DimProductSubcategory AS prodSubcat ON 
       prod.ProductSubcategoryKey = prodSubcat.ProductSubcategoryKey 
  INNER JOIN  
dbo.DimProductCategory AS Prodcat ON 
       prodSubcat.ProductCategoryKey = Prodcat.ProductCategoryKey 
  INNER JOIN  
dbo.FactInternetSales AS fact ON 
       fact.ProductKey = prod.ProductKey
WHERE SalesAmount >= 3500

To explain the steps involved in add or remove Page Headers and Footers on SSRS Report, We are going to use below shown report. Please refer SSRS Table Report article to understand the steps involved in creating Table Report, refer Format Table Report in SSRS article to understand the formatting, and refer Grouping in SSRS Table Report article for Grouping techniques.

Add Headers and Footers to SSRS Report

In order to add the Headers, or Page Headers, right-click on the empty space in report designer to open the context menu. From the context menu, please select the Insert -> Page Header option as we shown below.

Now you can see the Page Header. You can use this Header to add the Company Logo, report Name etc

To add the page Footer, right-click on the empty space around the table report in report designer will open the context menu. From the context menu, please select the Insert -> Page Footer option as we shown below.

Now you can see the Page Footer. You can use this Footer to Place the Company Address, Page Numbers, Report Generated Time etc

For the demonstration purpose we will add our logo to the Page Header. And to do so, please right-click on the Page Header, and select the Image option from the context menu as we shown below.

Now you can see the Logo, and this logo will be repeated in each and every Page.

Let me add a text box with random data to demonstrate the Page footer advantages.

As you can see, we added Report is Generated By Suresh to the text box, and we want this text to repeat in each page

Let me adjust the extra spaces between the Page Header, Table report, and Footer

Now you can see the Logo in the page header

and text in the same page footer

Let me open the Last page so that, you can see th Header and Footer in one screenshot

Remove Headers and Footers on SSRS Report

It is very easy to remove Headers and Footers on SSRS Report. Please right-click on the Page Header, and select the Remove Page Header option from the context menu as we shown below.

in order to remove the Page Footer, Please right click on the Page Footer, and select the Remove Page Footer option from the context menu as we shown below.

From the below screenshot you can see that, we successfully removed the Page Header, and Footer

Thank You for Visiting Our Blog