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...
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 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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.