SSRS 2008 Report Footer
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?
It's really important that I accomplish this dictionary of terms on the final page. Any ideas?
ASKER
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.
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.
Check all the containers in the report are not exceeding the width and height of the report.
Set ConsumeContainerWhiteSpace
For better Idea may I know what does all your report contains?
Set ConsumeContainerWhiteSpace
For better Idea may I know what does all your report contains?
ASKER
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.
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
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
ASKER
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
Stewardship-Thank-You-Report-Det.rdl
ASKER
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!
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!
Can we see your sample report design pictorial representation?
ASKER
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.
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?.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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!
Great we solved the issue.
1. Set the ConsumeContainerWhiteSpace
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.