Current project uses the Telerik Report library.
I've been working with the Documents.SpreadsheetStream and Documents.Spreadsheet methods to by-pass the report templates. Finding my design plan has run into a design issue when exporting directly to excel. In the Templates can create a much richer view for the end-user.
However the customer wants to export directly to Excel with out having to view the report then click on the export button. (See the attach jpg file for screen shot of the current interface). I think I will add both options for the end user to select view or export, just incase they rather not have the file. Or if another customer prefers the view...
My question, Can I run the process to run the Telerik report template I created and pass all parameter that will cause the export to Excel directly?
5 Answers, 1 is accepted
You may export the report programmatically with the ReportProcessor class. Check the article Embedded Report Engine for more details and sample code. For example, you may trigger the rendering logic on a button click. You need to use the rendering extension 'XLSX' - see the Rendering Extensions article.
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Thank you Todor,
This will take me awhile to study your response.
Completed a test. The sample was not as clear as I expected. Not sure what
Was trying say being that I am already setting up the report details and expecting to got directly to print. With that said I completed my code changes and it appears to work. However
at line 10, "reportProcessor.RenderReport" errors not accepting "XLSX" as a possible format. I'm running Telerik.Reporting version 18.104.22.168. I want to use the XLSX format if at all possible.
The XLSX format is an OpenXML format and requires additional assembly references. Check the article section Deploying Open XML for more details.
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.