Hi,

I have a requirement to show the sales amount rolled up by month and producer in its corresponding month column.  We have following cols in our database.

Producer name
Date
Sales

Date column will have sales date and the requirement is to total sales group by producer name for each month, but each month name should appear as column in the report, we are tracking data for past 6 months.  The output should look something like this:

Producer name | Mar 2009 | Apr 2009 | May 2009 | June 2009 | July 2009 | Aug 2009

Under each month column, we need to show sales amount group by month and prodcer name.

Could you please help me how can I show Month name which is a record in Date column as column for individual month in a report.  This should be dynamic, as we are tracking only past 6 months data.

Thanks.