Reporting Services on Cube: Stop parameters from cascading

Hello,

I'm using a SSIS cube as source for reporting services. In my DataSet I have 3 parameters: Year, ProductGroup, Product. By default all parameters are cascading when defined on the DataSet. This is great for ProductGroup -> Product, but I don't want it for Year -> ProductGroup (I want to avoid the roundtrip). I removed the link in the generated MDX, I removed the parameters on the DataSet, but when I run the report, ProductGroup is still grayed out until I choose a year.

Suggestions are very welcome...

This is most likely issue/bug with the VS.NET Report Designer. The parameter most likely won't be grayed out when the report is rendered in the Report Manager.

|||Thank you Teo, but the parameters stay greyed out in Internet Explorer. So it must be something else.|||I just found out that the behaviour is caused by a parameter that has a default value of NULL, and only if that parameter is before the greyed out one.

So if I have parameter A with default NULL en parameter B default ALL. And A is before B in the list, B is greyed out. If B is befor A in the list, neither is greyed out.

So, I guess my only option is setting a default for every parameter?