InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:41:35 GMT20http://www.sqlservercentral.com/Forums/Topic993403-1063-1.aspxThanks Steve, I think that will come in very helpful for me in the future too...Mon, 27 Sep 2010 15:56:28 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic993403-1063-1.aspxI do this a lot in my reports. You can even tailor the layout of your headers and Detail areas using the same expression.Enter this in the grouping expression box.If you just have the two Choices:=iif(parameters!Parametername.value='State', Fields!State.Value,Fields!Company.Value)If you jave more than two=iif(parameters!Parametername.value='State', Fields!State.Value,Fields!Company.Value) iif(parameters!Parametername.value='Company', Fields!Company.Value, Etc. ) )When I do something like this I also add a extra Header row and details row for each choince i the drop down.Then I Set the Visibility I useing the same expression=iif(parameters!Parametername.value='State', False,True) For the State Header and Details row=iif(parameters!Parametername.value='State', False,True) For the Company Header and Detail RowThis gives you a lot of control over what gets displayed when either group is selectedMon, 27 Sep 2010 06:07:26 GMTSteven.Howeshttp://www.sqlservercentral.com/Forums/Topic993403-1063-1.aspxHi Pravin,Do you want to perform grouping in sql query or else in your report layout?Mon, 27 Sep 2010 03:05:15 GMTpeace.coghttp://www.sqlservercentral.com/Forums/Topic993403-1063-1.aspxHi,I'm developing a SSRS 2005 report, where grouping depends on the value selected as the parameterEx: Parameter dropdown has 2 values i.e., 1) state and 2) company1) If i select state, then the grouping should be as follows state and then company2) If i select company, then the grouping should be as follows Company and then state can we dynamically change grouping depending on the parameter value selected ?ThanksPravinSun, 26 Sep 2010 18:09:36 GMTsql.pravin