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)
Free Windows Admin Tool Kit Click here and download it now
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.
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2007 11:35am

Hi Sanjib, I have this same problem. you can help me, Please ...
December 9th, 2010 1:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics