Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Add Headers and Footers to SSRS Report

by suresh

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 in SSRS Report.

Both SSRS Headers and Footers will repeat in each 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 the below-shown DataSet. Please refer to Shared Data Source and Dataset articles to understand the steps involved in creating Shared Data Sources and Dataset that we used for this SSRS report.

Format Table Report in SSRS 1

And the Custom SQL query that we used in the above Dataset is:

-- 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 in SSRS Report, We are going to use below shown report.

Please refer to Table Report, Format-Table Report articles to understand the creation, formatting table reports, and see Grouping in Table Report article for Grouping techniques.

Add Headers and Footers to SSRS Report 2

How to add Headers and Footers to SSRS Report

To add the SSRS Report Headers, or SSRS Page Headers, right-click on the empty space in the report designer to open the context menu. From it, please select the Insert -> Page Header option.

Add Headers and Footers to SSRS Report 3

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

Add Headers and Footers to SSRS Report 4

To add the SSRS Report footer or SSRS page Footer, right-click on the empty space around the table report in the report designer and select the Insert -> Page Footer option.

Add Headers and Footers to SSRS Report 5

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

Add Headers and Footers to SSRS Report 6

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

Add Headers and Footers to SSRS Report 7

Now you can see the Logo, and this Logo will repeat in every Page.

Add Headers and Footers to SSRS Report 8

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

Add Headers and Footers to SSRS Report 9

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

Add Headers and Footers to SSRS Report 10

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

Add Headers and Footers to SSRS Report 11

Now you can see the Logo in the page header

Add Headers and Footers to SSRS Report 12

and text in the same page footer

Add Headers and Footers to SSRS Report 13

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

Add Headers and Footers to SSRS Report 14

Remove Headers and Footers on SSRS Report

It is straightforward 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.

Add Headers and Footers to SSRS Report 15

To remove the Page Footer, Please right-click on the Page Footer. Next, select the Remove Page Footer option from it.

Add Headers and Footers to SSRS Report 16

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

Add Headers and Footers to SSRS Report 17

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy