Search results for query: *

Went for the latter option thanks... My brain is starting to wake up now.. enjoy your weekend Steve Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports) Visit www.reports-for-healthcare.com for 10% discount.

Hi, I think this is a simple one, but my brain is dead this morning. I have a date/time field called {DIAGNOSI.END_DATE} I need an IF statment to say is the date is = 01/01/1900 then "" else {DIAGNOSI.END_DATE}. The rougue date needs stripping out...to give a blank field. I can't even get...

Hi, I was trying to update the object above the tables.. Now I've mapped the tables across it works fine... Thank you sooooo much Steve Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports) Visit www.reports-for-healthcare.com for 10% discount.

Hi, Thanks for your quick response.... I've tried setting the datasource location and get the same error message... Its seems like its caching the connection or trying to find it when go to update it... rather strange.. it happens with all the reports I've written which I'm now trying to...

Hi, I've written Crystal Reports using XI edition to report from my sql database. These reports were written on another PC pointing to a sql server datasource. Using SQL server 2000. I've transfered the reports to my laptop as I have a local copy of a database which has exactly the same...

Hey dgillz, I managed to do it.. Thanks for your help :) Steve Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports) Visit www.reports-for-healthcare.com for 10% discount.

Hi all, I'm trying to extract the strength of a drug from a string. The string {xdailyissues.drug_strength} can be any one of the following formats: 125 mg 2 g 1.2 mega unit 200 mg in 5 ml 100mg in 5ml I want the formula to output the result in milligrams. For those of you who dont know...

Your a star ! thanks S Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports) Visit www.reports-for-healthcare.com for 10% discount.

Is it saying 7 hours and 7 minutes ? I interpreted it as 7 hours 70 minutes, which is obviously over 8 hours.... Which line could add in extra zeros so it would say 07:07 if it is 7 hours and 7 minutes ? Steve Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal...

OK. The formula I am using is this: numbervar mindiff; if isnull({PATDRUG.TIME_ARRV})or trim({PATDRUG.TIME_ARRV}) in [":",""] or isnull({PATDRUG.TIME_FIN})or trim({PATDRUG.TIME_FIN}) in [":",""] then mindiff := 0 else mindiff := datediff("n",datetime(currentdate...

Errrm.. Sorry about this... I thought this was fixed... I'm still getting some time values which are over 60 minutes.. eg 7.7 rather than 7 hours and ..minutes.... I've tried to look through the formula but not managed to work out where its going wrong... Any help greatly appreciated as ever ...

Thanks for all your help... I've now managed to sort it :) Steve

Hi there, I'm stumped with this one, any help gratefully recieved I have an upgrade copy of XP PRO, but as its an upgrade copy I cannot install it as a full copy, an instance of XP has to exist already. Thats no bother as I have another internal drive H: which I installed it on. As this...

Hey Thats great.... Thankyou soooooo much :)

Hi, I'm getting a "bad time format string" error at this point.. time({PATDRUG.TIME_ARRV}) below is the entire formula. numbervar mindiff; if isnull({PATDRUG.TIME_ARRV})or trim({PATDRUG.TIME_ARRV}) = ":" or isnull({PATDRUG.TIME_FIN})or trim({PATDRUG.TIME_FIN}) = ":" then mindiff := 0 else...

Thanks... Its now saying "A number is required here" highlighting the last line of code... totext(hrs,0,"")+":"+totext(mins,0,"") Steve

Hi, Thanks for your help.... I'm getting an error at the semi colon. "The ) is missing" At the end of this line... mindiff := datediff("n",datetime(currentdate, time({PATDRUG.TIME_ARRV}),datetime(currentdate,time({PATDRUG.TIME_FIN}))); Steve

Hi LB, yeah eliminate them as they wont count... Steve

Hi all, I've spent a fair amount on time on this already, so I dont post something with an obvious answer... I have a time start field called {PATDRUG.TIME_ARRV} and time finished field called {PATDRUG.TIME_FIN}. They are both string fields and the time is recorded on the same day. Somtimes...

WOW that was quick... Thankyou both soooooo much ! :)