Looking for a way to decrease the length of the SOShipLine.InventoryID_description field on a pick list. Currently prints the entire value (up to 250 characters but only want it to print the first 50 characters. Have “Can Grow” set to False.
Truncate field length - Report Designer
+18
Hello
Please try using the LEFT function. =LEFT( [SOShipLine.InventoryID_description],50)
Thank you...worked perfectly once I figured out where to insert it in the existing formula.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.