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 Mike Lewis 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. piepmeier

    Long Select Statement

    You have given me several things to work on and it make take me a few days due to travel to try it out. I will let you know. Thanks for the input.
  2. piepmeier

    Long Select Statement

    I am trying to create a report that selects information for our "tier 1" products. The list of tier 1 product is about 300 items long. If I put these into the formula editor in the following format (listing all 300 numbers) {cqi-shp-rma.item} in ["80295", "80296&quot...
  3. piepmeier

    Weighted Moving Average

    I am simply doing 205/410 or 50% on time which is not the same as the average of the average for each day (this is what the moving average trendline does in CR). For a five day moving average, day 1 would drop off the next day and you would do the same calculation for days 2-6. Thanks, Craig
  4. piepmeier

    Weighted Moving Average

    I am currently plotting the % On Time performance for shipments on a daily basis. I want to add a trend line showing a weighted moving average of this value (takes into account days with large volumes). The moving average trendline option in CR 8.5 is only a moving average. I only want to...
  5. piepmeier

    ODBC Error Linking Tables

    I am trying to link a table to an existing report from a Progress database. I can add the table to the report but when I place a field on my report I get the following error message, "ODBC Error: Merant ODBC Progress Driver, Unable to understand after -- DECLARE. 247" and then...
  6. piepmeier

    Excel: Structure Data for Charting

    I have a column in a spreadsheet that has value(s) in it that are comma delineated. Each PL in Column B relates to an (ECO)in Column A. I want to plot the number of ECO's for each PL but I can't figure out how to structure the data to do so. For example I have: Column A Column B ECO#1 PL1...
  7. piepmeier

    Impromptu Catalog File

    Can I access data that is in a Cognos Impromptu catalog (*.cat) file using Crystal Reports?
  8. piepmeier

    Current Month to Yesterday

    I am trying to create a selection criteria for all data month-to-date through yesterday.

Part and Inventory Search

Back
Top