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

    BottomCount in Record Selection Formula

    Assuming that you have a field called Year, then put this in the Record Selection formula: {DB.Year} in ["2010", "2011", "2012", "2013", "2014"] or you could use greater than/less than. >= and <= . If you have an actual date field you can use: {DB.Date} in Date(2010, 01, 01) to Date(2014, 12...
  2. NiteClerk

    Date formula

    I don't have the exact coding, but you should be able to use two Parameters. Call them Start and End. The customers enter the request dates there. Then in the Report/Selection Formula/Record you have something like: {Table.field} in Date(?Start) to Date(?End) HTH. Bob
  3. 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...
  4. NiteClerk

    Adding running totals

    Thank you LB. I beat my head against this on and off for two days. I appreciate you and all the rest here at tek-tips.com . I search the threads frequently for solutions to my question. Thanks again !!! ~Bob
  5. 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...
  6. 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...
  7. NiteClerk

    Add Time field to Date to get DateTime as a number

    Thanks LB ! Also thanks to everyone who post solutions here and the folks who hosts Tek-Tips. I frequently find solutions to my report problems when searching Tek-Tips. Plus I learn a lot from reading the solutions to other people's posts. I do appreciate all you experts who keep helping...
  8. 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}...
  9. NiteClerk

    Records not in a table

    Update. I just realized that in my Design section I'm trying to print the EQUIP.EQNUM Which if it does not exist, will of course not print. So how do I print the Equip Numbers from my list that is not in the table?
  10. 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"...
  11. NiteClerk

    Deleted field rises from the grave

    Try setting your paper size to legal or larger. I normally set my page size to legal or sometimes a custom 36" so I can export vast number of columns to Excel. Anyway at some point I changed the size to letter. Whenever I ran the report the mystery fields would appear. I couldn't see them in...
  12. NiteClerk

    List unmatched data in table A but not in table B

    Thank you Hilfy! That's exactly what I needed. Bob
  13. 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...
  14. NiteClerk

    Find newest date on group of records CR 2008

    Thanks elsenorjose! That did the trick.
  15. 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