Search results for query: *

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

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?

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

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

I have 2 time fields I am trying to display the difference between. Example: v_CRA_20_Billing_Summary.time_pat_in_room results equal 806 v_basic_booking_data.book_start_time results equal 750 I am looking for the results to display 16, however the results displayed is 56 I have 2 formulas...

I have a report that list data based on a date range. I have been asked to break down the report to show total cases done on Mondays, Tuesday, Wednesdays, etc. The report is currently grouped by date, and the footer shows to total cases done on that date (count of date). I am looking for...

I have a formula to display cases started after 4pm, @StartTime_modified which is if{v_CRA_20_Billing_Summary.time_pat_in_room}<1600 then 1600 else{v_CRA_20_Billing_Summary.time_pat_in_room} I have another formula called @Total Time which is {v_CRA_20_Billing_Summary.time_pat_out_of_room}-...

I have a report that has a field in the detail section that is a formula. This formula totals the time for cases after 1600 to display in mins and hours for each case that meets the criteria. (@TimeAfter1600) I have been asked if I could display a total of all minutes for all cases for each day...

I have a report based on a group{v_basic_case_rec_data.cr_urn} I have 4 detail sections within this report. Occasionally I have duplicate records for the same {v_basic_case_rec_data.cr_urn} and I only want to show the first record, and suppress any duplicates based on the...

I have 2 fields that I need to show the difference in minutes. {pat_out_of_room} and {proc_end} When I do ({pat_out_of_room}-{proc_end}) the difference is displayed correctly most of the time. Ex: proc end = 1002 Out of Room=1008 time displays 6 However if the time fields are different...

I have been asked to create a report that will display how many minutes after a certain time a case is being done. I think this requires either an if then else formula or 2 different formulas. Example: pat_in_room field time result is 1602 pat_out_room field time result is 1751 I have been...

I have a subreport that could have 2 values. How can I write a formula to suppress one of the values? Example {booking_audit_trail.book_audit_type}contains PAT CANCELED and PAT BOOKED. I want to suppress PAT BOOKED and only display PAT CANCELED

I have a report that needs to pull different time frame data. I need to show all cases that start after 2000 and finish before 0630 for an after hours report. Suggestions on what type of formula I can write? Field is {time_pat_in_room}

I have 2 summary fields I was hoping to combine to show a total sum. Fields are: (1)Count of v_basic_case_data.surg_mnc and (2)Sum of @total_endo_cases. Is this possible?

I have a report that has a field that has 2 responses, YES or NO. This report has 14 entries, 8 YES and 6 NO I need to insert a total for all YES response so that 8 is in the footer. How is the best way to do this?

I have a report that has several fields within the detail section. I want to suppress the entire detail section if a certain field within the detail is blank. I tried the section expert suppress with the isnull({field}) but that did not work. I am not familiar with the whileprintingrecords...

I have a report that shows all procedure totals for each time a surgeon completes a procedure grouped by procedure type. Is there anyway to write a formula to show only the last 5 procedure dates? Example: date of surgery (all are for the same type of procedure) 6/13/2011 6/13/2011 5/23/2011...

I have a report that has 4 subreport based on different clinical roles. Each subreport has a formula to show that role as a number(example: circulator field has 2 names, name field is converted to display as Maximum 2 on the report) My manager wants the 4 roles(subreports) to total at the end...

I would like to convert a string field into a number if({v_CRA_other_personnel.cr_other_personnel_role} = "2ND SCRUB")then convert this role to a number Is this something that can be done, or am I trying to do the impossible?