How to show serial number line by line

Created by Eugene Lum, Modified on Wed, 2 Oct at 11:43 AM by Eugene Lum

Scenario:

User want to show serial number line by line, instead of continue by next serial number in the same line for purchase invoice

 

Solution:

1. Go to report designer, search for the purchase invoice format want to amend.


2. Expand Purchase Invoice and right click on Purchase Invoice Details Collection, click on Add calculation field

 

3. Right click on the calculatedField1 created just now, and click on edit expression


4. Paste below expression and click ok

Replace([Serial Number], ',', CHAR(13))

 

5. After that insert new field and replace with calculatedField1 

 

 

6. After that save the report design and preview.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article