Crystal Reports product upc

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: product upc

Author	Message
vibol Newbie Joined: 12 Aug 2014 Location: United States Online Status: Offline Posts: 2	Topic: product upc 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. Edited by vibol - 12 Aug 2014 at 7:53am
	IP Logged

vibol Newbie Joined: 12 Aug 2014 Location: United States Online Status: Offline Posts: 2	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}
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.017 seconds.