Search results for query: *

I have a report that pulls all the implants inserted in a surgical procedure. Looks like this: patientname implant marc stent screw rod screw2 Now I'd like to add the staff names that worked that case. I tried just...

For Crystal 8.5: I have the select expert written to select those records in this date/time: {casemain.schedcase_start_datetime} in {?frmdttm} to {?todttm} This report is to run for a month at a time. Can I keep this formala to choose those selected dates, but only those records where the...

Using Crystal 8.5: I want to retrieve data where one of two events occurred. Right now my formula looks like this: {casemain.is_casecanceled} = 0 and {casemain.actcase_start_datetime} in {?frmdt} to {?todt} and {casereslist.resrole_id} = 25.00 or {ancilservice.ancilservice_id} = 6.00 My...

Using Crystal 8.5. I have a report grouped by date. The details section includes patient name, medical record number, subreport 1 (which contains only one field), and subreport 2 (which also contains only one field). I'd like the report to only generate data on those records where there is...

Can I select only those records where records are present in one of two (or both) subreports? Thanks for any assistance.

I'm using a healthcare software to find all the insurance a patient claims for a single visit. Is there a way (?formula?)to list them all in one details sections, with out using the suppress if duplicated. I can't use that since the patient may have several different exams in a day at the...

What's the formula to convert total seconds to HH:MM? Thanks for any help.

Thank you so much!!!

Thanks LB!!

I'm using a healthcare software that tracks insurances used by a patient. I'd like to pull out all the payers used for a single patient while keeping them together in one record. Right now I get something like this: John Smith Medicaid John Smith Medicare John Smith Blue Cross...

By the way, this is Crystal Reports 8.5

I've created a formula that shows the elapsed time between a startdate and stopdate in the format of HH:MM (see below). It works great. Now I need to sum these string fields in HH:MM format. Any ideas??? I don't even know where to begin. Thanks for any help you may have. Matt...