QBF/Query on report

  • Thread starter Jean-Francois Gauthier
  • Start date
J

Jean-Francois Gauthier

Hi folks,

I have numerous reports that are based on different queries. What I am
looking for is a way that if a user wants to pull a certain report, that when
this report is selected from a form, the user has the option based on
different fields to drill down the information being returned in the report.

For example, one report would give details of all invoices to be paid
(considered incomplete).

I want to give the option to the user to select the from and to dates that
the invoice was received for example.

Or again, the user may want to search for all unpaid invoices that belong to
a particular fund center (another field).

The user may want to select one or more invoice types.

These are all high level examples of what I want to happen.

I want the user to select the report that he/she wishes to have, and then
based on this report be able to narrow down the amount of data that is
returned by these option.

I have a query that makes a table called "tbl_reports" that gives the list
of the reports.

I have a dropdown box on this form that gives the available reports.

when a particular report is selected, numerous search options would show on
the form. No problem here.

Then the user inputs its criteria and then selects to run the report.

What is the best way to do this, so that this becomes very user friendly for
the user. These users have very limited knowledge of access so I can't
exactly ask them to go into a query and change the criterias....they'll screw
everything up....

If I can somehow get into the report's query and change the criterias based
on the fields on the form mentionned above, but that once the report is ran
and close, that the query defaults back to its original, I'm ok with that,
howevr I'm not sure how to go abouts getting something like this to work.

Looking forward to responses, I know this is kind of vague, but pplease ask
questions if you need more info, otherwise I'm just trying to get a feel as
to what I will need to do to make this work.
 
J

Jeff Boyce

Jean-Francois

I use this "Order Reports" approach myself.

On the form, I enable/disable selection criteria controls based on which
report is selected.

Then, in the <Print Preview> command button code, I dynamically generate a
WHERE clause using the controls that are 1) enabled, and 2) have
selected/entered values. The <Print Preview> button code then uses this
WHERE clause in opening the selected report.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top