Page Break problem in reporting services when I use matrix

Question

Post reply

Page Break problem in reporting services when I use matrix

kalyan-413428

SSC Veteran

Points: 219
More actions
February 28, 2007 at 8:56 am

#172613

Hi,
I have the blank page problem in my report. In the report I have a table with contains 50 rows so the table will be printed in two pages and after the table I have matrix and the columns in the matrix are not common. The problem is that if the number of columns in the matrix is greater than 10 then it prints the remaining columns in the next page but at the same I am getting the blank pages in the first table i.e between 1st and 2nd page .
How can I delete the blank pages.
Kalyan

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Kevin Mao-243787 SSChasing Mays Points: 602 More actions · Answer 1

Hi, Kalyan

Could you ensure no much extra space below right and bottom of the matrix?

Attached a sample. Hope it will solve your problem. Kevin

adeeb_nlv SSC Enthusiast Points: 119 More actions · Answer 2

Hi

I'm facing the same problem.

The Matrix I'm using has one static row and a dynamic row that ranges from 10 to say 15 columns. The report is in portrait format to accommodate the columns. Although the number of columns is high, all the columns are displayed on the same page. The problem is that each page is followed by a blank page when I export the report to .pdf. I haven't tried any other format because I need to export the data to specifically a pdf.

In design mode there is a large white space to the right of the matrix. A simple solution is to reduce the white space by pulling the margin closer to the matrix, but doing this is disturbing the look of the report. The report has a header which just doesn't sit well with the rest of the report when I drag the border down.

I guess I'm asking too much here but what I want is for SSRS to ignore the white spaces to the right of the matrix. Any ideas how I can get about doing this.

adeeb_nlv SSC Enthusiast Points: 119 More actions · Answer 3

I found a solution to the problem, a work around actually.

I made a second report of the matrix table I was having the problem with and used it as a subreport in the main report. I max'd out the width of the subreport control as much as landscape mode allows and Voila! I am suffering from horizontal page breaks no more.

Thank Anyway

dj1202 SSCommitted Points: 1829 More actions · Answer 4

That was a clever solution you found. I've also experienced this issue before, as it is quite common. Sometimes I've found the solution to lie in setting the "ConsumeContainerWhiteSpace" property to "True" in the Report properties. Also, playing with the margins or using Landscape layout can help. Thanks for sharing your solution.

adeeb_nlv SSC Enthusiast Points: 119 More actions · Answer 5

"ConsumeContainerWhiteSpace" sounds like the solution I wanted. I'll keep it in mind for future use. Thank you for replying.

Deepak Gupta Valued Member Points: 59 More actions · Answer 6

After trying out all options (ensuring Body width is less than Report + Margins, putting the Tablix in a rectangle, etc), setting the ConsumeContainerWhiteSpace to TRUE worked for me.

Thanks!