I am using Crystal XI, Oracle database.
What I am trying to do:
Week Range APP DEC DEP
12/27/2009 - 01/02/2010 12 1 2
01/03/2010 - 01/09/2010 10 2 1
01/10/2010 - 01/16/2010 5 1 1
The numbers under APP, DEC and DEP represent dates that are counted in the week range. This is grouped on Week (copied from previous thread).
@week
datepart("ww",{table.app_date},crSunday, crFirstJan1)
@week_range
totext(maximum({table.app_date},{@week})- dayofweek(maximum({table.app_date},{@week}))+1,"MM/dd/yyyy") + " to " +
totext(maximum({table.app_date},{@week})-dayofweek(maximum({table.app_date},{@week}))+7,"MM/dd/yyyy")
I have been able to use the thread Crystal 8.0 Group by week by year to get one of the columns above to work because I am using the app_date. But, the problem is how to get the other three totals when I am grouping on week and it only has the app_date in it.
Can I create the week and week range formulas without using the date in the table?
What I am trying to do:
Week Range APP DEC DEP
12/27/2009 - 01/02/2010 12 1 2
01/03/2010 - 01/09/2010 10 2 1
01/10/2010 - 01/16/2010 5 1 1
The numbers under APP, DEC and DEP represent dates that are counted in the week range. This is grouped on Week (copied from previous thread).
@week
datepart("ww",{table.app_date},crSunday, crFirstJan1)
@week_range
totext(maximum({table.app_date},{@week})- dayofweek(maximum({table.app_date},{@week}))+1,"MM/dd/yyyy") + " to " +
totext(maximum({table.app_date},{@week})-dayofweek(maximum({table.app_date},{@week}))+7,"MM/dd/yyyy")
I have been able to use the thread Crystal 8.0 Group by week by year to get one of the columns above to work because I am using the app_date. But, the problem is how to get the other three totals when I am grouping on week and it only has the app_date in it.
Can I create the week and week range formulas without using the date in the table?