[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Hiding the blank space of a page footer when PrintOnFirstPage = false (using SSRS sp1)

Posted on 2006-04-02
5
Medium Priority
?
1,457 Views
Last Modified: 2009-09-22
Hello,

I have a report that is always two pages long. Since I can't have a report footer I made a page footer and set PrintOnFirstPage = false. The problem is that there is a huge blank area on the first page where the footer is suppressed. Is there a way around this? Or a way to actually make a report footer?

Thanks for the help.
0
Comment
Question by:RMAHelpDesk
  • 2
3 Comments
 
LVL 14

Expert Comment

by:simon_kirk
ID: 16362342
Have you tried adding a textbox to the top and bottom of the Body section of your report?  These would then print like report header and footers.
0
 

Author Comment

by:RMAHelpDesk
ID: 16365448
This is actually what I am doing right now. The problem is the "report footer" needs to print at the bottom of the last page. Doing it the way I am now makes the footer appear last but not neccessarily at the bottom of the page. Any suggestions?
0
 
LVL 14

Accepted Solution

by:
simon_kirk earned 2000 total points
ID: 16426458
Workaround by Chris Hays MSFT:

If you want something different in your last page footer than in the other page footers, you can conditionally show/hide alternate items using the Hidden property like this:

<Hidden>=iif(Globals!TotalPages=Globals!PageNumber,False,True)</Hidden>

If the page footer in the last page is radically different than on the other pages, I recommend putting the contents for each page footer into a seperate rectangle and setting Hidden on the rectangles as a whole (you'll need to overlap the rectangles in the design tool, which will unfortunately make it hard to edit, but easier than manipulating a bunch of individual items).

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

872 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