Dynamic Grouping.. Is it possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian W - 30 Mar 2005 18:54 GMT

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?

Reply to this Message

Robert Bruckner [MSFT] - 30 Mar 2005 18:59 GMT

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

Signature

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

> Hello All,
>
[quoted text clipped - 20 lines]
>
> Is this doable without creating 3 different reports?

Reply to this Message

Brian W - 31 Mar 2005 17:50 GMT

Worked like a charm. Thanks.

Reply to this Message