Solved

Blank spaces in a report having subreports sql reporting services

Posted on 2006-11-26
4
1,076 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 Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
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.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

910 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

20 Experts available now in Live!

Get 1:1 Help Now