• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 113
  • Last Modified:

Access 2016 - Drill Down Reporting Question

Is it an option to create a button within a report?

My goal is to start with a top level report for the entire company.
A click on a division would bring up the same report filtered to the data for that division.

Thanks for the insights!
3 Solutions
It is doable but will require a lot more work than a dropdownbox as the filter. If the user doesn't select from the dropdown then show all else show sub-set based on selection
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
better would be to build a form to use for a report menu with a choice of all the divisions.
Then, in the OpenReport statement, use the Where parameter to limit the report for those choices.

I am actually making a video to demonstrate this right now ... will be posted this week
except the requirement is to '..same report filtered to the data for that division.' (singular)
This is another one of those "features" that sounds good on paper but won't make you happy in real life.

Events for controls are only active in Report View.  But Report View has some drawbacks.  For example, it doesn't actually paginate.  There are no page breaks.  It also doesn't run code in the Format or other events.

I would create different reports and let the user choose which level he wants to see from a selection on a form.
DGWhittakerAuthor Commented:
Thanks All!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now