x
login about faq Site discussion (meta-askssc)

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 '09 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 '09 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 '09 at 03:24 AM

Rob Farley gravatar image

Rob Farley
5.7k 13 17 19

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

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1834
x486

asked: Oct 21 '09 at 09:00 AM

Seen: 2633 times

Last Updated: Mar 08 at 08:24 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.