SQL Reporting Service

hello please hlp

i am using SQL reporting services 2005


i have one report which list weekdays sum between two days

but the problems is that how i will calculate the week days sum

start date = ------- end date= ------


date | day | job | hours worked | total hours worked

01-02-2008 Friday 12 30 4
02-02-2008 Saturday 12 30 4
03-02-2008 Sunday 12 30 4
05-02-2008 monday 12 30 4
06-02-2008 tuesday 12 30 4
07-02-2008 thursday 12 30 4


-------------------------
week day sum hours workd=180


08-02-2008 Friday 12 30 4
09-02-2008 Saturday 12 30 4
10-02-2008 Sunday 12 30 4
11-02-2008 monday 12 30 4
12-02-2008 tuesday 12 30 4
13-02-2008 thursday 12 30 4


-------------------------
week day sum hours workd=180

14-02-2008 Friday 12 30 4
15-02-2008 Saturday 12 30 4
16-02-2008 Sunday 12 30 4
17-02-2008 monday 12 30 4
18-02-2008 tuesday 12 30 4
19-02-2008 thursday 12 30 4

-------------------------
week day sum hours workd=180






it should look like this ....


i can list out the week days between two dates but i dont know how to get sum of week day, for a range of seven days and show above format is there any programming methods are there to calculate the weeksays as field

i want to list like this the week day = weekstartday +week end day how i implement this


please help me i am new to this SQl report please give me some suggestion wih examples and links