Drill Down Cross Tab Problem
Posted: Wed Jul 21, 2010 4:50 am
Hi All
Having a little problem with setting drill down parameters on my cross tab, I have one column expressed and multiple summaries. My column is an employees name and the summaries are various stats about the employee (Hours worked, number of sales etc:) I want to set the Column (Employees Name) to be an interactive drill down to a second page and I want the name of the employee to be the parameter passed to the second page.
Drill down properties set up like below:
Drill Down Parameter 1 - EmployeeName,Data.EmployeeName
Name - EmployeeName
Expression - Data.EmployeeName
At the minute if I have more than 1 Employee on the report, no matter which name you click on, it will always pass the last employee name to the drill down page.
Anyone know why this is? or how to solve it?
Thanks
Having a little problem with setting drill down parameters on my cross tab, I have one column expressed and multiple summaries. My column is an employees name and the summaries are various stats about the employee (Hours worked, number of sales etc:) I want to set the Column (Employees Name) to be an interactive drill down to a second page and I want the name of the employee to be the parameter passed to the second page.
Drill down properties set up like below:
Drill Down Parameter 1 - EmployeeName,Data.EmployeeName
Name - EmployeeName
Expression - Data.EmployeeName
At the minute if I have more than 1 Employee on the report, no matter which name you click on, it will always pass the last employee name to the drill down page.
Anyone know why this is? or how to solve it?
Thanks