Print Page | Close Window

product upc Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Tips and Tricks Forum Discription: Have you learned some great tricks to share with the group? Post them here! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20969 Printed Date: 28 Apr 2024 at 7:50pm Topic: product upc Posted By: vibol Subject: product upc Date Posted: 12 Aug 2014 at 7:49am I have an invoice form which shows a product unit of measure ie. Case, or EA I'd like the report to pick up the UPC code for EA when the unit of measure is a Case. tables are:  Product, ProductUM, ProductUPC Please help. Replies: Posted By: vibol Date Posted: 12 Aug 2014 at 9:34am I think I got it....but do share if you have a better solution EA => if {um} = "EA" then  {upc} CS => if {um} = "CS" then maximum ({@EA}, Prd) else {upc}

Print Page | Close Window