i have a grid that exports fine as long as it is not grouped. the exporter and the code behind are using essentially the code from here
http://help.infragistics.com/Help/NetAdvantage/Silverlight/2011.2/CLR4.0/html/xamGrid_Asynchronous_Export_to_Excel.html
when i allow grouping the grid will not export. it also fails to through the exception in the catch. if i debug and step through i can capture it
mesage
"There was an error generating the XML document."
Innerexception
"Exception of type 'System.OutOfMemoryException' was thrown."
i do not understand why this is occuring, it is not in the known issues for export
any help would be apprciated
Hello,
Thank you for your post. I have been looking into the issue that you have described and I could not managed to reproduce it. I have created a sample application in order to test the exporting of the XamGrid into excel, using the asynch method when there is grouping applied to the grid and I have managed to export 10000 group rows into an excel worksheet. I have tested the sample application using the latest service release of version 12.1. I am attaching the sample application that I have created and the MS Excel document which is result of the exporting of the XamGrid.
Please let me know if you can reproduce the same issue with my sample application or I have misunderstood your scenario in any way.
Looking forward to hearing from you.
Sincerely,
Krasimir
Developer Support Engineer
Infragistics
www.infragistics.com/support
so for giggles i pulled the code out of you sample. i re wrote my page to use your exporting piece of it. got the same error message
There was an error generating the XML document
sure. yes we are using ria services. we use a domaindatasource to call the service. however since the IG does not play well with direct binding to the dds, we spin all the objects into generic list, list<myClass>(). i dont really have enough free time to spin an full sample project. our loading code of the list is something like this
the domaindatasource is declared on the xaml side
when the loaded event fires:
foreach(myClass obj in dds.DataView)
{ lst.add(obj);}
dg.itemsource = lst;
Hi spicish2222,
I'll be assisting you further on this issue. Currently I've gone through the thread and I'm in the middle of putting together a sample using RIA services and then exporting the grid to excel using the XamGridExcelExporter. It should be finished shortly so I'll let you know the results then.
I've put together a sample using RIA services with a DomainDataSource and I'm loading data from a database into my xamGrid. After grouping the data by a column and clicking on the Export button, the data successfully exports to excel so I'm unable to reproduce the issue. I've attached the sample for your consideration. Can you take a look at it and let me know if there is anything I should change to more closely match how your grid is setup or can you make the changes in the sample to reproduce the issue and send it back to me?
Please note that in order to run the sample you must have the Northwnd sample database installed in it's default install directoy. The sample looks for the database at this directory via the connection string in the web.config file. You can download the Northwnd database files here. http://www.microsoft.com/en-us/download/details.aspx?id=23654
Do you still require assistance on this matter? Let me know if you have any questions on the attached sample.
i also have issues grouping by certian columns in that grid as well. i know they have nulls, although i can group by a col that has nulls in the northwind sample?
Do you mean if they are easy to uninstall? They can be removed from the Control Panel's Add/Remove programs dialog. In the Add/Remove Programs dialog on the left-hand side you will see a "View installed updates" link. Click on that and in the new list you will see the Silverlight service release for 11.2.20112.2068 (after it's installed). Select this update and uninstall and you'll go back to the previous version you had.
i have not installed the latest service release. are the easy to roll out of incase some other issue arises from installing it?
You produced this error after installing the latest service release for 11.2 SL4? (11.2.20112.2068)
I've built another sample and I'm trying whatever I can think of to try and reproduce this. I'll get back to you shortly.
stack
i built a new test page in the app, same unable to generate xml error.
see attached