Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Blank spaces in a report having subreports sql reporting services

Posted on 2006-11-26
4
Medium Priority
?
1,392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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…
How to increase the row limit in Jasper Server.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

610 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