Defining Beginning of week

[strom99]

How would I define the weeks in my report as M-F. I am using a BILL_RUN_DATE and have it grouped by week, but need it to group M-F.

Thanks

 

[kenhamady]

Depends on what you want to do with Sat and Sun. Where should they go? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[strom99]

They can be ignored since all of the BILL_RUN_DATES fall between Monday's & Friday's.

 

[kenhamady]

Create a formula field called WeekDay:

DayOfWeek({YourDateField})


Now, in the select expert, select only weekdays by using the rule:

{@weekday} is between 2 and 6

This will only include weekdays in the report. And, when you group weekly, you will get M-F. Now the group name will still print the Sunday. If you don't want it to print Sundays as the Group Name you can delete the group name field, and put a copy of your date field on the group header in it's place. This will print the first date of each week group as a header. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)