Weekly Grouping in Cross-Tab

[gtf]

I am grouping by week in a cross-tab report but I want my week to start on Monday instead of Sunday. How can I override the Sunday default of CR and have the column group starting on Monday?

 

[kenhamady]

Write the following formula and use that as your cross-tab field:


if DayofWeek ( {your.date} ) = 1
then {your.date} - 6
else {your.date} - DayofWeek ( {your.date} ) + 2 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[gtf]

Thanks Ken. It works great.