Blank spaces in a report having subreports sql reporting services

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
kiran_shri1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HillwaaaCommented:
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
kiran_shri1Author Commented:
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
HillwaaaCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.