Displaying Months

I've got a report that needs to allow the user to see information for all 12 months of a year in a table in reporting services 2005. I was wondering if it was possible to dynamically display each month instead of having to make 12 table entries and manually typing in the month.

any ideas or places to start looking would be helpfull

Thanks

If you're just trying to generate the month name based on the row, try this:

DateTime.MinValue.AddMonths(RowNumber(Nothing)-1).ToString("MMMM")

|||that didn't work when I ran it i got just january (i want all 12 months in their own fields) also when I looked at the exception i got an unreconized identifier on AddMonths|||I figured out how to fix this i just did a group by on the data using the DATEPART function in sql.