1 Reply Latest reply on Feb 2, 2010 6:38 AM by Jake_Howlett

    Using SummaryRow With XMLListCollection DataProvider

    Jake_Howlett

      Hello,

       

      I have an AdvancedDataGrid with an XMLListCollection dataprovider, which contains "invoices" which, in essence, look like this:

       

      <invoice><to>Jake</to><net>100</net><vat>17.50</vat><total>117.50</total></invoice>

       

      I want to provide a summary row on the net, vat and total fields.

       

      I've done everything you're supposed to in to order to add summary rows and it "works", as you can see in the image below:

       

      Untitled-1.gif

       

      As you can see though, it's not adding up.

       

      I've read in a few places that the SUM operation (or SummaryRows in general for that matter) don't work with an XMLListCollection. Is this true?

       

      If summaries don't work with an XMLListCollection what's the alternative? I've tried converting the XML from the server to an ArrayCollection but I'm having no luck.

       

      Any workarounds for this?

       

      Jake Howlett