Loading Reporting Services 'EXCEL' output

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BrinkSr
    New Member
    • Oct 2007
    • 2

    Loading Reporting Services 'EXCEL' output

    How do I load the 'EXCEL' or 'HTML4.0' output of a Reporting Services ServerReport.Re nder call to an 'Excel.Applicat ion' object using Javascript?
  • pbmods
    Recognized Expert Expert
    • Apr 2007
    • 5821

    #2
    Heya, BrinkSr. Welcome to TSDN!

    What's the context of the ServerReport.Re nder?

    Comment

    • BrinkSr
      New Member
      • Oct 2007
      • 2

      #3
      Originally posted by pbmods
      Heya, BrinkSr. Welcome to TSDN!

      What's the context of the ServerReport.Re nder?
      Thank you. Not sure I correctly understand your question about the 'context of the ServerReport.Re nder', but think the answer you want is 'Microsoft ReportViewer.Se rverReport.Rend er()'.

      Perhaps if I explain my problem ...

      In the server-side C# code of a web page I am creating a Microsoft ReportViewer object to, in turn, create a report for the user. The user then wants the report presented in Excel on a web page. I can store the Report viewer text output (HTML4.0 or XML) in a div on the page. What I would like to do is create a client-side EXCEL object and import the report data into an Excel.Workbook object. I have looked at Excel.Workbook. XmlImportXml but I do not have an XmlMap for the XML generated by the report. I was hoping that someone would know how to get the output of a ReportViewer.Se rverReport.Rend er (EXCEL, HTML4.0, or XML probably) into an Excel client-side object without using a temporary file.

      Thank you for your reply

      Comment

      Working...