Search results for query: *

I tried the formula and it is getting hung up on the than in the IF statement Here is a copy of what I have so far. //<Formula FIRSTCASE> //insert this formula in the details section //include all the variables that you put in the Init formula Shared Timevar tInit; shared Timevar tFirstCase...

I have also used the below formula but it will not calculate the time difference if it is after midnight DATEDIFF("n", DateTime ( DATE({v_basic_case_rec_data.cr_prdate}), Time ( TONUMBER(TOTEXT({v_CRA_or_pt_time_group.pt_time_inroom},"0000")[1 to 2])...

I am using Crystal XI. This will also calculate the cases that start before midnight and end after midnight correctly?

Thanks. I will try that.

The formula below is a formula that calculates the time difference and it includes after midnight formula so we can report on how long a surgery was. The problem with the formula is that if the time difference is under 60 min. I get a 0 for the time difference. Do you have any suggestions as...

I am not sure I am following you. Some times the first surgery in a room could be at 10:00 and some at 7:30. I am trying to find just the first case of the day for each room so I can report on the on time starts.

I have Crystal XI and I write reports for a surgery department with 11 operating rooms. I need a formula that will select just the first case record of the day for each room no matter what time it started.

Thank you for your help. It is working now.

No. The field that has been changed is a free text multiline field just like the old one.

{table.date} >= date(2009,4,15) When I did the above, the subreport surpressed for the complete report. Even prior to 04/15/09

I am not trying to make you guess. I have a report. In this main report there is a subreport (I will call subreport 1) that has one field in it. The program that I am pulling information from, they changed that one field that is in the subreport 1 to a different field. Now, I need to put that...

I am trying to surpress the subreports in the main report thru format editor for the subreport. Not the report section.

I have a report that has a subreport that is from a free text field. They changed the field to another free text field. I need to put both of these sub reports on a report but surpress the old one if the report date is on or after 04/15/09. I put in the formula of: {my.date.field} >= Date...