Page Break problem in reporting services when I use matrix

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Page Break problem in reporting services when...

Page Break problem in reporting services when I use matrix

Rate Topic

Display Mode

Topic Options

Author

Message

kalyan-413428

Posted Wednesday, February 28, 2007 8:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 28, 2007 9:28 AM
Points: 1, Visits: 1

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

Post #348159

Kevin Mao-243787

Posted Wednesday, February 28, 2007 12:39 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 26, 2012 1:35 PM
Points: 170, Visits: 183

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

Post #348253

adeeb_nlv

Posted Friday, September 21, 2012 7:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 10:24 PM
Points: 3, Visits: 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.

Post #1362648

adeeb_nlv

Posted Monday, September 24, 2012 10:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 10:24 PM
Points: 3, Visits: 2

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

Post #1363773

dj1202

Posted Tuesday, September 25, 2012 9:56 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 28, 2013 1:20 PM
Points: 65, Visits: 219

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.

Post #1364153

adeeb_nlv

Posted Tuesday, September 25, 2012 10:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 10:24 PM
Points: 3, Visits: 2

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

Post #1364428

« Prev Topic | Next Topic »

Permissions