require purchase details over diff months

From: Nikhil (anonymous_at_discussions.microsoft.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 03:11:03 -0700

I have a table which lists all vendors and purchases done over different months

i want to have a report using segate crystal report which gives me the total purchase of each month for each vendor from the first month of the financial year till the current month.

e.g my table contains...vendorname, month and grosspurchase
and i want the report to look something like...

vendorname - aprpurchase - maypurchase - junepurchase and so on..

thus each month..there would be one column that would get added..

how do i do this using sql query and crystal report

let me know asap

regards

Nikhil