Creating a menu of available reports

C

Cool_Creature

Hi,

I realise this is quite a simple sounding question but what is the "best
way" to present a menu of reports to a user. I've done this myself with a
page of buttons which call individual reports but feel that this isn't very
elegant. Can you suggest a "better" method.

Michael
 
S

scubadiver

Try this SQL. It will "hopefully" list all your reports.

SELECT MsysObjects.Name AS QryName, MsysObjects.Type
FROM MsysObjects
WHERE (((MsysObjects.Type)=-32764));
 
C

Cool_Creature

Thanks for that. Just to clarify, do you place this as the data source in a
list box?
 
F

frank knuckles

You could create a table in your database storing the actual report names,
the screennames you want to present to your user, and additional info, for
instance about sorting preference. You could make a query which you can use
for a combo box. In my outputform I usually have 2 cascading combo boxes: 1
for the main categorie and 1 for the actual report. I also have a button
that either executes the chosen report, or, when necessary does some
preliminary work before the report is opened. In the table I have also a
field where the value is stored which determines if the report needs date
range entries by the user. On the basis of that value I make the date entry
fields enabled/disabled.

Maybe this idea can be of use to you.

FK
 
A

Albert D. Kallal

When I do is I often have several reports that I don't necessarily want my
users to see, and therefore I simply build a table with a list of reports
that I want.

In that table I have several columns, the first column is the name of the
report, the second column is a very nice description of what the report
does. that way for each new report that you add, you simply type the name
into the table, the description into that table, and then you build a form
with a list box based on that table, and also a button to launch the report.

There are some screen shots here that show the idea in several places:

http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

The code Behind the launch report button these very simple:

docmd.OpenReprot me.MyListboxName

Note that in most of those list boxes, I actually hide the first column or
make it zero length in the list box format, so you actually don't see the
report name, and the user really for most cases does not need to see the
report name anyway.
 
C

Cool_Creature

Albert,

Very nice and elegant - seems like a good approach and I'll certainly use.
Thanks,

Michael
 
Top