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,
I reviewed the thread you and Krasimir have had and working with his sample I modified the class definition so that some of the properties are Nullable<int>. Of course there where some other changes to accommodate a nullable property, including the calculation of the average. And I was able to load the xamGrid and export the grouped xamGrid to excel successfully using Krasimir’s sample.
Could you share your sample? If you could zip it up and attach it to thread we can review and try to see what is causing an issue.
i can not send a full sample as it is not permitted here. i can add a post a dummy class that would match it
it exports if its not grouped, it only fails when its grouped
myClass
public EntityCollection<Assessment> Assessments { get; set; } [Include] public Cateogry Cateogry { get; set; } public Nullable<int> CatID { get; set; } public Nullable<DateTime> DateAdded { get; set; } public string DRConsultant { get; set; } // [Composition] [Include] [Composition] public EntityCollection<myChildClass> myChildClass{ get; set; } public DateTime ModifiedDate { get; set; } public string Owner { get; set; } public int RegID { get; set; } public Nullable<int> Region { get; set; } [Include] public Region Region1 { get; set; } [Required(ErrorMessage = "The Name of the Regulation is Required.")] [Display(Name = "Regulation", GroupName = "Regulation", Description = "This is the Desc for Reg")] public string Regulation { get; set; }
I've been working on your question trying to put together a working sample. Could you give me some additional information? Are you using Ria Services? If not could you provide me with additional details about how you are building your web service?
Perhaps it would be possible for you to create a small sample, based on Northwind or AdvertureWorks dbs. That would be extremely helpful to me so that I have the details of how you are generating your data source.
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.
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