Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Generating Reports

Discussion in 'Information Technology' started by paul69, Jul 28, 2006.

  1. paul69

    paul69
    Expand Collapse
    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
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    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" <paul69@discussions.microsoft.com> wrote in message
    news:0AEFE7E2-D263-471C-AD2E-1AF5E5502702@microsoft.com...
    >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
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "paul69" <paul69@discussions.microsoft.com> wrote in message
    news:0AEFE7E2-D263-471C-AD2E-1AF5E5502702@microsoft.com...
    >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?


    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
     

Share This Page