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: *

  • Users: gallobask
  • Content: Threads
  • Order by date
  1. gallobask

    Can not view text field in formula editor

    The database I use has some fields that are text_value/memo fields. They do not come up in the formula editor. Is there any other way to use these fields in crystal?
  2. gallobask

    How to calculate a running average off of a variable formula

    I have several variables to get the first and last records of some fields. 1st pain score (numbervar first_score), 1st temperature (numbervar first_temp)etc...my reset formula for the variables is on change of patient header. I am told to calculate a running average for each record....like this...
  3. gallobask

    Need 1st record of a group but not if repeated.

    I have to create a report looking for the first surgery case in a room. I can get that easily enough, but if a surgeon is the first doc working in 2 different rooms I only want his earlier start case. Example: Grouping on OR Room (Using a variable to count the records and suppressing anything >...
  4. gallobask

    How to group on the letters of the alphabet?

    I am using version 8.5. I want to grouping to show the letters of the alphabet. I do not want to base it on a field since I need ALL letters of the alphabet to display - even if I get no records returned starting with that letter. This is for a patient list report and there needs to be a header...
  5. gallobask

    How to group by 1st Monday, 2nd Monday etc

    I have a report that sorts by DOW and then by date. How can I get a grouping to sort so that the first Mondays etc. are together? Example: now would like Monday 1st Monday 10/5 10/5 10/12 11/2 10/19 10/26 2nd Monday 11/2...
  6. gallobask

    How to get totals and subtotals using Nth largest Summary

    I am using the Nth largest in a standard summary to eliminate some redundant data but I can't get a summary/total to work off of this field. The Nth largest summary is not created from a data field but a formula. Any ideas? Thank you!!!!
  7. gallobask

    How to add a time value in string format to a number value

    I'm working in crystal 8.5. My database stores military time in a string format (13:15) I have another field that gives me estimated time in minutes (90)but the field is a number field not a time field. I need to add the two fields to get a time. 13:15 plus 90 minutes gives me 14:45. I have...

Part and Inventory Search

Back
Top