SQL Reporting Services Page Footer is Printing on every Page

Posted on 2011-05-12
Last Modified: 2012-05-11
I have a SQL Report called Contract Quote.  It is 5 pages long and is very detailed.  I cannot include an attachment because the data is confidential.  The page footer is printing on the last 4 pages of the quote.  I have set the Page Footer to PrintOnLastPage = True and PrintOnFirstPage = False.  If I set the PrintOnLastPage = False then the Footer prints on the inner 3 pages.  I know SQL Reporting Services does not have a Report Footer.  What can I do to force the Page Footer to print on the last page only?
Question by:orther

    Accepted Solution

    This is a problem with SQL Reporting Services.
    This is the workaround:

    Create a Rectangle and place it in the Page Footer.  Set the Visibility to =Globals.PageNumber <> Globals.TotalPages

    You also need to add the same visibility to any of the Lines, like the line for the signature and the line that separates the body from the footer.

    Place all of the text fields on top of the Rectangle.

    Be certain that the footer is set; PrintOnLastPage = True

    Author Closing Comment

    I tested this and although it is not pretty, it does work.  Microsoft, get busy and give us a Report Footer.  Everybody else does.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now