I want to show row groups as hierarchy levels and need the
sub total values belongs to each group and sub group levels. But the
most important point is that my top next top group (from child to
parent ) is not static its dynamic.i.e for a diffrent senario my under
displayed example can have Universe>Earth as parent for Australia and USA.
eg:
1.Australia
|-sydney
|-Melbourne
2.USA
|North US
|North US(1)
|North US(2)
|South US
|South US(1)
|South US(2)
Can I get some help from anybody for making a dynamic row groups in the matrix.
Waiting for a kind help.
Regards,
This is the Dynamic Group I used. I am not the original author, I search on dynamic grouping for SSRS and modified the example showed.
Put this is group expression:
=iif(Parameters!Group_By.Value is Nothing,Fields!SomeField.Value , Fields(iif(Parameters!Group_By.Value is Nothing, "DefaultID",Parameters!Group_By.Value)).Value)
|||Look at this blog entry from Chris Hayes http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx|||thanx for ur help.I have done this with some other logic.
