Sample Source:-
SessionName PaymentMethod Amount
Session-1 Cash 100Session-1 Cash 70Session-1 Cheque 50Session-2 Cash 500
I have created sorted columns for SessionName and PaymentMethod and created summary for Amount. customize the group by row description in the InitializeGroupByRow event.
Output:-
Amount - Change to Session Name**************************- Session - 1 - Method: Cash(2 items) Amount Paid = $170.00 100.0000 - Need to hide 70.0000 - Need to hide - Method: Cheque(1 item) Amount Paid = $50.00
- Session - 2 - Method: Cash(1 item) Amount Paid = $500.00 500.00 - Need to hide
1) I want to hide the summary record, since amount total displaying in the group description.2) Column header need to display as "Session Name"
Thanks
satheesh_aaa said:1) I want to hide the summary record, since amount total displaying in the group description.
If you want to hide the summaries so that they only display in the groupByRow and not after the data rows, then you could use the SummaryDisplayAreas property. You would set it to InGroupByRows.
satheesh_aaa said:2) Column header need to display as "Session Name"
Se the column.Header.Caption property.
I tried what you suggested, summary information is displaying in the group by row, but still Non-Group by rows are displaying below the group by rows.
- Session - 1 - Method: Cash(2 items) Amount Paid = $170.00 100.0000 - Need to hide 70.0000 - Need to hide - Method: Cheque(1 item) Amount Paid = $50.00 50
I want to hide non-group by rows, that is 100, 70 in cash method and 50 in cheque method.