Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1032
  • Last Modified:

Need to group by week ending date in Crystal Reports 2008

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..
0
Jarred Meyer
Asked:
Jarred Meyer
  • 4
  • 2
2 Solutions
 
Jarred MeyerProduction ManagerAuthor Commented:
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.
0
 
Jarred MeyerProduction ManagerAuthor Commented:
groups not displaying correctly
0
 
GJParkerCommented:
Create a second formula that converts your formulas result to the previous saturday

i.e.

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

HTH
0
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.

 
Jarred MeyerProduction ManagerAuthor Commented:
GJ, I just tried that and it is still grouped by week beginning of Sunday..
0
 
GJParkerCommented:
Change the group option from weekly to each day
0
 
Jarred MeyerProduction ManagerAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now