I have a .net app which uses Telerik Reporting to render a report produced in the Standalone Report Designer, it has a number of data sources and the running of those data sources takes 2-3 minutes. The data source is SQL server.
When running the report in the Report Designer all works well.
In the .net app I need to save the report as an image, so I can place it in an email as a summary but then I also want to save as an XLSX spreadsheet and attach that spreadsheet, after adding a lot more data, pivot tables etc the e-mail.
So currently I'm rendering the report twice, the first which is rendered to XLSX format and then again as JPEG file.
So the data is being extracted from SQL twice, once with each render so it doubles the time taken and also the load on SQL.
Is there a way to generate the report and then export that report as XLSX file and then again as a JPEG?