Search results for query: *

Thank you. Your second suggestion, "You can suppress a section with a formula like: not(DayofWeek({case_record_cr_prdate}) in [1,2])" worked. Thank you so much. Mary

I am trying to create a formula that only shows cases done on Saturday or Sunday. The field I have is case_record_cr_prdate. I created a formula called @Saturday that reads: If DayofWeek({case_record_cr_prdate}) = 7 THEN 1 ELSE 0 and a second formula, @Sunday that reads: If...

Thank you Brian, that worked PERFECTLY. Mary

I have a field, {case_record_audit_trail.cr_audit_addl_info}that displays the string- Old Patient Account#: 00035632421 (CT = S). I would like to display ONLY the number. Can a formula achieve this goal? If so, how would I write it?

Thank you all for your assistance. BettyJ's suggestion of the ToText and changing + to & created an error free formula. Always appreciate the wonderful, and quick assistance I receive from this forum. Mary

Thank you, but I am getting the error message on the ' - ' that a number is required here. Sorry this is so frustrating!!

Still not working, error message now shows the entire string, minimum({cr_prdate}) & ' - ' & maximum({cr_prdate}) with the message: "a date time is required

I too thought this would work, but I am getting an error message saying that a number is required where'-' is in the formula. Still trying other options. Thank you

Works great thank you. My only issue is to create a formula that would display only the Minimum date if the minimum and maximum dates are the same (example, both dates would be 01/02/2015 verses 01/02/2015 - 01/04/2015. I think it would be and if, then,else formula, but I am having trouble...

I have a report that has a field,(cr_prdate) that may have a single date or a date range. How would I create a formula that would display the date range of the records I am displaying (ie for single date 1/2/2015 or for weekend from 1/2/2015 - 1/4/2015) as a header formula. Thanks for any...

I fear I am not explaining myself very well, to which I apologize. Fields are as follows: v_CRA-anes_staff cr_urn anes_staff anes_staff_descr cd_seq v_CRA_anesstaff_clinicalrole_group cr_urn anesthesia_staff clinical_role cd_seq What I would like to do is create a...

{anes_staff}and {anesthesia_staff} are based on patient records and may include a CRNA as well as an Anesthesiologist OR just an Anesthesiologist Examples: MMOUSE CRNA and BMOOSE MD or just BMOOSE MD {anes_staff} would contain this information for records prior to 3/1/2014. On...

I have a report that I need to pull old data as well as new data due to a field name change. Field 1 is {anes_staff} which contains data prior to 3/1/2014. This field could have 1-3 names listed Field 2 is {anesthesia_staff} which contains data since 3/1/2014. This field also could have 1-3...

That does it, thank you both for your assistance. Mary

Thanks for the suggestion, but with the Abs in front it returns a Crystal report Error "A Number, or currency amount is required here"on the (ToText(Truncate({@totalprocmins}/60), '#'))

Do not want the - in front of the Hr and the - in front of min to display...makes it look like NEGATIVE time

Pete..your suggestion almost has me there. Some of the conversions are displaying as - Hr -Min examples: 90 displays as -1Hr-30min; 379 displays as -6Hr-19min.Suggestions on how I can fix this display?

I have a formula @totalprocmins that displays total minutes (example 79 mins) I have been asked to convert this number into hrs and minutes so 79 would display as 1 hr and 19 mins. I know this must be a relatively easy formula, but I have been away from Report Writing for several months I am...

That works Ian, thank you for supplying me with the correct formula. You Rock!! Mary

Following instructions as noted above,(based on info that 750 is 7 hr 50 mins) local numbervar min:= tonumber(right(totext(timefield, 0,""),2)); local numbervar hr:= tonumber(left(totext(timefield, 0,""),length(timefield)-2)); When I put the timefield in after length(timefield)-2)I get an error...