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

it just exports raw data.

thanks

Ray

I was able to get the way i want in excel,. except below

how do i get SummaryRow and add those values to excel.

I tried to find , i never get summaryRow but UI has summary totals and subtotals

if ( groupedRow.Rows[i] is SummaryRow) 

regards,

Rayudu A

Hello Rayudu,

For exporting summary values to excel I have attached an updated sample.

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.

Perfect

thanks

perfect. thanks

Hello Rayudu,

For exporting sub-totals after row data 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.