Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Unanswered: How can i use a report from Access 97

    I was wondering if there is a way I can use a report from Access 97 to print a certificate using SQL Server and being displayed in ASP as well?

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    We use Access 97 to create monthly reports and have them available for the Web. When we run the report we save it in a format called Snapshot, there is a viewer that can be used in an ASP to view Snapshot reports. They look just like they do in Access.

    Here is an example of the ASP code:

    Code:
    <OBJECT ID="SnapshotViewer" WIDTH=100% HEIGHT=97%
     CODEBASE="/apps/CabFiles/Snapview.ocx"
     CLASSID="CLSID:F0E42D60-368C-11D0-AD81-00A0C90DC8D9">
        <PARAM NAME="_ExtentX" VALUE="16722">
        <PARAM NAME="_ExtentY" VALUE="11774">
        <PARAM NAME="_Version" VALUE="65536">
        <PARAM NAME="SnapshotPath"  VALUE="<%=reportName%>">
        <PARAM NAME="Zoom" VALUE="0">
        <PARAM NAME="AllowContextMenu" VALUE="-1">
        <PARAM NAME="ShowNavigationButtons" VALUE="-1">
    </OBJECT>
    We only do this for monthly reports, I've created a Perl script that runs after hours to generate these reports. I'm not to sure of performance and concurrency if I had these reports generated on demand by the front-end.
    MCDBA

  3. #3
    Join Date
    Feb 2003
    Posts
    109

    the snapshot viewer is awesome

    but you really should be using Access 2002 with Access Data Projects.

    they are a lot faster for reporting than traditonal MDB.
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •