Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Report Builder Report Footers



The Report Footer is the bottom section of a report.  It may contain the page number, execution date and time, a confidentiality notice, and so on.  This topic will walk through the steps for adding the report footer to a report. 


We will continue with the report that we began in this section.  Our report has the header section completed and looks like this:

When you create a new report by selecting Blank Report from either the Getting Started dialog or the New Report or Dataset dialog, the footer is added automatically; notice the ExecutionTime at the bottom of the page.  To add a Report Footer you can click Footer on the Insert tab of the Report Builder ribbon and select Add Footer from the popup menu:

If the footer already exists, the popup menu will have the Remove Footer option.

Let's make these changes to the report footer:

  • Delete the execution time (we have it in the header)
  • Add a confidentiality statement

To add the confidentiality statement drag a TextBox from the Insert tab onto the report footer area and drop it in the middle of the report footer area; set the value to "CONFIDENTIAL - ABC COMPANY".  After dropping the TextBox onto the report footer area, you can start typing.  The report design looks like this:

Click Run on the Home tab to preview the report:

We will now move on to adding content to the Report Body. 

Additional Information

Last Update: 6/23/2011

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools