Search results for query: *

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...

Thanks Simon: I've posted this in Crystal Forum. Sorry to take up your time, and thanks for the help....

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...

Obviously there in lies the problem!

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

Acutally Statement should read: time(DateDiff("h",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp})-(if datepart("n",{reservation_request.rr_create_stamp}) < datepart("n",{reservation_request.rr_completestamp})+1 then 0 else...

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...