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!

Recent content by TMcCrillis

  1. TMcCrillis

    PLT converted to PDF and "PLACED" in PM7 prints "light"

    I have several .plt files that have been converted to PDF and then placed into a PM7 document. Everything prints great on an office laser. Looks great on screen. Sent to the printers and they bring back a proof with 20 pages (out of 48) with "ghosted" images. They are there, but so light you...
  2. TMcCrillis

    Evaluate/Calculate records against each other?

    Changing the formula per your suggestion, to: //{@diff} to be placed in the detail section: whileprintingrecords; numbervar add; numbervar diff := datediff("d", {V_ITEM_HISTORY.DATE_HISTORY}, next({V_ITEM_HISTORY.DATE_HISTORY})); if {V_ITEM_HISTORY.CODE_TRANSACTION} = 'J52' and...
  3. TMcCrillis

    Evaluate/Calculate records against each other?

    Average works fine thank you!- however I need to account for the built to order parts which have a day count of 0-2 days. So what I'm looking to do is have a set of results which contain 9 serial numbers, with the following results 8,7,7,7,0,0,17,14,25 for number of days on shelf (@diff)from...
  4. TMcCrillis

    Adjusted Average?

    Thank you for your help. I appreciate it. It was not my intention to "waste everyone's time". As I mentioned, I'm very new to this and am fighting my way through as I go.
  5. TMcCrillis

    Adjusted Average?

    //{@diff} to be placed in the detail section: whileprintingrecords; numbervar add; numbervar diff := datediff("d", {V_ITEM_HISTORY.DATE_HISTORY}, next({V_ITEM_HISTORY.DATE_HISTORY})); if {V_ITEM_HISTORY.CODE_TRANSACTION} = 'J52' and {V_ITEM_HISTORY.SERIAL_NUMBER} =...
  6. TMcCrillis

    Adjusted Average?

    I can't use a running total because the data that I need to pull the adjusted average from is not stored in a table. It is part of another formula. Can I still use a running total?
  7. TMcCrillis

    Adjusted Average?

    Thanks for the info. I can't exclude the records because I still need them for the subreport...I need to see all records for a serial number when the subreport(on demand) is opened.
  8. TMcCrillis

    Adjusted Average?

    I'd like to create an average in Crystal 8.5 however, I need the calculate to exclude any quantity of 0 or 1 from the average. Part Days 1A 20 1A 37 1A 5 1A 1 1A 0 1A 3 I have an average calculated already which would give me an average of...
  9. TMcCrillis

    Evaluate/Calculate records against each other?

    Thank you so much for your help. I really appreciate it. If I could ask one more question, how can I get an average days on shelf for each part number. I tried: Average ({@diff}) ...which didn't work. Thanks again!
  10. TMcCrillis

    Evaluate/Calculate records against each other?

    if {V_ITEM_HISTORY.CODE_TRANSACTION} = 1 and {V_ITEM_HISTORY.SERIAL_NUMBER} = next({V_ITEM_HISTORY.SERIAL_NUMBER}) then add := add + diff else if {V_ITEM_HISTORY.SERIAL_NUMBER} <> next({V_ITEM_HISTORY.SERIAL_NUMBER}) and {V_ITEM_HISTORY.CODE_TRANSACTION} = 1 then add := add +...
  11. TMcCrillis

    Evaluate/Calculate records against each other?

    Part_Number (from Main Report) 115TL20 Serial_Number Date_History CODE_TRANSACTION 44586 04/26/2006 J52 (On Shelf) 44586 05/10/2006 J55 (Off Shelf) 54423 08/21/2006 J52 56871 09/25/2006 J52 56872...
  12. TMcCrillis

    Evaluate/Calculate records against each other?

    I'm new to crystal and know what I do only by "hands on", what I've figured out on my own... so be gentle.... I'm trying to calculate the # Days a product was on the shelf. I have records from the same table that I need to calculate and I don't have the first idea how. I've created the main...
See more

Part and Inventory Search

Back
Top