After a bit of Google searching, I can't seem to find a good solution for the programming request I've been given.
My users have requested to click on my summary report items to see a drill-down of details. In non-management-speak, they would like to click the report result, and see a query (or sub-report) where Service_Center = row value and where Total_Weight is between column value groupings. I have attached a picture for example.
This database is to compute customer service metrics. In this report, the data is showing an average of Days_To_Resolve based on conditions in Service_Center and Total_Weight. Total_Weight is the priority level for the ticket. Given the priority, the goal to resolve the ticket is different: for ticket weights of 11-14 for example, the goal to resolve is 5 days. As we can see in the report, Service Centers 1 and 2 are meeting the goal, but Service Centers 3 and 4 are not. The management would like to click on the report results to see the details behind the calculation, and find out why Service Centers 3 and 4 are not meeting goal.
Thanks for any help anyone can provide!