Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A stumble may prevent a fall
 
Proverb
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

20
February

How Do I Create a Weekly Grouped Report in Crystal Reports 2016?

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:

  1. Create the report as per usual

  2. Create a New formula:

  3. Name: WeeklyGroup

  4. Formula:  {Tablename.Fieldname} - DayOfWeek( {Tablename.Fieldname}, WeekStartDay) - 1

    Where WeekStartDay = crSunday, crMonday, crTuesday, crWednesday, crThursday, crFriday, crSaturday

  5. Create a New Group

  6. In the Insert Group Dialog:

  7. Group By: WeeklyGroup
  8. In Ascending Order
  9. Section will be Printed: For Each Day

  10. 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

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

93 + 1 =