Search results for query: *

Sorry, it was quite simple! Figured it out.....

Only want the date & times of the first entry and the last entry in a procedure log. Example: Date/Time Description Patient A 9/1 11:00 Baseline 9/1 12:00 Patient IV inserted 9/1 12:30 Patient discharged Patient B 9/4 9:00...

Thanks, lbass! Your solution was perfect. I actually search for your solutions on this site, your explanations are always clear, concise and correct!

Yes, sorry, 1 group with 5 instances... The running total is a formula field called @glutotal, counting occurence of glucose: If {test} = "glucose" and and {PROC_TYPE} in ["CHEM", "RIA"] then 1 else if {test} = "glucose" and {PROC_TYPE} = "special" then 0 I'm summing this {@glutotal} in each...

Have a report using groups and running totals; need to calculate sums for only 2 of the 5 groups. Example: Group 1 ID test user case # 333 glucose RSmith 1 333 chol DWills 0 333 T4 SHall 1 Group 2 ID test user case #...

Thanks, worked perfectly!

My report groups data by Employee name, ID# then details test name. I need to exclude ID#s based on a test name in the detail. Example: Smith ID#000265576 Art Access Rt Coronary Angio Left Heart Cath Hemostasis Jones ID#000266954 Art Access Right Heart Cath Hemostasis Left Heart Cath I...

Worked, thanks!!!

kskid, when you say "group by name", what field are you referring to?

I'm a new Crystal IX user. I've read all the threads about removing duplicate records and still need assistance. Data looks like this: MR # Procedure Start Time End Time 123 Diag Cath 8:55AM 9:45 AM 123 Inter Cath 8:55AM 10:36 AM 456 Diag...