A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drill Down Report



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2010, 08:44 PM posted to microsoft.public.access.reports
deo
external usenet poster
 
Posts: 3
Default 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  
Old May 3rd, 2010, 09:16 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old May 6th, 2010, 02:06 AM posted to microsoft.public.access.reports
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.