Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    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 ASP.net 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.

    Ken

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 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
  •