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

Layout issues with multiple charts and tablix's Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 8:50 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:12 PM
Points: 15, Visits: 130
I have a report with 11 tablix's, 4 charts and may be a list or two. To attempt to control page breaks I have two rectangles with each of the report objects contained within. I am expecting two pages, but I am getting three. The first rectangle seems to be doing pretty good. The second rectangle towards the bottom I have a chart to the left and a tablix to the right of the page. The tablix grows longer than the chart but the width is constant. The report renders the tablix to the right of the page. In print layout it appears on its own page.

Examples attached.

The body plus the margins equals the report width. The chart and tablix are not overlapping and are within the borders of the rectangle and the rectangle is within the body width.

I have for testing purposes made the chart smaller in width and the tablix smaller in width. That had no effect.

I have for testing purposes placed the tablix on the left and the chart on the right, in this scenario the chart is rendered on a page by itself.

I tested another layout and have them in a single column instead of side by side and that works but its not the layout the client wants. But this tells me there is plenty of page height available.

I wish there was something I could examine or analyze to help me understand what made SSRS decide to render the report this way. What condition(s) did SSRS find that made it think the content ran over the page size?

What options do I have to keep the content on the same page?


  Post Attachments 
report page 1.jpg (12 views, 96.59 KB)
report page 2.jpg (12 views, 72.69 KB)
report page 3.jpg (10 views, 52.16 KB)
Post #1421690
Posted Thursday, February 21, 2013 9:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:05 AM
Points: 95, Visits: 98
Hi,

Try this, might be it help.

Right Click on Rectangle ->properties-> see weather the option "Keep contents together on a single page, if Possible" is check or not. if not then check it.

Thanks,
Neeraj
Post #1422680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse