all groups > sql server reporting services > march 2007 >
You're in the

sql server reporting services

group:

NoRows Leaves Extra White Space


NoRows Leaves Extra White Space Anonymous
3/30/2007 1:20:01 PM
sql server reporting services:
I have a report with multiple tables and datasets. The problem is if one of
the tables/datasets doesn't have any data I get too much white space between
the sections. I tried to set the visiblity property on the table but that
doesn't work if there is no data being returned via the dataset.

For example:

John Does (1st table)

Background Info (2nd table)

Education (3rd table)

This looks fine because there is data in all 3 tables/datasets

Now if there is no background info I get this:

John Doe (1st table)


Education (3rd table)

When I want this:

John Doe (1st table)

Education (3rd table)

I can't combine the info to one table for reasons I won't go into.

Thanks!

RE: NoRows Leaves Extra White Space Andy Potter
3/31/2007 10:56:00 AM
Try putting each table inside a rectangle and setting the rectangle property
visiblility to Hidden = True if no rows are returned for the rectangles child
table. Additionally, put all 3 rectangles/tables inside a 'master'
rectangle. This will help control some of your whitespace issues.
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/


[quoted text, click to view]
AddThis Social Bookmark Button