Need to group by week ending date in Crystal Reports 2008

Posted on 2011-09-27
Last Modified: 2012-05-12
How can I adjust this formula so that my end result is Group by week with the week ending day of Saturday? Currently is being displayed and grouped by the week beginning day of Sunday.

{BAQReportResult.LaborDtl.PayrollDate} +
(7 - DayofWeek({BAQReportResult.LaborDtl.PayrollDate},crSunday))

Thanks in advance for the help! I apologize if the answer I need is within my other question but I haven't quite got a grasp on date formulas to fully understand how to piece them together..
Question by:SeyerIT
  • 4
  • 2

Author Comment

ID: 36710656
My zones aren't displaying correctly on my webpage and it's making it impossible to select the correct one.. The primary zone for this should be Crystal Reports.

Author Comment

ID: 36710664
groups not displaying correctly
LVL 19

Accepted Solution

GJParker earned 500 total points
ID: 36710843
Create a second formula that converts your formulas result to the previous saturday


{@YourFormula} - (DayOfWeek({@YourFormula}, crSaturday) - 1)

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.


Author Comment

ID: 36711047
GJ, I just tried that and it is still grouped by week beginning of Sunday..
LVL 19

Assisted Solution

GJParker earned 500 total points
ID: 36711475
Change the group option from weekly to each day

Author Comment

ID: 36711566
AH yes! That does the trick.. Now, is there a way for me to be sure the months are grouped correctly? Perhaps I should ask this as a different question and relate to this thread?

For instance, week ending 4/2 is being grouped in April instead of March.. I would like to group the week into which month the first 3 days fall into. In other words, 4/2, Saturday falls in April but Monday through Wednesday falls in March. Therefore I would like this week to be grouped with March. Basically whichever month the majority of the days (mon - fri) fall into, I want to fall into that month.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
Exclude some records from totals 10 58
SSRS 2008 Multi Value Parameter Filter using OR 3 48
SSRS String Manipulation 6 45
Publishing SSRS Reports to an IIS Server 3 75
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

829 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