SSRS 2008 Blank page at end issue
Hi, I'm struggeling with my main report (landscape orientation) that consists of 5 tablixes that are vertrical alligned on the report body. Table #1 .. #3 are always visible whereas Table #4 and #5 are conditional visible (Hidden =CountRows("myDataset") = 0) Table #3 has a conditional pagebreak with these properties set: BreakLocation: End Disabled: =iif ( CountRows("ds_ADA_BILD") = 0 , True , False ) ResetPageNumber: False When I preview the report and the Hidden-expression for Table #4 and #5 evaluates to True I get an extra blank page at the end of my report. What I have done so far: Set Report property ConsumeContainerWhiteSpace=True Body width <= (Report page width - margins size) Remove table #5 from the body and run the report: Result: No extra blank page So, when all the tables of my report are visible there is no extra blank page at the reports end. Only when table #4 and #5 are hidden my report produces an extra blank page. The layout of table #5 is basically identical with table #4. I read several related threads regarding the issue but still can't find out what the problem is. Any ideas are greatly appreciated. Thanks, Bodo
May 22nd, 2012 11:07am

did you check the option "add page break after" if yes, uncheck it...
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2012 12:05pm

check this information at http://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr4
May 22nd, 2012 12:36pm

Thanks shivin, I focused on the CanGrow properties of the table #5 that I suspect to cause the page break. Each table cell CanGrow is now set to false but it didn't help The PageBreak setting of Table #3 is based on a condition, so if the dataset of Table #4 has rows do a pagebreak at end else no pagebreak.
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 6:32am

put the break location as "Start" instead of "End", it should work.
May 23rd, 2012 4:19pm

put the break location as "Start" instead of "End", it should work.
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 4:21pm

Eventually I managed to eliminate the extra blank page at the end of my report by removing any vertical space and reducing the page width. Thanks Bodo
June 26th, 2012 5:00am

Hi Bodo, Also have a look at the property called ConsumeContainerWhitespace http://beyondrelational.com/modules/2/blogs/115/posts/11153/consumecontainerwhitespace-property-to-remove-blank-space-in-ssrs-2008-report.aspx- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2012 5:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics