Drill Down functionality in Access Reports

[JDavey]

Does anyone have any input about adding drill down functionality to Access Reports? I'd like the user to be able to click on a graph that's on a report and get underlying data.

Any help is appreciated!
Thanks

 

[VogonPoet]

What do you mean by "drill-down"?

If you are only looking for the values of the data points, you can include a "data table" in the graph design. This will place a table at the bottom of the graph (for line graphs) with the values for each data point.

I hope this is helpful.

 

[JDavey]

Thanks for your response. I think the best example of what I'm referring to is Quicken-style reports where, if there are five bars on a graph each representing sales for a different month and the user wishes to view the underlying data of a specific bar, they could basically trigger another report of the customers that made up those sales by clicking on that bar in the graph. I'm guessing that this will have to be done via some custom VBA but I wasn't sure if there was a control out there that already had some of this functionality.
Thanks.