excel reports via asp.net


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: excel reports via asp.net

  1. #1
    onder Guest

    excel reports via asp.net


    we have a project in which we need to serve report viewing in a web browser
    and in case the user requests, he/she will be able to click a button and
    then the report will be opened in the local MS Excel.
    All the reports are excel reports and retrieve data from several database
    servers. Reports may include charts and tables.

    We haven't finished about deciding how to to this; most primitive way is
    creating the report on the report server, which is also the web server, and
    opening/downloading the report to the client via the web page.

    We are considering the performance of the alternatives.
    Anyone having done the same application, please share your comments with
    me.

  2. #2
    Q*bert Guest

    Re: excel reports via asp.net


    I can't say much about the .net side of itegration, but if its similar to
    the 6.0 ASP then your task isn't too daunting. I see two methods of accomplishing
    your task:

    1) change the mime-type of the response document to the appropriate Excel
    mime type (MS-Excel or soemthing like that) and if they have Excel, the document
    will open as excel; otherwise it will prompt for download.

    2) Use web queries built into Excel to pull data to local system. Since
    your charts are dependent on data in specific fields; this could resolve
    the issue of charting. All you need to do in the ASP is just write out your
    table information. Within the VBA of Excel you could tell it to refresh
    the webquery on open, on a clicked event... whatever.

    Hope this helps
    Q*bert

    "onder" <oaydogan61@hotmail.com> wrote:
    >
    >we have a project in which we need to serve report viewing in a web browser
    >and in case the user requests, he/she will be able to click a button and
    >then the report will be opened in the local MS Excel.
    >All the reports are excel reports and retrieve data from several database
    >servers. Reports may include charts and tables.
    >
    >We haven't finished about deciding how to to this; most primitive way is
    >creating the report on the report server, which is also the web server,

    and
    >opening/downloading the report to the client via the web page.
    >
    >We are considering the performance of the alternatives.
    >Anyone having done the same application, please share your comments with
    >me.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center