Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Central Florida, USA
    Thanked 0 Times in 0 Posts
    I have a legacy program that transitioned from Access backend to SQL Server a few years ago. *Then we added and page for data entry, but continued to use the Access front end for reporting. *

    Now the goal is to convert the Access Reports into something viewable via ASP. *

    Does anyone have any recommendations? *Any ideas are greatly appreciated.


  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts
    There are reporting components for .Net, for example, Crystal Reports. With Crystal, you use an Access-like report authoring environment, and then end users generate reports using a runtime version on the server. User can save the resulting report as a PDF.

    In my very limited experience, the reports either query the database directly (with very limited options for parameters), or they are populated using an XML file of query results. I don't know how you code for the runtime; I assume the documentation comes with Crystal Reports.

    Of course, you also can just deliver the results as HTML. If you like control over the layout, e.g., headers and footers, then HTML is not the best choice.

Posting Permissions

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