Reporting flexibility questions.

[Dean]

I am looking for answers to the following questions:

1. Is there flexibility to define a schedule for automatic
report generation in Access? If so, how can this be done?

2. Is there flexibility to categorize a group of reports
in Access?

3. Is there flexibility to display a report in Access,
using a different format (e.g. .pdf format, .rpt format,
etc.)?

4. Is there flexibility in Access to generate reports in
other Reporting tools, such as Crystal reporting?

5. Can a report be generated, based on a user inputting a
criteria? If so, how?

6. How simple or complex is it to change the format,
criteria selection, and scheduling of a report?

7. How flexible is it to define queries, layouts,
parameters, roles and permissions in Access? What I mean
here is can any user do this, or does a user require
specific access to conduct these activities?

I apologize if these questions sound dumb, but I need as
much information as possible. Your help is greatly
appreciated.

Cheers,

Dean.

 

[Duane Hookom]

There is a query by form in the Corp Tech Demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. This "applet" allows
users to create queries selecting up to 30 fields. They can set criteria and
sort order. The results are a couple clicks from opening in Word, Excel,
HTML, print,...

 

[Graham]

There is a query by form in the Corp Tech Demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. This "applet" allows
users to create queries selecting up to 30 fields. They can set criteria and
sort order. The results are a couple clicks from opening in Word, Excel,
HTML, print,...

Duane

I have been searching for some assistance with a report/query writer
for end users and see you have pointed several people towards your
"applet"
I now have a copy and working thro it - looks intuituve and provided
me with several ideas.

A question: Did you ever finalise the code for using "totals" on
frmQBFSource, or maybe has anyone else made contribution?

Thanks

Grahm

 

[Duane Hookom]

Just this afternoon I think I got it to where I want it. I now have the
Totals done as well as a simple graph view that allows you to choose the
graph type and set a title. There is a merge to Word that creates your merge
file and then opens Word to a blank document with your fields ready to add
to the document. I will probably ship the new file off to Roger Carlson's
site www.RogersAccessLibrary.com and the Access Web
http://www.mvps.org/access/. This file will contain only the query by form
and some necessary tables.

 

[Graham]

Duane - sounds very good - perhaps you could let us know when you have
posted it. Many thanks
Graham

 

[Duane Hookom]

It's there at http://www.rogersaccesslibrary.com/OtherLibraries.asp.

 

[gah]

Duane - many thanks, nice solution.
gah

It's there at http://www.rogersaccesslibrary.com/OtherLibraries.asp.