help with both grouping plz

[C# Programming]

i have the following field:

trxn_date
trxn_category
trxn_description
trxn_total_amount
trxn_discount_amount
trxn_net_amount

I want to display a monthly report (all above excep trxn_category) based of the selected month so it will list by days from 1 to last day of the month.

at the bottom, I want to display the list by category for the whole month (without trxn_date and trxn_description) so it will be:

trxn_category
trxn_description
trxn_total_amount
trxn_discount_amount
trxn_net_amount

can you please guide...