sql server reporting services: I am using Matrix table for one of my reports

..

I would like to have three column groupings; where first grouping is
default. Other two should be based on the parameter selection. If '<None>'
is selected from the parameter option I do not want to show that secondary
grouping.



Is it possible?

I'm not sure what you are trying to do.
If you just want to dynamically toggle the visibility of groups within a
matrix, you should install and check out the sample reports (e.g.
CompanySales.rdl). Also read BOL:
http://msdn.microsoft.com/library/en-us/rshowto/htm/hrs_designer_v1_0zvx.asp

However, if you want to statically "hide" detail groupings based on
parameter values you should use a dynamic column grouping expression based
on IIF. If you want to always "hide" a certain inner grouping based on a
parameter value, you would just group on a constant (and make sure to use a
similar expression for the column grouping label):
=iif(Parameters!P1.Value = "None", 1, Fields!ProductCategory.Value)

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]