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

i do NOT believe it is the large amounts of data.  the grid i am trying to export only has 550 rows.  i wrote a seperate sample with 300 rows and it exports.  its very easy to fake a clean set of data and have the feature work.  however the data is not grouped in xlsx when i export it no matter what i set this to:

ExcludeGroupBy

i am pretty sure it has to do with the way it handles data.  the set that does not work has nulls in the database

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; }
 
                                

Hi,

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.

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?

Hi spicish2222,

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