Day of Week Report with Total and Average

I have a database that collects equipment useage on a daily basis. I need to generate a report that tallys useage for the day of the week rolled up by the week so that the report looks like:

Mon Tue Wed Thu Fri Sat Sun

Week Ending Date: 123 123 123 123 123 123 123 Total Ave

Any suggestions, recommendations or references? Thanks.

If the table you are storing these values into, contains a datetime column. You can use something like this in reporting services:

select DateName(dw, dateColumn) WeekDay, someNumber from Table

Then do a group by the column WeekDay.

|||Thank you. I think I will do a query that groups on weekDay and by LastDayofWeek then use a matrix report. I could identify which day is the last day of the week and add this as a column for all dates based on DayOfWeek - 7. What do you think?