Recent content by Jonathan212

Many many thanks smcnulty. You have given me the clue and answer to how I should do it. Much appreciated :)

I would like to see (for various completed surgery dates) whether a surgeon used the pre-allocated operating room time given to them or not. I have a table called “psallblocks” which has a field called “blockownername” (which is the name of the MD) and “scheduledstart” (which is the applicable...

Two detailed (and different) records appear per page. Data element field names are exactly the same in each detail (detail_a and detail-b) section. I am using the following (within x-2) under section expert for both detail_a and detail-b: Remainder(RecordNumber,2)<>0 I have also checked...

Thank you very much Doc Tree. I am almost there and perhaps I need to play with the font size a bit more. To further clarify, I am tryng to get the following output on one page: Front of page (8.5 x11) 8:30 AB Doe, John OR1 Ambulatory 10:00 CD Smith, Bill OR1 Same Day Back of page...

I designed a report that our nurses run the evening before surgery to print “cards” that show surgery start time, patient initials, surgeon name, name of operating room and admit type. These cards are helpful in identifying patients that need to be transported. The report is grouped by name of...

Noted.

Thanks LB. I realize this may not be the most appropriate space for an inquiry as to how I can make a snail mail donation to this Board. I understant that I can do a donation via Paypal - but I would rather send a check directly. I find the Board extremely valuable and appreciate your help...

LB and COSpringsGuy, I've got it and thanks once again for your help. I was using different formulas in different Group sections and I am pretty sure that was the source of my errors. I was using a formula "totalperday" to arrive at a weekday total and "usedplusturnover" to arrive at grand...

Thanks LB and CoSprings for reviewing this. LB: that was my thought as well. When I do a sum – it does a grand sum all the weekday totals correctly, but then the weekday totals become incorrect. In my example above, it changed the numbers to 228 (for Monday), 70 for (Tuesday), 272 (for...

I’ve got myself in a pickle. I have a report that derives total surgeon hours used per day (and total distinct cases) in the operating room. I am grouping by “surgeonname” and “dayoftheweek”. I am happy to report that output in section GF2 (by day of the week, e.g., Monday, Tuesday ….) for...

Thanks LB, it works. Most appreciated !!!!!

I have a report that grouped on surgeon name and weekdaydescription (e.g., Mon, Tue...) to arrive at minutes used per day per surgeon The report derives minutes used per case and sums up the total for each day. I need to build in 10 minutes for each case to account for turnover (to clean) the...

CoSpringsGuy and CR85User many thanks for helping me arrive at a solution. I appreciate your input and help on this. Jonathan

Thank you CoSpringsGuy, I will look into that suggestion. Do you think that will permit me to report on a room that was NOT used at all and to display that information on the report.

For the sake of this example I have five operating rooms. These rooms are called: OR1 OR2 OR3 OR4 OR5 My output for a given day is grouped by operating room name and is: OR1 Case number 12333 Case number 45666 Case number 78999 OR3 Case number 44444 Case number 55555 OR4 Case number 76767...