Report show difference between to weekly totals ?

Hi All,

I am very new to RS and i need to know how to do this kind of report.

1) Select the sum of each 7days between the dates entered by a user.

2) For sum col 1 and sum col 2 show a col with the + or - value

3) for sum col 3 and sum col 2 show the + or - vaule and so on.

So i think it would look like this

col1 col2 diff col3 diff col4 diff

100 50 -50 150 +50 75 -75

I really hope someone can help me with this and i really appreciate any help or guidence anyone can give

Kind regards

Dave C

You can use the group function in SQL to get the sum of the 7 days or you can also retrieve the week number and make a group using it. For the rest you can operate directly in the report like this: =ReportItems!A.Value - ReportItems!B.Value

I hope it helps

soanfu