question

Anita avatar image
Anita asked

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

sql-server-2005ssrs
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm not really sure what you mean, Anita. How do you mean 'length of data'?
0 Likes 0 ·
Rob Farley avatar image
Rob Farley answered

Can you simply shorten the width of the table column?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Samarock avatar image
Samarock answered
One solution for your problem is to apply the grouping to entire row and not just the texbox that is been expanded and collapsed
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.