Solved

Blank spaces in a report having subreports sql reporting services

Posted on 2006-11-26
4
1,054 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now