Dynamic reports - ASP, VBSCRIPT, MS Access

Posted on 2006-03-31
Last Modified: 2012-05-05
Where are the best components do build dynamic reports using classic asp, vbscript, and ms access?

Please do not refer me to any dotNet stuff. I know the reporting capabilities are far better but for a number of reasons we can't use it!

Question by:smetterd
    LVL 19

    Accepted Solution

    Hi smetterd,

    Probably the most flexible solution I've run across is to use Crystal Reports.  You can reference the Crystal Reports Topic Area here for more information or go to the manufacturer's website  I found crystal hard to get setup to work with ASP, but the version I have is fairly old.  

    Another option would be to get a pdf generation component that will allow you to control the layout of the page and output in a pdf file that you can then link or redirect the user to.  I currently use ABCpdf from for this.

    Hope this helps,
    LVL 25

    Assisted Solution

    best bet would be to build the reports yourself.  And use something to generate hardcopies (if that's what you're after)

    This will give complete formatting control

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
    This demonstration started out as a follow up to some recently posted questions on the subject of logging in: and…
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now