2nd request: group visibility issue

Hi,
I have a report with a SP datasource. The groups have drilldown
capabilities. I have conditional expressions on groups 1 and group 2 that
when a flag in the proc is one value then something like this is displayed:
region 1
district 1
facility A data data data
facility C data data data
facility F data data data
district 2
facility B
facility D
...etc
Then, when the flag is another value, I want to display just the facility
list without the groups. I almost have this successfully implemented, by
having conditionals on groups 1 and 2. It is something like this:
=iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
The only problem is that when I disable the groups like that, I still get
the drilldown's plus sign at the top of the facility list.
+
+
Facility A data data
Facility B data data
etc
I don't want them there. Hope this is clear.
Thanks
--
Patrick StadlerYou cannot conditionally "remove" groupings.
You may try duplicating the table/matrix and remove the groupings for the
copied data region. Depending on the parameter values you would always just
show one of the data regions.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stads" <Stads@.discussions.microsoft.com> wrote in message
news:F4FCE3A3-1389-4F00-AB4F-BE3BBDB6A519@.microsoft.com...
> Hi,
> I have a report with a SP datasource. The groups have drilldown
> capabilities. I have conditional expressions on groups 1 and group 2 that
> when a flag in the proc is one value then something like this is
displayed:
> region 1
> district 1
> facility A data data data
> facility C data data data
> facility F data data data
> district 2
> facility B
> facility D
> ...etc
> Then, when the flag is another value, I want to display just the facility
> list without the groups. I almost have this successfully implemented, by
> having conditionals on groups 1 and 2. It is something like this:
> =iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
> The only problem is that when I disable the groups like that, I still get
> the drilldown's plus sign at the top of the facility list.
> +
> +
> Facility A data data
> Facility B data data
> etc
> I don't want them there. Hope this is clear.
> Thanks
> --
> Patrick Stadler