sql server reporting services: Dynamic Grouping.. Is it possible? -- sql server reporting services

You're in the

sql server reporting services

group:

Dynamic Grouping.. Is it possible?

Re: Dynamic Grouping.. Is it possible?

Robert Bruckner [MSFT]
3/30/2005 9:59:15 AM

sql server reporting services:

Try the following dynamic group expression:
=Fields(Parameters!TopGroup.Value).Value

This requires that the values (or labels) of the TopGroup parameters have
matching field names in your dataset (i.e. Country, State, City).

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Dynamic Grouping.. Is it possible?

Brian W via SQLMonster.com
3/30/2005 5:55:03 PM

Hello All,

I have a table with 2 groups in my report. When I edit a group I can
specify the expression to "group on" for the groups.

I would like to be able to make the expression, for the top group, a value
from a report parameter so that the user can specify this when the report
is generated.

The Edit Group Window certainly allows me to pick a report parameter but I
am not sure if it would actually work.. nor what the value of the parameter
should be to make it work. Is this possible?

Example:

Top Group: User Selectable (Country, State, City)
Second Group: Product
Detail Row: Sales data for that product/place combo

So the user could say he would like to see sales grouped by
country/product, state/product, or city/product.

Is this doable without creating 3 different reports?

--

Re: Dynamic Grouping.. Is it possible?

Brian W via SQLMonster.com
3/31/2005 4:50:41 PM

Worked like a charm. Thanks.

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn