I have 2 related tables projects and funding that work together in a 1 to many relationship. The funding records contain fields for amount, source, and year. I want to create a report where each project and its funding is displayed together. The project data would be displayed in the first column or block, followed by a column for each year. Something like this:

------------------------------------------------------------------------------------------------------
project1 name|year1amount1|year2amount1|year3amount1
desc |year1amount2|year2amount2|year3amount2
etc |year1amount3|year2amount3|year3amount3
------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
project2 name|year1amount1|year2amount1|year3amount1
desc |year1amount2|year2amount2|year3amount2
etc |year1amount3|year2amount3|year3amount3
------------------------------------------------------------------------------------------------------

How would you suggest I construct the cursor(s) and report to accomplish this?

Thanks