Subtotals with date ranges

[nerdhurd2]

Greetings all,

What would be the best way to add 12 subtotals with a date range into a report? I would like a subtotal for january, febuary, march, etc...

My thoughts so far =

I have an order date for each order in dd/mm/yy format so im guessing i would need to convert this into MONTH format. then if the row is in MONTH January, it would be added to the Sum of January Orders

I think i can handle getting the monthly sums to add up, but how would i go about displaying the groupings? with detail sections?

Thankyou for any ideas!

 

[lbass]

Try inserting a crosstab where you use {table.orderdate} as the row or column and order amount as the summary. After adding the field in the crosstab expert, while it is selected, go to "group options" and select print on change of month. If you want the headings to show the monthname, then in preview, right click on the label->format field->customize and choose Day: none->month: March->year: none.

-LB