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!

  • Congratulations TouchToneTommy 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. newbie0423

    Operating Rooms Running Report

    Hello, I am using Crystal 11. I'm trying to create a report that will show how many operating rooms are running for a particular hour of the day. I am using the patient's in room time and the patient's out of room time. Using these two fields/times helps me to count the number of CASES for...
  2. newbie0423

    Average Excluding Zero

    [bigsmile]Hi Pete, I've decided to do my calculations manually. this is causing me way too many headaches. Thanks again for all of your help, you've been great......ttyl :o)
  3. newbie0423

    Average Excluding Zero

    Hi Pete, I'm not getting any error message, but I'm getting 0 as the results. This is what I have: In the GF: WhilePrintingRecords; Global NumberVar RT15_16; RT15_16 / ({?End Date} - {?StartDate} + 1) and in the RF WhilePrintingRecords; Global NumberVar T15_16; Global NumberVar RT15_16 :=...
  4. newbie0423

    Average Excluding Zero

    Hi Pete, I tried using the formula but I got an error message saying that a "number is required here" {?StartDate} is highlighted.
  5. newbie0423

    Average Excluding Zero

    Hi Pete, I am determining my date range by using two parameters. StartDate and EndDate.They are set up to not allow for a range.
  6. newbie0423

    Average Excluding Zero

    Thanks for your help Pete. I apologize for the vague examples. Your second description explains what I'm trying to accomplish best. When I used the second formula I got an error message that "this field can not be summarized". At this point I don't know what else to do . You have given me...
  7. newbie0423

    Average Excluding Zero

    Hi Pete, I am still using the code that you gave me in the previous thread. I was running the report for one day, but now I am running the report to get a months worth of data. I do have the report grouped by day.In the running total I have the field to summarize @3-4hour, evaluate on change...
  8. newbie0423

    Average Excluding Zero

    Ok, I'm sorry I'm doing such a crappy job of explaining this. I've been tasked to get the average number of rooms running per hour for each day. I am running the report for three months. If a case was running in a particular hour a 1 populates, if not it's a 0. There could be a total of 68...
  9. newbie0423

    Average Excluding Zero

    Hi Pete! The RT is set to average, but it is returning 1. This is the same report that you helped me with in thread767-1715296. It is doing an average counting all of the detail lines instead of only those that have a one value. For instance: it is (1+0+1+1+0)/5 I want it to be (1+0+1+1+0)/3
  10. newbie0423

    Average Excluding Zero

    Hello When doing a running average or just average it there a way to exclude 0's that are in details.. I have a report that I am summing the number of rooms that are running. For every hour it either counts it as a 1 if there was a case for that hour or a 0 if there was not. At the group...
  11. newbie0423

    Crosstab Help

    Hi Pete, The formulas work perfectly!!! Thank you so much for ALL of your help. :o) Val
  12. newbie0423

    Crosstab Help

    I took off the Summary fields and It works!!!! I have a patient that came in at 21:35 and didn't leave until 01:05. they showed up in all hours preceding and after 12 midnight! Thanks Pete!!!! Will you show me how to use variables to total.........
  13. newbie0423

    Crosstab Help

    Hi Pete, Thank YOU!! The formula saved without any errors being found. However, when the report runs I get a message saying that " A summary has been specified on a non-recurring field." This is what I have: WhilePrintingRecords; Local NumberVar IT := {v_CRA_20_Billing.time_pacu_start}...
  14. newbie0423

    Crosstab Help

    Hi Pete, Thanks for responding. I will continue to try different things until I hear back from you. Thanks Val
  15. newbie0423

    Crosstab Help

    Hello, First I'd like to take this opportunity to say thank you for providing me with an excellent solution to my report to capture recovery room times. I have written 24 formulas for each hour that the patient can be n the recovery room. I am having an issue with the formula for 12 midnight...
  16. newbie0423

    Crosstab Help

    It works! Thanks so much for all of your time and effort to help me with this. Now I just have to make 24 formulas!!! Thanks Pete.
  17. newbie0423

    Crosstab Help

    Yes, it is a number not text.
  18. newbie0423

    Crosstab Help

    Is there anyother way for me to get the results that I need?
  19. newbie0423

    Crosstab Help

    I'm sorry Pete, I have limited access to the system. I am not able to provide the way the field is structured in the database. I can only tell you that the ({v_CRA_20_Billing.time_pacu_start}) field in crystal says that it is a number. Thank you for all of your replys. Val
  20. newbie0423

    Crosstab Help

    Yes Pete, that is the exact formula that I am using. and that is the formula that you posted for me to use. it is returning zero. I tried to replace your formula with the formula below, but the "a date-time field is required" message appeared. @0RStarttime is a time field. If Not (...

Part and Inventory Search

Back
Top