Crystal XI - Group by Week - Display SUNDAY Date

Posted on 2009-02-19
Last Modified: 2012-05-06
I have a report that is grouping by week date but is displaying the first data point date in the group header.

First data date is Wednesday, February 18, 2009 and the Group Header is displaying "Week of: February 18, 2009"

I am trying to get the report to display in the GroupHeaderName the Sunday Date since we use a Sunday-Saturday week. with this my date would display as follows:

Week of February 15, 2009
Data Date 1 - Wednesday, February 18, 2009
Data Date 2 - Wednesday, February 19, 2009

Week of February 22, 2009
Data Date 3 - Tuesday, February 24, 2009

Question by:dsabine
    LVL 77

    Expert Comment

    Derive the Sunday date for each record and group on that.

    if dayofweek({Table.field}) = 1 then
    {Table.field} - dayofweek({Table.field}) +1
    LVL 10

    Accepted Solution

    If you are grouping by date and select BY WEEK, the Sunday date should be displayed?

    You should be displaying the GroupName field in your group header to get the sunday date.  If you are getting another, you probably have the acutal database field object in your group header.  Are you displaying the {mydatabase.mydatefield} in your group header?

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now