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!

  • Congratulations strongm 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. 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...

Part and Inventory Search

Back
Top