Asp.net SSRS 2008 (RDLC) export to Excel Report

Question

I need to write a SSRS Report (RDLC) with Sub Report and directly export the report to Excel on asp.net button click event.

Could someone please help me with whether this can be done without having to install SSRS i.e. no liscense required?

The SSRS Report needs to render each Groups in to separate sheet.e.g. if there are 3 States, the report should show the data for each states in to different excel sheets.

I tried to do this with Crystal report, but crystal report doesn't support multiiple sheets.

Thank you.

Answer 1

I'm pretty sure that every option to parse SSRS reports available from Microsoft requires a license and installation, either on the server or on the client, wherever the .rdl is parsed. (Does Microsoft distribute any software that doesn't require some sort of license agreement?)

But some of the licenses do not require purchase and are freely available. .rdlc files can be parsed and displayed in a ReportViewer control, which requires .NET and the "Microsoft Report Viewer 2010 Redistributable Package" If you look on that page, you'll see that SSRS is only required for Server processing mode.