Wednesday, March 7, 2012

Matrix - Column Grouping

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.
"RA" <rchaudhary-nospam@.storis.com> wrote in message
news:OTVO0hGZEHA.2840@.TK2MSFTNGP11.phx.gbl...
> 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?
>

No comments:

Post a Comment