all groups > sql server reporting services > january 2005 >
You're in the

sql server reporting services

group:

change grouping at runtime


change grouping at runtime Stads
1/10/2005 10:05:02 PM
sql server reporting services:
I have a report with a large result set that can be grouped multiple ways.
Is there a way to give a user the option to change the grouping level at
runtime. For example if my data was grouped like this:

A
B
C
C
B
C
C
But instead of seeing the grouping broken up by "B", the user wants to view
the data without the "B" groups. They could have a drop-down list or
something that lets them switch it to be:
A
C
C
C
C

Hope this makes sense and someone has an idea.
--
RE: change grouping at runtime Aiwa
1/11/2005 6:03:01 AM
Hi,

I have the same functionality in some of my reports and what I end-up doing
is create a grouping parameter for my reports and use this parameter.value to
group my data within my report table ...

HTH,
Eric

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