We help IT Professionals succeed at work.

SSRS 2008 Report Footer

cindyfiller
cindyfiller used Ask the Experts™
on
I have read many places that there is no report footer available in SSRS.  I have a report that can vary from 1 page to many pages.  On the last page of the report I need to put a dictionary of terms.  I thought I had found a work around - I put a huge text box after the grand totals and it actually works when you run the report and view it on the screen.  The terms only appear on the last page  and the report looks great as I view it.  However when you save it as a pdf (or do a subscription that sends it as a pdf), there are blank pages thrown in here and there.  A report that should only have 1 page may have 4 or 5 with the blanks.

It's really important that I accomplish this dictionary of terms on the final page.  Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Check this two modifications

1. Set the ConsumeContainerWhiteSpace property for the tablix to true. If that doesn't work.
2. Check that the (Body Height + Header height + Footer Height) = report page size height (body width = header width = footer width = report page size width)

If the Containers in the content has more width or height then this will occur.
cindyfillerDirector of IT

Author

Commented:
I didn't know about the consumecontainerwhite space - but when I checked it was already set for True.  And I'm not using a header or footer at all so that size of the page isn't an issue.

However I did notice that my final text box with my terms is not the width of the page.  I'm not sure if that will make a difference but I'll try merging the cells and see what happens.

Commented:
Check all the containers in the report are not exceeding the width and height of the report.

Set ConsumeContainerWhiteSpace property to true for the report properties also and others like tablix. so that all the white spaces will be removed.

For better Idea may I know what does all your report contains?
cindyfillerDirector of IT

Author

Commented:
This report is a gift report that shows donations that have come into our office.  It is mostly detailed lines, but does have 1 group that subtotals by 2 values (certain type of group).  At the end of each group I sub total the dollars and at the end of the report I have a grand total.  I've removed the white space but now the totals are printing on the last page of the report instead of right after the detail lines.  FYI, I have 4 parameters:  begin and end date and then college and department.  This is really noticable when I do a single college/department because there may be only 2 or 3 detail lines on the first page and then the last page has the totals and the terms.
Harish VargheseProject Leader

Commented:
Hello,

Will it be okay for you to attach the RDL here?
And if you are using stored proc for dataset, then the stored proc too?

Thanks,
Harish
cindyfillerDirector of IT

Author

Commented:
Sorry for the delay in responding... between a server crash and an employee quitting I haven't had time to get back to this.  I did want to mention that the report also prints just fine - it is only when it does the pdf that there is an issue.  So viewing and printing is good and pdf is bad.  I'm attaching the rdl - wasn't sure if that would work since the data isn't attached but here you go!  And thanks for working on this.
Stewardship-Thank-You-Report-Det.rdl
cindyfillerDirector of IT

Author

Commented:
I removed a column from the report and found that it now renders as a pdf just fine.  Even though the body, header, etc was less than the page width it was close and shaving a little off the body width did fix this issue.  So your first comment actually solved the problem.  

However, in tweaking this I made some other changes and now the sub total and grand total both print on just the last page with the terms that I was trying to isolate... so I'm not sure how to resolve that!

Commented:
Can we see your sample report design pictorial representation?
cindyfillerDirector of IT

Author

Commented:
Can this be reopened?  I'd like to get an answer, but due to emergencies I haven't been able to get back to this.  If I can't get an answer in the next week I'll close the case.

Commented:
Yeah welcome. What is the problem exactly?. I didn't get you. Problem with the subtotal, grandtotal and terms that's what i understood. What is your requirement?.
cindyfillerDirector of IT

Author

Commented:
I need the subtotal and grand total on the same page as the detailed items (when it fits).  I then need the terms on a separate page.  Right now I may have a page with 5 detail lines and then the subtotal and grand total go to the next page with the terms.
Commented:
Can you try removing the terms from the current table and keep them in the another table seperately. Check the page break before property in the tablix properties.

For the sub total aand grand total for being in the same page. Does the page still have the room for these totals to present?.
cindyfillerDirector of IT

Author

Commented:
Yes - the detail lines may end 1/3 of the way through the page so there is plenty of room for the totals.  If there wasn't room I'd understand why they were on another page.

You know...  you mentioned putting the terms on another table.  I hadn't thought of that - it sounds like a simple solution that should work.  I'll try that!

Commented:
Great we solved the issue.