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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Reports Formula
- Thread starter olu
- Start date
Do you have a date/time field to tell you when each call was placed? If so use:
If currentDateTime - {yourfield} < 1
then 1
else 0
No do a grand total sum of this field. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
If currentDateTime - {yourfield} < 1
then 1
else 0
No do a grand total sum of this field. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Thread starter
- #3
Hi Ken, i have tried what you asked me to do... i have a field called 'Date Requested' which was basically the date the call was raised. I tried out ur formula but it seems to be giving me some errors, which i couldn't figure out. Please see below.
FORMULA:
CurrentDateTime - {sprt_Service_Request.Date/Time Requested} < 1
then 1
else 0
ERROR:
"The Remaining Text does not appear to be part of the formula"
FORMULA:
CurrentDateTime - {sprt_Service_Request.Date/Time Requested} < 1
then 1
else 0
ERROR:
"The Remaining Text does not appear to be part of the formula"
right click on your date/time field and select "browse field data" to find out what data type it is.
Also, what exactly do you mean by 24 hours? do you mean exactly 24 hours at the time you run the report, or do you mean all of yesterday regardless of the time the report is run. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Also, what exactly do you mean by 24 hours? do you mean exactly 24 hours at the time you run the report, or do you mean all of yesterday regardless of the time the report is run. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Thread starter
- #6
Hi Guys and thanks so much for replying to my mail....
The field is a date/time fieid.
By 24 hours, i mean the hours at the time i run the report, when the status of the call is set to resolved.
This was the formula i had before, but it wasn't calculating it correctly.
{sprt_Service_Request.Date/Time Resolved} > (CurrentDateTime - 60 * 60 * 24)
I look forward to a reply soon. Thanks
The field is a date/time fieid.
By 24 hours, i mean the hours at the time i run the report, when the status of the call is set to resolved.
This was the formula i had before, but it wasn't calculating it correctly.
{sprt_Service_Request.Date/Time Resolved} > (CurrentDateTime - 60 * 60 * 24)
I look forward to a reply soon. Thanks
Try my originla formula again, this time try starting it with the word IF. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Post this as a NEW question in the Crystal Reports Integration forum. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Status
Similar threads
- Locked
- Question
- Locked
- Question