I grouped by CurrentDate -1, MTD and YTD - scheduled to run daily. When I look at the report that ran today it's good - showing all 3 groups. When I try to look at any previous day's report it only shows MTD and YTD. It no longer displays the single day group(it did when it was originally ran), instead the records appear under MTD. I have a parameter version of this report that has no problems. I thought there might be a problem with using CurrentDate. I also tried storing the date in a variable - didn't work.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problems with group by CurrentDate - Crystal 1
- Thread starter SPBarran
- Start date
-
1
- #2
synapsevampire
Programmer
I thought that I'd responded to this...
Use printdate or datadate instead, as when you look the next day, currentdate no longer is what it was, however either of those dates will be.
Hopefully I understood the concern correctly.
-k
Use printdate or datadate instead, as when you look the next day, currentdate no longer is what it was, however either of those dates will be.
Hopefully I understood the concern correctly.
-k
If you want to look at the previous date based on a specific date, and then have MTD and YTD based on that date, then I think you need to use a parameter for that date, so that your Date-1 column formula would look like:
if {table.date} = {?date}-1 then {table.amount} //etc.
...which I guess is what you meant by the parameter version of your report.
-LB
if {table.date} = {?date}-1 then {table.amount} //etc.
...which I guess is what you meant by the parameter version of your report.
-LB
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question