Suggestions For Drill Down Reports?

[Guest]

I have an application where I would like to develop a report that will allow
me to "drill down" to lower level reports.

The main purpose is to organize all of my MS Access reports such that I can
"drill down" to see more details (of reports that were already generated).


Any suggestion would be appreciated!!!

Thank You!

Gary

 

[Allen Browne]

Reports in Access do not support XML style drill-down, and the group levels
must be defined in design view.

The nearest you could get would be to define all the possible levels of
depth you would wish at design time (through the Sorting And Grouping Dialog
(View menu)), and then hide the sections you do not want by setting their
Visible property in the Open event of the report, based on user input
(typically a choice offered in the form from which the OpenReport was
launched.)

The other approach would be to use forms rather than reports. If you use a
form, you can use the DblClick event of the controls to provide detail of
the data behind that control.