Search results for query: *

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

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

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.

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

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

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.

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

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.

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

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

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

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?