You’re offline. This is a read only version of the page.
Hello,
Trying to print a field.
Eg. CUST PO # 123456456568977. I only need to print PO # 123456456568977
Is this possible in Report Writer?
Any help is appreciated
Thank you! It worked!
Yes, but you need to create 2 calculated fields to complete the task.
Functions don't liked to be nested in Report Writer.
We need to utilize the User-Defined Functions (System) to accomplish this...
#1 Calculated Field (POLen) - Defined the # chars from the right we want to have
Result Type = Integer
Calculation = FUNCTION_SCRIPT( RW_Length POP_PO.PONumber) - 5
POP_PO.PONumber = Is the PO Number Field from the table you need
5 = Is the trim left length
#2 Calculated Field (TrimedPONumber) - Is the timed String of the PO#
Result Type = String
Calculation = FUNCTION_SCRIPT( RW_Right POP_PO.PONumber POLen)
POP_PO.PONumber = Is the PO Number Field from the table you need
POLen = Is the right string length
I hope this helps...
User-Defined Functions are great, but not well documented.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,522
Super User 2024 Season 2
#2
Martin Dráb
228,441
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (