create report with a dynamic column.

[VBcielle]

I am at loss on how to do this kind of report. Please help me..

can you help me create a report that will look like below?
Dates are dynamic, it can display date ranges from jan. to december or it can display only january or february.

Project Name        Amount Allocated                        No. of Jobs
                  Total    Jan.       Feb.      Mar.          Total       Jan.    Feb.      Mar.
Project 1       900.00                                         2,250
Location 1       500.00    100.00    200.00      200.00        1,000       500     250      250
Location 2       250.00    200.00    25.00       25.00         750         100     400      200
Location 3       150.00    50.00     50.00       50.00         500         50       500     400 

my tables look like below

for the amount allocated

tblamountalloc

Project Name    Location 1       Location 2    Location 3          Date
Project 1            100.00        200.00        50.00        01-14-2012
Project 1            200.00         25.00        50.00        02-14-2012
Project 1            200.00         25.00        50.00        03-14-2012 

for the no. of jobs

tblnojobs

Project Name    Location 1    Location 2    Location 3    Date
Project 1           500        100         50        01-14-2012
Project 1           250        400        200        02-14-2012
Project 1           250        200        400        03-14-2012