Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Page Break problem in reporting services when I use matrix Expand / Collapse
Author
Message
Posted Wednesday, February 28, 2007 8:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, February 28, 2007 12:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, September 21, 2012 7:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, September 24, 2012 10:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, September 25, 2012 9:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, August 17, 2013 7:45 PM
Points: 65, Visits: 228
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
Posted Tuesday, September 25, 2012 10:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse