How to display a SQL Reporting Service report in Excel

Question

Hi everyone,

At the moment i am using VSTO to take a SQL Reporting Services report and display it in Excel 2003 using the ReportViewer control. So bascially on a winform hosted inside Excel.

But i also need to be able to display it without the ReportViewer control i.e. just straight into the cells of my Excel sheet.

I'm wonder how I should go about this.

I can retreive the report in CSV format. So should I just loop through the cvs formatted report and insert directly into my Excel sheet one row after another or is there a better way?

Answer 1

Viewing the Reporting Services reports in a web browser has an Export option right at the top of the report. Excel is one of those options. It even exports the formatting. Note that this is for SSRS 2005 - I do not know if anything changed in SSRS 2008.

Answer 2

You might want to look at what I did trying to print a RS report without user input. It uses RS's web services endpoint to deliver the report into the application. The only difference is that instead of using an IMAGE format, you'd use an EXCEL format on the render call.

Answer 3

Can you not just dump the data directly into Excel using CopyFromRecordset?