Hiding parent column groups in matrix control

I use matrix control in my report. Thre are 4 column groups in that control : Year, Half year, Quarter, and Month. I can expand the groups from Year to Months using drilldown. But I would like to see the only group at a time: Half year or Months or Quarter or Year. I tried to solve this task in following way:

- Created parameter named DateMode containing four labels :

Year,half year, quarter, month, and ennumerated them 1,2,3,4 . They appeared in combo box in report.

-Set visibility expression for each group like: Parameters!DateMode.Value<>1 ( 2,3,4 ).

- Uncheck "Visibility can be toggled by another report item"

So in my opinion matrix control should show only one group selected in combo box.

But it is working only for Year. If I select another date mode, there is not column titles shown and data always are shown for Year.

If anybody already solved similar task, please share.

Thanks in advance.

Dima,

the visibility is triggered via true or false - therefor you will have to build up an expression like:
=IIF(Parameters!DateMode.Value = 1,true,false)
for the year group and
=IIF(Parameters!DateMode.Value = 4,true,false) for the month group

you could also have a look here http://www.msbicentral.com/ for some more suggestions.

hth....

cheers,
Markus