January 27, 2016 at 3:53 pm
In a new SSRS 2008 report, I have one main tablix and I will be embedding 5 existing tablixes into the one main tablix. For each row in the main tablix, I will be embedding 1 of the tablixes. There will be one dataset used and the same parameters are used between the 5 existing embedded tablixes. One of the parameters is to allow the user to select report number 1,2,3,4, or 5 which is an integer value. The default will be to select all the reports.
The selection of which reports will be displayed will be from the main tablix on row visibility for each embedded tablix. Each tablix will be set to 'add a page break after'. This works fine except the last page of the last report will always have a final blank page. I basically do not want that final page break to appear.
Thus is there a way to not have the final page break show up? Could I use some kind of condtional page break logic? If there some kind of a way to determine what the highest number report is that is selected and not allow a final page break to occur in that situation. If so, how would you setup that code?
If not, can you tell me a way that will solve this issue and show me the code, show me the screen prints, and or point me to link(s) that will tell me how to solve this problem?
January 29, 2016 at 9:11 am
Press F4 and click on the Drop Down in the properties window and select "Report".
Change the ConsumeContainerWhitespace property to True. This is pretty well known issue, you should be able to find plenty of answers with Google.
January 29, 2016 at 10:34 am
Thank you very much for your answer!
I did set ConsumeContainerWhitespace property to True in the report. I cleared the data cache. I also calculated the width and height of the report and they are within the expected size of a portrait sized paper.
The suggestion you made did not solve the problem.
Do you have any other ideas of what I could try?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply