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

it just exports raw data.

thanks

Ray

Hi Ray,

You can still use it to export grouped columns.  Whenever you add a Column to the GroupBy area, normal rows are replaced with GroupByRow objects.  These are the header rows for each of the grouped rows.  Inside this GroupByRow object is another Rows collection which contains the rows that are grouped under it.  Using this you can export grouped data by checking if the the current row you are looking at is of type GroupByRow.  If it is then you would then iterate through the GroupByRow.Rows collection and export those rows together, then move on to the next GroupByRow and do the same.  This will export your data together with the grouping intact.

Thank you will try, but if you have some sample code handy would appreciate if you attach.

Rayudu

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.

Hello Rayudu,

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