SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Report not printing correctly on page
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

timfoster
Starting Member

2 Posts

Posted - 06/21/2013 :  03:57:39  Show Profile  Reply with Quote
I have a report that uses five sub reports on page one. The report has two sub reports on the left of the page and three on the right. The three on the right should stretch down the page so that the first one top aligns with the first one on the left, and the last one bottom aligns with the second one on the left.

I can get the five to show on a single page, but I have to have a large amount of space at the bottom for this to work. If I stretch the bottom sub report on the left down, even by 0.05cm it will create a blank page two, despite there now being a 4-5cm white space at the bottom of the report. The top and bottom margins are both set to 0.5cm, so on an A4 page (29.7cm) this should still give me 28.7cm of usable space.

Can anyone suggest a way to make it stretch the length of the page without creating this awful blank page?

I think the best solution would be the ability to set the height/width of the sub report controls (or the body of the actual sub reports) dynamically. I can work out the space each sub report needs from the data returned, but SSRS doesn't allow sizes to be set with an expression.

Any help would be appreciated.

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/21/2013 :  04:05:44  Show Profile  Reply with Quote
unless you post current reports screenshot and then explain how you want the report to come with another indicative screenshot, its quite difficult for us to understand the required layout

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

timfoster
Starting Member

2 Posts

Posted - 06/21/2013 :  04:42:01  Show Profile  Reply with Quote
I've attached 3 screen shots to show what I have and what I want to have.

The first shows what the layout currently looks like. AS you can see the page finishes at approx. 23cm. All the sub reports are squashed up together. This works (sort of) and displays all five reports on page one. If I move the report on the left down, even slightly, it creates a blank page two despite there clearly being room to increase the size (the margin shows that the report sits at approx. 23cm. The report itself doesn't stretch any further than the sub report frame.



This next image shows the spacing I want to have between the reports on the right.



And this third image shows the bottom of the last two sub reports (with the page break removed) to show where the two reports at the bottom of the page should sit. The three reports on the right can be variable in length, but they will only every contain a maximum of six rows of data and so will fit easily into the space allowed.

Running this version of the report gives me the blank page 2 with or without the page break.



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

[/quote]
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/21/2013 :  04:57:44  Show Profile  Reply with Quote
what you need to do is to wrap the reports inside rectangles and then put a blank rectangle with required space in between. there should be an outer rectangle which covers the reports to make sure bottom of reports coincide. I hope the reports (at least botton ones) doesnt show varying data in which case it might be a challenge to get them aligned properly.

Also so far as all reports fall within normal A4 page width for the report (either portrait or landscaoe based on report size) it will not generate empty page

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000