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

    Character Long Object - Replace strings

    Hi, I have Crystal 2008 version 12.0.0.683. I have a field called {EQUIP.SAFETYNOTE} that is a Long Character Object. I want to delete 1 - 5 standard lines. Then only if there is any data left, export to word. My initial Record Selection Formula omits null and blank fields. What I want...
  2. NiteClerk

    Excel graph using formula, not graphing a formula?

    Hi, I have Excel 2007 I'm looking to select data for a graph based on a formula. Not graphing a formula. I have Excel 2007. I have a data set where each row represents a date, then work closed out by hour (6 times a day). The relevant data I use is below: Row 2 is 4/4/11 , 50 , 75, 20, 110...
  3. NiteClerk

    Adding running totals

    Hello: I'm using CR 2008 version 12.0.0.683 I have two running totals, #OT-Hrs-room and #Reg-Hrs-room. This measures labor hours, Overtime and Regular. The running totals work, print and reset the way I want. I'm trying to add the two together with the formula @Tot-Hrs-Rm. My problem is...
  4. NiteClerk

    Add Time field to Date to get DateTime as a number

    I need to find elapsed time between when a work order was requested and completed. Searching Tek-Tips I've found elegant solutions to this. (Thanks everyone!) However due to how our data is stored I need to combine a date field with a time field. A sample of the data is: {WO.COMPLETIONDATE}...
  5. NiteClerk

    Records not in a table

    Hi, Using CR 2008 version 12.0.0.683 I have a single table and a list of records. I want to find which records are not in the table. I've tried: (Equip number list greatly shortened) // No Equipment record {EQUIP.SITEID} = "BJH" and ({EQUIP.EQNUM} in ["NE00020283", "NE00020310"...
  6. NiteClerk

    List unmatched data in table A but not in table B

    Hi, I'm using CR 2008 version 12.0.0.683. I'm trying to find data from one table that is not represented in a second table. Given table {Equip} and table {Tasks} I want to find all {Equip.EquipNum} that is not included in {Task.EquipNum}. My left table is {Equip}. I do have some Record...
  7. NiteClerk

    Find newest date on group of records CR 2008

    Hi, I have CR 2008 Developer 12.0.0.683 I'm trying to find the most recent date record in a group. I have two linked tables {Equip} and {WO}. In Report/Selection Formula/Records I've selected the Equipment I want by {Equip.SiteID} = "mysite" AND {Equip.LSCode} = "L" I have over 7000 records...

Part and Inventory Search

Back
Top