I'm trying to export RadGridView data to a teleric report. I found the RadGridReportingLite sample project on the teleric website and have been playing around with it. My question for anyone of you that have used it or designed it is - can i tweak the radgridReport class to include items in the gridSummaryRow collection or do i need to add a custom row to my grid which will perform aggregation ?
Thanks in advance
5 Answers, 1 is accepted
Thank you for writing.
Currently, the RadGridReportingLite class does not support summary items from RadGridView. We will consider to extend this helper class to transfer summary items from the grid, but this is not very easy because of the data structure and representation are very different in RadGridView and Reporting.
Do not hesitate to contact me again if you have other questions.
the Telerik team
I know that using RadGridReportingLite method is obsolete, but i still need to generate/show report this way.
The advantages of this solution in my case is:
- A large amount of data is exported much faster than the Export to PDF/HTML/Excel.
- Ability to render a report to XLS, without using Microsoft.Office.Interop.Excel. File is treated as coming from Excel. There is no messages about incompatible data format.
- Ability to show report in viewer, where user can preview printout, change page setup, export to different format etc.
But I can not imagine a situation where user can see the rows of sums in the grid, but does not see them in the final report print / export to XLS.
Is there a possibility to extend the RadGridReportingLite functionality of the summary rows?
If it is not possible to obtain the finished code, please just give me some direction in coding.
Thank you for writing.
RadGridReportingLite class does not support summary items from RadGridView. Since it is now obsolete, I would highly recommend you to generate the desired report using some of the export methods, which we provided with the new version of RadGridView instead of generating a report.
Our RadSpreadProcessing library is suitable to populate a worksheet with data coming from the RadGridView, insert the desired summary rows and save the workbook as an xlsx file.
I hope this information helps. Should you have further questions, I would be glad to help.
It seems OpenOffice requires a part of the XLSX document (the docProps folder) to be present in a document in order to load it. However, according to specification these parts are not mandatory and at this point RadSpreadProcessing does not generate such folder and the files in it. We will consider a change in the behavior for one of the future releases.