Skip to main content
Solved

TRIMMING A FIELD IN REPORT DESIGNER (FORMULA ?)

  • 27 September 2023
  • 2 replies
  • 251 views

Hi there, 

Is there a “Format” or “Formula” to trim a field in report designer. 
ie. I want to turn C-16600-O into just 16600. I do not want to physically change the naming convention inside Acumatica, i simply just want to trim the field in the report designer.
 

Your help would be highly appreciated. 

Thank you

Best answer by dcomerford

On the field on the form if you click on the 3 dots to the right hand side of the value you can open the expression editor so you have access to all the edits and under Text you will see the text applicable ones.

A couple of ways of doing it using LTrim etc but substring is easiest so in case below for customer order number print from the 3th position and print next 5 characters.

=Substring([SOOrder.CustomerOrderNbr],3,5)

View original
Did this topic help you find an answer to your question?

2 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 584 replies
  • Answer
  • September 27, 2023

On the field on the form if you click on the 3 dots to the right hand side of the value you can open the expression editor so you have access to all the edits and under Text you will see the text applicable ones.

A couple of ways of doing it using LTrim etc but substring is easiest so in case below for customer order number print from the 3th position and print next 5 characters.

=Substring([SOOrder.CustomerOrderNbr],3,5)


  • Author
  • Freshman I
  • 4 replies
  • September 27, 2023

@dcomerford thank you very much for the response, the substring works perfectly 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings