• The way to do this in reporting services is...

    - create a report that has the details

    - in the matrix, add an action to the cell that you want to drill down on (in BIDS, right click on the text box, select textbox properties and then go to "Actions"). In the action, Select "go to report" and then fill in the relevant details