Help for Dynamic Grouping!!

Hello to everyone.

I face a problem for gouping. I want to make dynamic grouping in report.

Dynammic Grouping means, I want to provide a parameter named Group By with mutivalues. I can't hide this parameter so that user can select any one value from this dropdown and when he is click View Report, takes that value and group table rows as per parameter selection.

So i want to ask if it is possible to change <groupexpression> in XML code of report dynamically as per selection.

<Grouping Name="table1_CODE">

<GroupExpressions>

<GroupExpression>=Fields!CODE.Value</GroupExpression>

</GroupExpressions>

</Grouping>

This is default grouping, when i select a value from Group By dropdown box from viewer panel it change

<GroupExpression>=Fields!CODE.Value</GroupExpression> value as per parameter value dynamcially.

If it is possible to do then pls reply me soooooooon.

Thanks in advance.

Chris Hays has a Reporting services sleazy hacks blog. He has a post there about dynamic grouping. See if this will solve your problem http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx|||

Thanks a lots.

That's same i want. Thx once again.

When i run report it is ask me to select parameter eventhough i give it default value, is that any one to resolve this problem, so that in default position it shows me report.

If possible then reply,

and U r too good.

thx.

|||

i guess your defaultvalue is invalid

meaning it is not in the parameters source value-column

|||

Thx for reply

I have provide right default value stll asking me to select value,

Reply Me soon

|||

hello,

I am using three parameters for grouing, If one is selected group will be done with that parameter value,

If any two selected grouping will be done with those two parameters in toggle mode.

same for three parameters.

My question is Will anyone tell me expression bywhich i can change visablity of group. means if only one parameter is passed only one group is ativated, if two then respective two groups can be activated, same for three.

Pls reply me soon.

|||

you have to set the initial visibility of your group-headers depend on your parameters

guess you have

group1

group2

group3

details

if you want only to group by group1, set group2 and 3 hidden and

the toggleitem for your details has to be an item in group3

if you want to group by group1 and 3,

set group2 to hidden

toggleitem for group3 has to be an item from group1

the toggleitem for your details has to be an item in group3

you will need many IIFs :)

greets

|||

Thx for replying me.

ur suggetion is helpful to me.

Thx a lot.