- Select textbox where you need to put the drill-through action
- Select Action in the text box properties
- Specify the report you want to add as a drill-through report
- Add parameters to the drill-through report
parmDate_Month [@parmDate_Month]
parmDivision [Employee. UniqueName]
Also, make sure that within your report dataset you specify the DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
SAMPLE CODE:
WITH
SELECT NON EMPTY
{
} ON COLUMNS
, NON EMPTY
{
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [SampleCube]