Export SSRS report to Excel with Formula

KLKhoo · June 24, 2014, 9:53am

Hi team,

I would to like to be able to export my ssrs report into excel with formulas in the cell. Is that possible?

This message was posted using Email2Forum by Babar Raza.

amjad.sahi · June 25, 2014, 2:23am

Hi,

You may use Aspose.Cells for Reporting Services Client component to re-create your report in Excel accordingly. Please read online docs for your complete reference:

http://www.aspose.com/docs/display/cellsreportingservices/Home

Thank you.

KLKhoo · June 25, 2014, 3:05am

Thanks Amjad. Does that mean my report will become an excel report instead? Do we have other alternatives?

amjad.sahi · June 25, 2014, 4:23am

Hi,

Aspose.Cells for Reporting Services Client component creates SSRS report definition file in MS Excel.

There are some Excel information/ data in the SSRS report definition file.

Thank you.

KLKhoo · June 26, 2014, 5:49am

If we have to use Excel to generate the RDL files, is there a tool to the convert all existing reports in ssrs to the Aspose Cells report?

amjad.sahi · June 26, 2014, 7:26am

Hi,

When you install Aspose.Cells.Renderer for Reporting Services, it will add relevant exporting options to SSRS, so you may select the report (report definition file) and render it via Aspose.Cells, you may test some demos with some built-in reports of AdventureWorks in our featured demos:

Thank you.