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
Hi spicish2222,
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?
In all the samples you tested and confirmed to work correctly, can you spot any differences between them and your actual application that runs into this issue?
You can group by a column that has null values. The group header title will just be empty text but all the null rows will appear under there. This will also export correctly.
I made a few adjustments to how I'm loading the data from the DomainDataSource that should actually allow you to bind the grid to the data without needing to use your own middleman code to loop through all the entities and add them to a seperate list which you then bind to the grid. Here's the code I added:
DomainDataSource domainDataSource = new DomainDataSource(); NorthwndDomainContext domainContext = new NorthwndDomainContext(); domainDataSource.DomainContext = domainContext; domainDataSource.QueryName = "GetOrders"; domainDataSource.LoadedData += new EventHandler<LoadedDataEventArgs>(domainDataSource_LoadedData); domainDataSource.Load(); void domainDataSource_LoadedData(object sender, LoadedDataEventArgs e) { if (e.HasError) MessageBox("Error has occurred"); xamGrid1.ItemsSource = e.Entities; }
The data I ended up loading from the northwnd database contained around 830 records and contains many Nullable columns, many of which have null values already, so it should be pretty close to your scenario and no matter which column I group by, null value columns or valid value columns, the grid exports as expected and the data shows up grouped in the excel file. I suggest switching your data loading to look similar to mine and then try that. Also try exporting fewer records than the 550 you currently have and see if that influences the behavior at all.
Do you still need assistance with this? I haven't heard from you in a while.
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