Solved

Blank spaces in a report having subreports sql reporting services

Posted on 2006-11-26
4
1,130 Views
Last Modified: 2008-01-09
I have a report which has 2 subreports in it. (i.e main report calls subreport1 which calls subreport2). Now when  I run the main report there are blank spaces between each group ( the report sorts by  2 columns) therefore for each change in a group there appears a blank space. How can i get rid of this space.

Also when i print  the report blank pages appear.  what could be the probale cause?

Thanks
shri
0
Comment
Question by:kiran_shri1
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 18018006
Hi kiran_shri1,

Blank pages in reporting services when printing are typically (at least in my experience) due to the content of your page being wider than (page width - left margin - right margin).

Check what page setting you have, and ensure that your tables / subreports / columns etc are not too wide.

As for the blank space, my guess is that you have blank space within one or both of the subreports which is being combined for each group (i.e. space at the bottom of each subreport) that is causing the extra space.  Trim down the subreports so that there is absolutely no extra space (except where you really want it).  If you then put the subreport into a bigger container on the main report, then only the required space (as per what is on the main report) will be created.

Cheers,
Hillwaaa
0
 

Author Comment

by:kiran_shri1
ID: 18023141
Hi Hillwaa

Sorry I forgot to mention the spaces appear when I deploy the report to the report manager (web based), the spaces do not appear if i print the report. I have ensured that there are no spaces in the subreport layout (in properties i checked the page size and set the report body to the same). There are spaces even between the column title (which is on the main report header) and the actual columns.... cant seem to figure out who the culprit is

thanks


0
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 total points
ID: 18025585
OK - that's not something I've run into before...

I'd suggest removing each of the sub reports (and just leaving blank space in the main report where they used to be) to confirm that they are not the culprits :)

and / or

To help see what things are doing - try setting the BackgroundColor property of each element (table textbox, lists etc) to a different colour.  That way when you deploy it to the web, you can see which of them is growing and pushing your formatting out...
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS Row visibility 2 359
Dynamic Hyperlink in Access 2013 10 742
How to learn business intelligence strategy 12 102
Custom report tool for users in Access 19 175
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question