This is a migrated thread and some comments may be shown as answers.

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

5 Answers 95 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Anisha
Top achievements
Rank 1
Anisha asked on 20 Apr 2009, 05:46 PM
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

5 Answers, 1 is accepted

Sort by
0
Martin Vasilev
Telerik team
answered on 27 Apr 2009, 01:09 PM
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.
0
Dominik
Top achievements
Rank 1
answered on 11 Sep 2014, 07:13 AM
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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 15 Sep 2014, 04:23 PM
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
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
Dominik
Top achievements
Rank 1
answered on 16 Sep 2014, 11:10 AM
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);
}

:(
0
Petya
Telerik team
answered on 19 Sep 2014, 11:17 AM
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
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Tags
GridView
Asked by
Anisha
Top achievements
Rank 1
Answers by
Martin Vasilev
Telerik team
Dominik
Top achievements
Rank 1
Dess | Tech Support Engineer, Principal
Telerik team
Petya
Telerik team
Share this question
or