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.

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