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 bkrike 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: Ox73
  • Content: Threads
  • Order by date
  1. Ox73

    I have several scripts that do some

    I have several scripts that do somewhat that but not quite I have the read all but I think I need some kind of IF statement that says look for these words... 1. logged on user profile because file will be in the user profile C:\Users\USERNAME\AppData\Local\LOGFOLDERHASMANYFILES 2. In this folder...
  2. Ox73

    First At Job Visit

    I have Crystal version 10. I am trying to summarize to get a percentage but I am unable because each formula that I have created ends up doing the same thing. Once I do get the value I want in the group footer and then try to add it it says that I can not summarize field. I currently have 4...
  3. Ox73

    Employee's First Visit

    Hi - I have a crystal report where I am trying to count in a Work Order grouped by Employee. I am able to count and get a percent per order but now I want my main group to be by employee visits per work order. The problem is that when I group it by employee it breaks my calculation because I...
  4. Ox73

    UTC SQL Expression

    Hi, I would like to know if there is a way to use this expression only after the records have been extracted from the database in crystal...I have this SQL Expression formula and want to only calculate it once it is in Crystal not while reading the records. *************FORMULA***************...
  5. Ox73

    Date-Time minimum of one record

    I have a report that gives me e.g. 230 records. Of those records there are a total of 200 distinct records if I do a distinct count of them. Within these records I have a date/time value for some of these records most have one date/time stamp but some have a date/time that are different from...
  6. Ox73

    Date Range Group

    I have a crystal report grouped by address and showing the distinct count date. I'm looking to validate that date and only have it show me any specific addresses and dates where the dates are 7 days appart from each other. Any address that has dates less than that I don't care about. For...
  7. Ox73

    Ends With

    Hi does anybody know if there is a formula that can be created to only display the value of a field that ends in a particular character for example: If I have a list of numbers. 51234 22366 39385 69875 51864 59857 To only display all the fields that contain information that ends with 5 for...

Part and Inventory Search

Back
Top