Maintaining field format in SSRS report

Epicor ERP 10
1

Hello All,

I have created a Bill of Material and am experiencing issues with maintaining what appear to be hard returns in the corresponding Epicor field. This is how the txt appears in Epicor:

Yet when I run my report, I get a mushed up version:

I dropped the Ops in excel to take a look and I see that there don’t appear to be any hard returns in my problem field.

I thought this might just be due to user entry, but SOMEHOW, our previous Crystal report is able to break the lines correctly:

I looked at the Crystal report, but was unable to see how it had accomplished this. Can anyone help me accomplish this same formatting in Report Builder/SSRS???

Thanks so much,

Alice

2

Alice,
Try this, in your SSRS report change the expression for the textbox or cell to something like this:
=Replace(Fields!YOURFIELD.Value,CHR(13),VbCrLf)
This will replace the DB stored line feeds to a SSRS understandable carriage return or line feed.

-Rick
www.getaligned.solutions

3

Thank you so much Rick! It worked perfectly. I have been puzzling this for a while-I should have asked sooner.