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'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.

Hi spicish2222,

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?

Hi spicish2222,

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