Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
timfoster
Starting Member
2 Posts |
 Posted - 2013-06-21 : 03:57:39
|
| 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
52326 Posts |
Posted - 2013-06-21 : 04:05:44
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
timfoster
Starting Member
2 Posts |
Posted - 2013-06-21 : 04:42:01
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs[/quote] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 04:57:44
|
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Report not printing correctly on page