SAP Knowledge Base Article - Preview

1213036 - How to define the start day of a week when grouping on a date in Crystal Reports?

Symptom

  • How to group on a date field from Monday to Sunday?
  • How to group on a date by week using Monday as the starting day?
  • How do define the start and end day of the week when grouping by week in Crystal Reports?
  • How to group records by a week, where a week goes from Wednesday to Tuesday, instead of the usual Sunday to Saturday?
  • When grouping weekly on a date field, Crystal Reports defines a week to be from Sunday to Saturday by default.  How to customize the start and end day of a week when grouping on a date field?


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

WEEK CUSTOM GROUP DATE DATEADD DAY OF WEEK Crystal Reports Grouping Day of week Dateadd function , c2008585 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.