SSRS - LineDesc Issues SubCPack

Epicor ERP 10
1

Apparently some of our part descriptions have carriage returns, while others have line returns. On a subcontractor ship pack slip I have two parts, one with carriage returns, the other with line returns. The default Epicor report displays it this way:

Part 1 desc:

This part has the following features: -2 side wings -1 upper arm
-2 lower tensions -4 bore holes

Part 2 desc:

This part has the following features
-3 side wings
-2 upper arms
-2 lower tensions
-5 bore holes

(we want both to display like part 2)

To fix part 1, the following code was added by the uplift team:
=REPLACE(REPLACE(Cstr(Fields!LineDesc.Value),CHR(13),"!*"),"!*",vbcrlf)

This made part 1 display properly, but now part 2 has an extra space between each line like:

This part has the following features

-3 side wings

-2 upper arms

-2 lower tensions

-5 bore holes

I’ve tried so many combinations of replace, but I cannot get this to work. Some examples that I’ve tried are:
=REPLACE(REPLACE(Cstr(REPLACE(Cstr(Fields!LineDesc.Value),CHR(13),"!*")),CHR(10),"!*"),"!*",vbcrlf)
=REPLACE(REPLACE(Cstr(REPLACE(Cstr(Fields!LineDesc.Value),CHR(10),"!*")),CHR(13),"!*"),"!*",vbcrlf)
=REPLACE(REPLACE(Cstr(Fields!LineDesc.Value),CHR(13),vbcrlf),CHR(10),vbcrlf)

Any ideas?!?

2

AHHHH! Finally got it!

=REPLACE(REPLACE(REPLACE(Fields!LineDesc.Value, CHR(13), vbcrlf), CHR(10),vbcrlf),vbcrlf+vbcrlf,vbcrlf)

3 Likes
3

Thank you @Adam, I thought I was going to have to spend hours on this problem. Your code works perfectly!