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
i have got the sample to work. i also wrote other samples and they work as well. i retested the app/ page with the issue and it still does not work
Hi spicish2222,
Do you still require assistance on this matter? Let me know if you have any questions on the attached sample.
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
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.
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;