I agree, but this versoin does not export Grouped Columns and retain.

it just exports raw data.

thanks

Ray

Hello

 I see the sample you gave works fine,.

In my grid the column can be anywhere as user can move around. I have 3 summary columns

The code has to be generic to find if its summary row or summarycell and then keep the value

not just at some fixed place.

This helps:

SummaryResult summaryResult = xamGrid1.SummaryRowSettings.SummaryResultCollection[0];

but the index 0 or 1 or 2 as i have 3 summary columns.

Will it be constant as in design mode , even if user moves the columns around.

and Summary/total has to be in the next row after grouping.

see attached image. i need sub-totals and then at end Total for the groups.

the code in your samples does not work for grouped columns, i guess from the sample1 i correctedto have groups working.

Need to figure out the Summary/subtotal/total issue.

Would be good if we had is row Summary and then just add the values as is.

similar to "if Rowtype is GroupbyRow"

Just wanted to add another image how the SL app looks

If the user changes the grouping the summarys can be like this.

Sub Totals for every grouped column. can be one more grouped columns.

Hello Rayudu,

For exporting totals and sub-totals when grouping records I have attached an updated sample.

Thanks verified.

Only thing is i want the subtotal after the row data when grouping.

right now. the header comes,. then sum/subtotal comes.

i need: header/row data/sum-subtotals. as the logic for placing the subtotals is inside the header loop. i see subtotals are in the 1st row of each grouped section. need at last row of each grouped section. that is the normal reporting.

Hello Rayudu,

For exporting sub-totals after row data I have attached an updated sample.

Perfect

thanks

perfect. thanks