I’m being asked if I can represent Quantity Breaks on the Quote Form as a Range (not sure that’s the best descriptor). Instead of showing Qty 50 @ $100, Qty 100 @ $90, they would prefer it be represented as Qty’s 50-99 @ $100, Qty’s 100-199 @ $90, etc.
I’m pretty sure Kinetic can’t do this in the Quote module, so I’m looking at SSRS to accomplish this. Has anyone ever tried this and gotten it to work?
Thanks in advance.
After some Googling, I might have figured this out, but I’m having some record duplication in the Print Layout view in Report Builder.
The screen shot below is what it looks like in Report Builder without Print Layout selected. You can see it’s working correctly for Line 1 and Line 2 of the Quote.
This isn’t the final version of the code I want, but this is the expression I used in the textbox.
=FormatNumber(Fields!SellingQuantity.Value, First(Fields!DecimalsQuantity.Value, "RptParameter")) & " - " & FormatNumber(Lookup(Fields!QtyNum.Value +1,Fields!QtyNum.Value, Fields!SellingQuantity.Value -1, "Quote"),First(Fields!DecimalsQuantity.Value, "RptParameter"))
Once I click Print Layout, or just print to pdf, the data changes, duplicating info, as shown in the screen shot below for Line 1 only.
Here is Line 2 in Print Layout working as it should (ignore the matching Unit Prices, the Quote isn’t finished).
I’ve never seen data duplicate when switching to Print Layout mode, but this has me thinking that using LookUp() was not the way to approach this problem, however, why is this only happening on Line 1 and not the rest of the lines on the quote?