Hello,
Long time reader, first time poster.
I have been searching the web for reporting to be used in both ASP.NET (preferably using MVC Razor) and supports exporting both the data and the charts/graphs associated with the data into Excel.
So far, the closest I have come is sealreport.org (demo here: http://demo.sealreport.org/temp/Dashboard_-_Sales_t0n4u_htm.htm), but since I have already used Telerik's Kendo solution in the past, I would prefer to leverage your reporting solution.
My asks:
1. Does Telerik reporting have the ability to export reports to Excel that includes both the data used to create the reports, as well as excel-interactive graphs themselves (see http://demos.telerik.com/reporting/dashboard... it just downloads images. I would add the .XLSX file generated by sealreport, but only images are allowed).
2. Is it possible to use an HTML5-like styling with the reporting (CSS styling, or something, reactive, etc - my only experience is that it is very structured and limited with what you can do in the designer)?
Please and thank you.
Best,
ZH
4 Answers, 1 is accepted
Telerik reports are rendered in a specific format depending on the media they are displayed in, or the format request by an export operation.
For example, if you use an HTML5 Viewer to display a report, the report will be requested in HTML format. Details how items will be rendered are available in Design Considerations for HTML Rendering. The rendered HTML aims to visualize content as close as possible to the report designed in the report designer. Interactivity like animations are not supported as such features are media specific and cannot be supported in all rendering formats.
If you are already using Telerik UI for AJAX or Telerik Kendo UI, there are libraries allowing you to export pages in Image, PDF, SVG format. With such approach you can keep the interactivity in browser and get a static document at the end. For more details, please check Exporting HTML From Web App to Image.
If a report is exported in XLS(X) format, items will be rendered per the Design Considerations for Excel Rendering. The Excel rendering mechanism is not translating the Graph settings into native Excel chart. Exporting a Graph in Excel will result in a bitmap or EMF inserted in the file.
I can suggest you to test custom approaches for generating such Excel files e.g. How to create Excel Chart from C# (external blog).
I hope this information is helpful.
Regards,
Stef
Telerik
Rank 1
@Stef,
Thank you. It sounds like I would need to write my own Excel Export function to include this type of functionality. Is this correct?
I've actually read that blog post before :-)
Are there any feature requests related to this for the Telerik team, by chance? I am all about using Telerik solutions, so seeing it get added would be fantastic.
If you want to add custom objects in the Excel file, you can use the already produced Excel file and post-process it e.g. use XLSX format and the DocumentFormat.OpenXML API.
The processed Graph will be of no use as its elements are not exposed, also the charting mechanism is different than the Excel chart's one. It may be easier to save only data in Excel file, not the report, and then to post-process the Excel file to add more content like Chart objects.
Please feel free to add requests for such feature in the feedback portal, as features are considered for implementation based on the demand for them.
Regards,
Stef
Telerik
Rank 1
Veteran
Iron
Iron
The basic idea of creating these Dynamic Data Labels is to Create Interactive Charts which can further help you to create some Interactive Dashboards. You can highlight these Data Labels In Charts when you need them. This technique will help you in two ways. You can hide or unhide Data Labels In Your Charts & you can also able to Highlight Single Data Label In Your Charts. These both ways will help you to Create Your Charts More Interactive. To make such you must read this helpful first:
How To Use Dynamic Data Labels To Create Interactive Excel Charts
(<admin: please do not post ads>)