Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Layout issues with multiple charts and tablix's


Layout issues with multiple charts and tablix's

Author
Message
Rodney Workman
Rodney Workman
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 152
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?
Attachments
report page 1.jpg (12 views, 96.00 KB)
report page 2.jpg (13 views, 72.00 KB)
report page 3.jpg (10 views, 52.00 KB)
neerajstar
neerajstar
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 144
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search