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

avatar 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

avatar image

Rob Farley
5.8k 16 22 28

(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

avatar 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.

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:

x2017
x660

asked: Oct 21, 2009 at 09:00 AM

Seen: 3984 times

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

Copyright 2016 Redgate Software. Privacy Policy