If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drill Down Report
Hi,
I have a report grouped by Office (4), Department and then by Managers. The staff and the funtions are in the detail section. Is it possible to have a report - a sort of drill down report that would first show all the office totals and you can then click on an office and see all the department then click on a department and see all the managers and finally click on a manager to see the detail for that manager. If this cannot be done in Access does anyone know of another viable solution. Thanks |
#2
|
|||
|
|||
Drill Down Report
A report is for giving you a printout of your data in a specified format.
What you are asking is more in line with viewing your data. Forms are used to view data. What you are requesting to see is easily done with forms. Are forms more what you want? Steve "Deo" wrote in message ... Hi, I have a report grouped by Office (4), Department and then by Managers. The staff and the funtions are in the detail section. Is it possible to have a report - a sort of drill down report that would first show all the office totals and you can then click on an office and see all the department then click on a department and see all the managers and finally click on a manager to see the detail for that manager. If this cannot be done in Access does anyone know of another viable solution. Thanks |
#3
|
|||
|
|||
Drill Down Report
This post explains it well:
http://www.eggheadcafe.com/forumarch...st25773951.asp Lots of other reporting tools and graph components support drilldown. For example Microsoft SQL Server Reporting Services (just to stay with microsoft tools) You could use forms to do this and have various button to launch a report at the level of detail needed. Try a google search on "drill down reporting tools" HTH, -- Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationmanagementsoftware.com "Deo" wrote in message ... Hi, I have a report grouped by Office (4), Department and then by Managers. The staff and the funtions are in the detail section. Is it possible to have a report - a sort of drill down report that would first show all the office totals and you can then click on an office and see all the department then click on a department and see all the managers and finally click on a manager to see the detail for that manager. If this cannot be done in Access does anyone know of another viable solution. Thanks |
Thread Tools | |
Display Modes | |
|
|