We just recently purchased V.S.Net 2003. We have Cyrtal Reports 8.5. We are looking for the Crystal Functionality in V.S.Net that says It is included. Does this began with version 9.0 or should V.S.Net have that functionality requardless of whether you have Any Crystal Version...which is what...
We just recently purchased V.S.Net 2003. We have Cyrtal Reports 8.5. We are looking for the Crystal Functionality in V.S.Net that says It is included. Does this began with version 9.0 or should V.S.Net have that functionality requardless of whether you have Any Crystal Version...which is what...
Using Crystal 8.5
I'm trying to get a difference between my create and complete timestamp. The statement works fine except when my statement is > 24 Hours. I then get an error. Here is my statement. How should I change it to get the statement to calculate correctly...
I'm doing a calculation in a Formula that works fine until I reach the 24 hour mark which makes my forumla invalid.
Can someone tell me what I need to do to update the statement to account for times greater than 24hours?
My Statement...
Yes:
Format([reservation_request.rr_completestamp]-[reservation_request.rr_create_stamp],"d hh:nn")
Using Crystal 8.5
Error message states: "There is an error in the formula, do you want to save it?"
([reservation_request.rr_completestamp]-[reservation_request.rr_create_stamp],"d hh:mm")
Yes I've tried it exactly like above and with various Other things mixed with it. It doesn't like the statement.
Getting errors no matter what varation I use on this one. Here's what I have now, but it's NOT right:
Datepart("h",{reservation_request.rr_completestamp}-{reservation_request.rr_create_stamp}),"d hh:mm")
Suggestions are welcomed....!
Basically its just calculating the difference between a Created Timestamp Field and a Completed Timestamp field in HH:MM
The problem, as I stated, is that once the time becomes greater than 24 hours I get an error statement in Crystal that says time must be betwee 0 - 23 hours.
I know what the...
Thanks
But I'm having trouble finding exactly where in my statement to insert your Line. What exactly do I need to alter? I've tried a few things and nothing has been successful.
Appreciate the help DrSimon
How do you account for times great than 24 hours?
My statement here which works fine for up to 24 hours gives me an error OVER 24 Hours:
time(DateDiff("d",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp})-(if datepart("n",{reservation_request.rr_create_stamp}) <...
I'm doing a calculation in a Formula that works fine until I reach the 24 hour mark which makes my forumla invalid.
Can someone tell me what I need to do to update the statement to account for times greater than 24hours?
My Statement...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.