Report Drill-Down: Click on Report Result, Open Query

[kagoodwin13]

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!

[pbaldy]

You could adapt this:

http://www.baldyweb.com/wherecondition.htm

hard-coding the second condition.

[ranman256]

I dont think this (drill down) can be accomplished via reports.
Tho the method we use is show the reports in a form list ,user picks the rpt: 1 is summary, 1 is detail.

[pbaldy]

I dont think this (drill down) can be accomplished via reports.

It can in Report view.