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...

Sorry the format must be as follows as a CSV export: "Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted" "0068818340","30100","000675.00","ANNA","SMITH","10/23/2012" And you can only get this by selecting the Isolate options on an Export. If you do not select the...

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...

Currently data is grouped by {patient.ID} and I would like to only display the delimited filed shown. EX: |Doe|John|aaa|bbb|ccc|ddd|||

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...

Would report bursting work? Any tips on report bursting?

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 am wondering how to figure out what {table.date} would be. I only have the {Patient.StartDate} and {Patient.EndDate}..... So every date between and including the two dates are what I am assuming {table.date} would be. I just do not know how to do that.

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...

The SQL options seems like the way to go. I can email you a pdf that displays what I am attempting to do. I have also attched the SQL for this report, ***And below is the content of the count.*********** Whileprintingrecords; If ({visit.vst_date} in {FCDCycleHeader.CycleStartDate}) to...

This just gave me the same number that I already had. I need something to just return the Max @count so I can change the colors, but I continue to get the error ERROR: This field cannot be summarized.

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...

Did not work.

Sorry about the paren, they make it easier for me to see what is happening. The fields are blank because {ep_discipline.dc_reason_code} stands for episode discharge reason code. the specific patients that are missing from my data are still active patients. A patient is active until they get a...

Nope. Sorry I attempted to simplify the code, it actually looks at the previous {ep_discipline.dc_reason_code} which will always be 37 or 20. But if the person is still active they have a blank {ep_discipline.dc_reason_code}. So when the current {ep_discipline.dc_reason_code} is blank it can...

//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"?

If (( (not onlastrecord) and //just added ({patient.med_rec_num} = next ({patient.med_rec_num})) and ({ep_discipline.dc_reason_code} = ["37", "20"]) and ({episode.team_code} = ["28", "29"]) and ({episode.dschg_date} in {?Discharged Date}) and (["84", "85", "87", "88"]=...

Allright. lbass this worked almost perfectly. The only problem is that the very first record and the very last record in the results has nothing to do with the filter. I am guessing this is because of the {table.patient} = previous({table.patient}) Any suggestions on how to modify the code...

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...