Results 1 to 3 of 3

Thread: ASP Reporting..

  1. #1
    Join Date
    Apr 2004
    Posts
    47

    Unanswered: ASP Reporting..

    Hi Group,
    I've inherited a reporting application which uses Excel for report purposes. Excel is installed on the Web Server and is causing performance issues when the user runs the report from the ASP Pages.

    Other than OWC is there another way I can produce reports in formats which will be readable by the end user.

    It was suggested that this:
    set ExcelApp = CreateObject("Excel.application")
    is a bad way to instantiate an object. Is there a preferred way? Can I use another tool/something else for my reporting purposes?

    Kind Regards

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Depends on what kind of reporting you need. You could write your ASP to generate CSV files, or you could get much more complex with Crystal Reports.
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps have a look at this:

    Creating a Dynamic Report using ASP and Excel by Jeff Anderson - 1/9/2003
    http://www.codetoad.com/asp_excel.asp
    Uses:
    Response.ContentType = "application/vnd.ms-excel"
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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