Dynamic Row group in matrix
Hi All ! 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,
October 9th, 2006 10:19am
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)
October 9th, 2006 11:07pm
Look at this blog entry from Chris Hayes http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx
October 10th, 2006 1:32pm
thanx for ur help.I have done this with some other logic.
May 24th, 2007 11:35am
Hi Sanjib, I have this same problem. you can help me, Please ...
December 9th, 2010 1:51pm