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

    Retrieving pricing for the most current Effective date

    I have SKU's that some are "KIT's" (made up of multiple components) and some are not. My crystal report drills into the KIT sku's in-order to sum the price for components and simply return the price when its not a kit. I have been working with the "Add Command" function in crystal reports...
  2. klgoist

    Retrieving pricing for the most current Effective date

    Just an update to let you know that this solution is not going to work for the report I am building.
  3. klgoist

    Retrieving pricing for the most current Effective date

    pmax9999, This almost works, I found an issue with the way my data on my report is grouped and thus it is causing Summed Pricing to be much higher than it should be. I am still working on this solution since it has gotten me the closest to the solution I want.
  4. klgoist

    Retrieving pricing for the most current Effective date

    I am working on it this week and will let you know. Thanks.
  5. klgoist

    Retrieving pricing for the most current Effective date

    I have a table that is storing pricing with an effective-date, but no end-date. I need to get the pricing for the most recent effective date and I have been struggling to find a solution in CR2016. Below I am providing an example of two SKU's with different effective dates and they also have a...
  6. klgoist

    Current pricing record

    lbass, Thanks for the info. I have a number of crystal reports that need updated due to a change made by our ERP provider and how they store the pricing records. Each report has a slightly different need which has forced me back to the drawing board so to say.
  7. klgoist

    Current pricing record

    I have an SQL Database(Progress Openedge) and I am using Crystal reports XI r2 I have a table(prod_price) with the following sample data, and I am trying to do an "Add Command" in Crystal, where I am only grabbing the records for the currently active price records. In the future, as prices are...
  8. klgoist

    Replacing consecutive zeros in a string with a period

    Thank you Brian, I was so close to getting this. I was actually playing with that part of the code, but I hadn't thought to comment it out.
  9. klgoist

    Replacing consecutive zeros in a string with a period

    ok, so I started digging deeper into my results from the above code and here where I'm at. 04000000000000039 returns 04.39 04000000000010439 returns 04.10439 but when I hit on numbers like 04000000000300600 the result I get back is 04.3060, but of course this need to be 04.300600 Any...
  10. klgoist

    Replacing consecutive zeros in a string with a period

    Ian / Brian, Thank you for the help. Ian's modification to Brian's code gave me exactly what I needed. Ken
  11. klgoist

    Replacing consecutive zeros in a string with a period

    Brian, you are on the right track, but when I ran this against my database, the 1st result was spot on, but the second result piggy backed on the first result and so on. 1st result = 04.10439 2nd result = 04.1043904010439 3rd result = 04.104390401043904010439 and so on until it reached a...
  12. klgoist

    Replacing consecutive zeros in a string with a period

    I have a string field that is 17 characters long. (example: 04000000000000039 or 04000000000010439). I would like to replace the zeros between the 4 and the next non zero character with a period. (Example: 04.39 or 04.10439) Is there a simple formula for doing this?

Part and Inventory Search

Back
Top