I have an Oracle db as the DB and intended to use Reporting Services as the report generator accessing the DB data.

My intention is to produce a monthly report for the items available in the DB. FYI, I'm using OLE DB Provider for Oracle to access the DB.

 The example is as below:

                                 Report for May

 Item/Day     1     2     3 ------up to---> 30/31    TOTAL

Item1           23   11    2 ..................... 31         y
Item2           12    12   5 ......................15         y
Item3           12    12   1  .....................12         y

TOTAL          x      x    x                        x         X

How should I do that? Not really good in Reporting Services.