Line breaks in the output of the Comments column

Kinetic ERP
1

Hello everyone,

I’m very new to Epicor, but I’ve modified the SSRS Report with your help here in the community. My issue I encountered along the way was that the line breaks in the Comments I entered in Epicor did not appear in the output.
I changed the line with Enter key in Epicor as shown in the screenshot below, but the line did not change on output.
How do I fix this? Does the Report Builder handle this? Or is it done by Epicor? I would be very grateful if you could tell me how to fix this.
image

image
image760×107 8.74 KB

2

Please try below in SSRS Expression, change the column name from ‘Fields!Calc_LineDesc.Value’

=Replace(Fields!Calc_LineDesc.Value,Chr(13),Chr(10) +Chr(13))

2 Likes
3

Sorry to bother you.
Where is the SSRS Expression located?

4

image
image1135×365 17.8 KB

1 Like
5

After modifying SSRS Expression as you said, when uploading report, the following error message pops up. What’s the problem?

image
image1126×526 85.1 KB

6

You have to give the correct column name in the expression.

7

With your help, this issue is well resolved.
Thanks,

1 Like