Grouping by Dates

[Sandy Pham]

I was wondering if there is any way to group by a DateTime field, but only use the date portion of the field. Can I use a function in the report group header so that I group by days? I would also like to be able to group by month or week.

Thanks!

Sandy Pham

[Edward]

Yes, it is possible.

Please use the following expression:

{MyDataSource.MyDataColumn.ToString("yyyy")}

Also the following project also could be useful, this report makes grouping by the week within fixed period. It can be open in the 'Demo' example application.

Thank you.