Crystal XI - Group by Week - Display SUNDAY Date

Posted on 2009-02-19
Medium Priority
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

ID: 23681543
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

dougvarga earned 2000 total points
ID: 23681649
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview

850 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