Reporting flexibility questions.

  • Thread starter Thread starter Dean
  • Start date Start date
D

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 said:
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,...
Click to expand...

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
 
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.
 
Duane - sounds very good - perhaps you could let us know when you have
posted it. Many thanks
Graham
 
Back
Top