The main issue with creating weekly grouped reports with Crystal Reports, is that by default the application has always been set up with the working week starting on Sunday..
This obviously poses a problem for organisations/businesses whose working week does not start on Sunday, as currently Crystal Reports Grouping function does not give the option of defining an alternative starting of week day.
Solution:
- Create the report as per usual
- Create a New formula:
- Name: WeeklyGroup
- Formula: {Tablename.Fieldname} - DayOfWeek( {Tablename.Fieldname}, WeekStartDay) - 1
Where WeekStartDay = crSunday, crMonday, crTuesday, crWednesday, crThursday, crFriday, crSaturday
- Create a New Group
- In the Insert Group Dialog:
- Group By: WeeklyGroup
- In Ascending Order
- Section will be Printed: For Each Day
- Press the OK button
If you have any questions, leave us a comment below, or need
any assistance, please do not hesitate to Contact
Us |
