display grid summary row in report generated from RadGridView (Winforms)

[Anisha]

Hi,

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
Anisha

[Martin Vasilev]

Hello Anisha,

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.

Best wishes,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[konrad]

Hi,

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.

Best wishes,
Dominik

[Dess | Tech Support Engineer, Principal]

Hello Dominik,

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.

Regards,
Desislava
Telerik

 

 

[konrad]

I can't use standard export methods due to lack of advanced formatting of the output file.
I also checked RadSpreadProcessing and there is a problem with reading the file by OpenOffice 4.1.1

Can't open file created by below code:

Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook = new Telerik.Windows.Documents.Spreadsheet.Model.Workbook();
Telerik.Windows.Documents.Spreadsheet.Model.Worksheet worksheet = workbook.Worksheets.Add();

Telerik.Windows.Documents.Spreadsheet.Model.CellSelection selection = worksheet.Cells[1, 1]; //B2 cell
selection.SetValue("Hello RadSpreadProcessing");

Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

using (FileStream input = new FileStream("c:\\Hello.xlsx", FileMode.Create))
{
    formatProvider.Export(workbook, input);
}

:(

[Petya]

Hi Dominik,

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.

Regards,
Petya
Telerik