Recent content by piepmeier

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.

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

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

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

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

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

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

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