CrossTab Report by Week

[jamminjaymeyer]

I have a table with daily figures in it so it is no problem making a cross tab report with the day as a column. I would like to make an entire week the column but am having trouble telling the report to sum all the data for that week in the crosstab fields is there a formula that I can use to group all the data by week in a crosstab?

Thanks

 

[synapsevampire]

Crosstabs have this functionailty within them.

Click the date column and select group options, you can change it to A Group will be printed for each week.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com