Generating Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2002 and FrontPage 2002. Right now I produce reports by
getting persons to submit info through a web form to Access. I then download
this database, merge it with a Word document, then post individual reports to
a web site or email the reports to the client. I find this process tedious.
Is there a better way to generate reports? Using Acess Reports? And
Frontpage somehow?

Thanks in advance, Paul
 
I suspect that you can add some ASP or ASP.NET pages to your Front Page that
use COM automation to produce the reports using Access (provided Access is
installed on the server, which it often is not). I have not done this, but
am suffiently familiar with both ASP and Access to know that it could be
done.

Alternatively, I've seen some impressive reports that were generated online
with Crystal Reports. It is a third-party product, does cost money, and will
have some learning curve. There may be other reporting packages that can use
..MDB databases, too.

Caveat: I have not personally used Crystal and, therefore, can recommend
neither for nor against it -- I've just seen a (very accomplished) developer
use it to good effect in a website.

Larry Linson
Micrsoft Access MVP
 
paul69 said:
I am using Access 2002 and FrontPage 2002. Right now I produce reports by
getting persons to submit info through a web form to Access. I then
download
this database, merge it with a Word document, then post individual reports
to
a web site or email the reports to the client. I find this process
tedious.
Is there a better way to generate reports? Using Acess Reports? And
Frontpage somehow?
Click to expand...

I have not done so, but see no reason that you could not use COM Automation
to execute pre-defined Access Reports on the same server where your Front
Page-generated Website is executing, if Access were installed there (an
unusual configuration). You could also use a third-party reporting tool
designed to be run on a web site (but this is not the most likely place to
get knowledgeable recommendations of third-party tools).

If you download the database to your machine, I don't see why you could not
easily create and execute Access' Reports and then send them to the
individuals. If that's an option, it'll be simpler than creating, testing,
and running COM automation on the server (if, in fact, the system
administration at your site/company will allow Access to be installed and
executed on the server).

Larry Linson
Microsoft Access MVP
 
Back
Top