×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Crystal Reports Formula

Crystal Reports Formula

Crystal Reports Formula

(OP)
How do i generate a crystal reports formula which would basically tell me the number of calls resolved in the last 24 hours?

RE: Crystal Reports Formula

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
http://www.kenhamady.com/
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

RE: Crystal Reports Formula

(OP)
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"

RE: Crystal Reports Formula

That error message often appears when you have the wrong type of data.  For example, make sure that {sprt_Service_Request.Date/Time Requested} is in the correct form (either Date or Numeric).  If it is a string, you cannot subtract it.

RE: Crystal Reports 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
http://www.kenhamady.com/
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

RE: Crystal Reports Formula

(OP)
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

RE: Crystal Reports Formula

Try my originla formula again, this time try starting it with the word IF.

Ken Hamady
http://www.kenhamady.com/
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

RE: Crystal Reports Formula

Does anyone know how to create a group using the crystal report RDC object model?

RE: Crystal Reports Formula

Post this as a NEW question in the Crystal Reports Integration forum.

Ken Hamady
http://www.kenhamady.com/
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close