Search results for query: *

I have two numerical fields {vst.end_time} and {vst.begin_time} which display military time as numbers. I just want the difference im minutes between the two. When I have {vst.end_time} = 1325 and {vst.begin_time} = 0905 I want 295 minutes difference not 420. //When I try the following it...

I have a report that works perfectly when I export the report data as CSV in standard Mode with the Isolate Report and the Isolate Group checkboxes selected. Works perfectly..... Now I need to schedule the report to run weekly and the Isolate options are not available which changes the entire...

I have a report that I want to show 6 pipe deliminated codes for each patient. If the Code does not exist then I still need to reserve a pipe position for it. Example below has 4 codes for the patient John Doe: John Doe 1 aaa 2 bbb 3 ccc 4 ddd 5 6 This should display as...

I have a scheduled report that pulls patient data and creates a *.pdf document. I need to create a seperate file that contain only the Patient Name, Number, and Start date. Any ideas, suggestions or answers?

I need to list the highest patient count during last year. Each patient {Patient.PatientID}, has a start date {Patient.StartDate} and an end date {Patient.EndDate}. I am calculating if a patient is active during the year with the following: {Patient.StartDate} <= {?End Date} // 12-31/2010 and...

I have a report that does a count on a visit field that needs to ignore suppresed items. This formula is called @Count. Now I want to use the maximum @Count result in another formula but I do not know how. Please help, example below. Patient Start End @Count Min Max Visit John Doe...

//This is my formula that works unless //the {ep_discipline.dc_reason_code} = "" then //nothing displays. Should I populate the blank //with bogus data or is their a way around this? //If I should populate with bogus data then how? //So if {ep_discipline.dc_reason_code} = "" and...

I have a Crystal XI report that has a date parameter that requests start date and end date upon refresh. How do I display these two values in the report header so I can display "THIS REPORT WAS RUN FOR dd/mm/yyyy to dd/mm/yyyy"?

I am writing a report for Hospital patients. Each patient has a start date and a discharge date for the buildings that they recieve treatment in. I am working on a report that displays the patients that moved from one building to another withen 7 days. I want to count each patient who has met...

I have a list of Employee charges that I want to calculate sums on by type. Employee Charge Type Bob $1 car Bob $3 bike Steve $1 car Bob $2 car Bob $4 bike So based on the...

It appears that my 'OR' statements never really work in Crystal XI. Am I doing something wrong, or does a better way exist? For example I am using this and it is droping items where the episode.refer_date IsNull. //************************************** (({episode.refer_date}= CurrentDate)...

I have a report that pulls in multiple diagnosis for a patient. I want to also list the disciplines which are also multiple. The problem is that the report lists the Disciplines again for every Diagnosis. I want to list the Disciplines once, and on one line. THIS IS EWHAT I HAVE: Pat_Name...