report with groupby

hi,
i have a query working with crystal reports on oracle server.

--There is a table transaction_hist containing 'due_date' column(which is a number to be converted to date). In the report i want the summary of the amounts with current due_date, future due_date, past 1to30 days due_date,31to60,61to90 and 91to180 due_dates.

eg
current future 1_30 31_60 61_90 91_181
sum 99999 99999 99999 9999 9999 9999


PS: i have tried to make formula column for all these due_dates...but could not group by them and summarize them.Try uisng Cross tab reports. Read more in help file