Hi Please help

I have a headcount report built on ssrs 2005 matrix data region. My problem is that user would like to drill through to the detail report when needed. I have managed to create a drill through where a user can click anywhere on the data cell and navigate to the details of that number but when they click on total then the report just pick a random cell and pass that as a value.

The report looks like

Perm Temp Vac Total
Accounting 3 1 0 4
Marketing 5 3 1 9
Sales 12 6 7 25
Total 20 10 8 38


Please assist

More information about your scenario and report design would be helpful.

What field(s) are you passing in the drill-through action?
What parameter(s) are you using in the target report to filter records?

Have you captured these values in the target report to test the passed values when you experience the problem?

__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access

Hi Sorry for the late response.

I have managed to resolve the problem with these navigation parameters

[FONT='Calibri','sans-serif']Row =[/FONT] Iif(InScope("matrix1_Row"), ReportItems!Row.Value, "All")
[FONT='Calibri','sans-serif']Column = Iif(InScope("matrix1_Column"), ReportItems!Column.Value, "ALL")[/FONT]

Thanks
Kind Regards