Single Generic Excel Report File

[Kurt Kluth]

Is it possible to create a single Telerik Reporting file that will get passed to it a SQL Recordset and it will output the results in Excel automatically?  The ultimate goal is to use this one page multiple times without having to recreate with each new report we want the output to be in Excel. 

 

[Stef]

Hi Kurt,

Reports are templates which are repeated for the assigned to them data. The report should contain items which Value property use the data source's fields.

If you want to re-use the same designed report with different data, you can use aliases for fields on retrieving the data. Thus the report definition will not need modifications.
Other approach is to build the report at run-time after analyzing the data schema.

Details how to start creating reports are available in this forum thread.


The generated report can be exported programmatically in Excel format through a ReportProcessor instance - Exporting Report Programmatically. To use XLSX format youu will need to add references to Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above with proper binding redirect).


I hope this information is helpful.

Regards,
Stef
Telerik