Group by Month

Hi All:
I have a report that has a field named CloseDate which has a date format. I
want to be able to group together all records by month. (i.e Sept, October
etc.)
If I elect to group by the CloseDate, my records are grouped by each
individal date rather than the month the date occurs.
How can I achieve this?
Thanks
Brennanin your grouping and sorting properties, edit your group on expression like
this:
=Microsoft.VisualBasic.DatePart("m",Fields!Date_Name.Value)
in the cell values for any totals be sure to use SUM(Fields!Date_Name.Value)
and you also probably want to format how your date column is displayed:
=Format(CDATE(Fields!Date_Name.Value),"MM-yyyy")
"Brennan" wrote:
> Hi All:
> I have a report that has a field named CloseDate which has a date format. I
> want to be able to group together all records by month. (i.e Sept, October
> etc.)
> If I elect to group by the CloseDate, my records are grouped by each
> individal date rather than the month the date occurs.
> How can I achieve this?
> Thanks
> Brennan