• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1026
  • 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
SeyerIT
Asked:
SeyerIT
  • 4
  • 2
2 Solutions
 
SeyerITAuthor 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
 
SeyerITAuthor 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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
SeyerITAuthor 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
 
SeyerITAuthor 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

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.

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