Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigDaddyE

    Time Difference with numbers

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

    Maintaining CSV style on sheduled report

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

    Maintaining CSV style on sheduled report

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

    Create a blank record if one does not exist.

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

    Create a blank record if one does not exist.

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

    Need to create a seperate index file for report.

    Would report bursting work? Any tips on report bursting?
  7. BigDaddyE

    Need to create a seperate index file for report.

    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?
  8. BigDaddyE

    Maximum count during year

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

    Maximum count during year

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

    Finding Maximum on a formula?

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

    Finding Maximum on a formula?

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

    Finding Maximum on a formula?

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

    Populate blank field with data.

    Did not work.
  14. BigDaddyE

    Populate blank field with data.

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

    Populate blank field with data.

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

    Populate blank field with data.

    //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...
  17. BigDaddyE

    Display Date Parameter range in report header

    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"?
  18. BigDaddyE

    Moving from one building to another with Crystal Reports

    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"]=...
  19. BigDaddyE

    Moving from one building to another with Crystal Reports

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

    Moving from one building to another with Crystal Reports

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

Part and Inventory Search

Back
Top