On my application I have batch reports. On Each batch the Kg of each item added to the batch is recorded. I wrote a report that sums all the batch records by the LOT number of each item. What I would like to do is to display both in Kg and in Pounds. The batch reports are entered in in Kg, the receiving is recorded in LBS. I would like to display both on my report so when it sums up the number of Kg used in a specific lot # I would like the report to also display that value as Pounds.
I know the math, I just don't know how to access the SUM field on the report to do the calculations needed to display Pounds and Ounces. along with the Kilograms
Is there a way on a Report to get the SUM total to calculate the Pounds/Ounces?
Thanks
Andy