Page 1 of 1

Grouping by Dates

Posted: Thu May 15, 2008 12:02 pm
by 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

Grouping by Dates

Posted: Thu May 15, 2008 12:21 pm
by 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.