x

How to remove white space between the grouped by columns while collapsing

How do I remove the white space between the grouped by columns while drilling down. It should have the space while expanding the date as shown below. I am using SQL 2005 and Report server project template.

Eg:

+Date                       name            id                  num.of days

Lots of white space till the length of data...and then the next date starts.

Can these spaces be removed? Please reply with any help if anybody has come across

Thanks, Anita

more ▼

asked Oct 21, 2009 at 09:00 AM in Default

Anita gravatar image

Anita
11 1 1 1

I'm not really sure what you mean, Anita. How do you mean 'length of data'?
Oct 26, 2009 at 03:24 AM Rob Farley
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Can you simply shorten the width of the table column?

more ▼

answered Oct 26, 2009 at 03:24 AM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(comments are locked)
10|1200 characters needed characters left
One solution for your problem is to apply the grouping to entire row and not just the texbox that is been expanded and collapsed
more ▼

answered Mar 08, 2013 at 08:24 AM

Samarock gravatar image

Samarock
0

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1943
x546

asked: Oct 21, 2009 at 09:00 AM

Seen: 3435 times

Last Updated: Mar 08, 2013 at 08:24 AM