Matrix drill through problem

So here goes the explnation. The problem is specifying an all parameter in a drill through on the value cell of a matrix for the columns in the matrix that are not expanded.

Here goes the example

Matrix for sales.

Region | Shop | Number of sales. And then financial period would be at the top. Everything is collapsed on load so it looks something like this.

Region1 | | 50

Region2 | | 75

Then you expand Region.

Region1 | Shop1 | 30

Region1 | Shop2 | 20

Region2| | 75

At this point if you click on the 30 for shop 1 is drills through into another report passing parameter Region1, shop1 and financial period. This is perfect. The problem comes in that if you haven't expanded region1 and you click on the 50 it drills into the other report but passes through Shop1 as the shop parameter. How can I get this to pass though an all option for the unexpanded columns in the matrix. This is ofcourse just an example and my matrix has quite a few more column and stuff.

Please guys, any help would be appreciated.

This is Reporting services 2005 linking to SSAS2005 cube.

Thanks in advance

Hello,

Try this: http://msdn2.microsoft.com/en-us/library/ms156490.aspx

|||

Yeah.

iif(InScope("MatrixColumnGroup"), ParamaterIfTrue, ParameterIfFalse)

On interesting thing about this. Is that in BIDS the drillthrough doesn't work on the totals but it works on the report viewer control. I think this is a bug. If you drill through on a total it will take the first row grouping as the parameter but if you drill through from a front end using the report viewer control it works perfectly.

Good luck, thanks for the help.