Working link to Crystal output screenshot: http://imageshack.us/a/img17/6826/rgpage.jpg
I am trying to develop a BAQ and Crystal report that will display all of the parts that our company has categorized as purchased items, along with the items list of vendors, current price, and known future price changes. I think that I am 90% of the way there, but am having a few minor issues.
----------------------------
Here is the BAQ:
for each Vendor no-lock , each VendPart where ( ( VendPart.EffectiveDate <= TODAY + 0 AND ( VendPart.ExpirationDate is null OR VendPart.ExpirationDate >= TODAY + 0)) OR ( VendPart.EffectiveDate >= TODAY + 0)) and (Vendor.Company = VendPart.Company and Vendor.VendorNum = VendPart.VendorNum) no-lock , each Part where ( Part.TypeCode = 'p') and (VendPart.Company = Part.Company and VendPart.PartNum = Part.PartNum) no-lock by Part.ProdCode by VendPart.PartNum by Vendor.VendorID by VendPart.EffectiveDate.
----------------------------
The problem is that the way the BAQ is phrased causes the current price and proposed price to be placed on separate lines, which is causing issues in Crystal.
I was hoping to have the current price and the proposed price display on the same line and then be able to input a formula that calculates the percentage of the price change.
Here is a screencap of the way that I currently have the Crystal report formatted: http://imageshack.us/a/img17/6826/rgpage.jpg.
Since I wasn't able to get the current price and proposed price on the same line, I wasn't able to make Crystal calculate the percent of change, so I just made an "ALERT" message to indicate that there is a known price change coming.
Ideas?
Thanks,
Jay
----------------------------
Here is the BAQ:
for each Vendor no-lock , each VendPart where ( ( VendPart.EffectiveDate <= TODAY + 0 AND ( VendPart.ExpirationDate is null OR VendPart.ExpirationDate >= TODAY + 0)) OR ( VendPart.EffectiveDate >= TODAY + 0)) and (Vendor.Company = VendPart.Company and Vendor.VendorNum = VendPart.VendorNum) no-lock , each Part where ( Part.TypeCode = 'p') and (VendPart.Company = Part.Company and VendPart.PartNum = Part.PartNum) no-lock by Part.ProdCode by VendPart.PartNum by Vendor.VendorID by VendPart.EffectiveDate.
----------------------------
The problem is that the way the BAQ is phrased causes the current price and proposed price to be placed on separate lines, which is causing issues in Crystal.
I was hoping to have the current price and the proposed price display on the same line and then be able to input a formula that calculates the percentage of the price change.
Here is a screencap of the way that I currently have the Crystal report formatted: http://imageshack.us/a/img17/6826/rgpage.jpg.
Since I wasn't able to get the current price and proposed price on the same line, I wasn't able to make Crystal calculate the percent of change, so I just made an "ALERT" message to indicate that there is a known price change coming.
Ideas?
Thanks,
Jay