Finance forum

How to remove new line using replace function in SSRS

(0) Share

Report

Posted on by Mav

The temp db table DP class has line like this

mytmptable.CompanyAddress= strReplace(mytmptable.CompanyAddress, "\n", "\n\n");

So the report is having spacing due to above command.

How to reverse that logic using SSRS Replace function i tried the following but it did not help.

Replace(First(Fields!CompanyAddress.Value,"mytmptable"),Chr(10),", ")

Categories:

Development / Customization / SDK

All responses (10)

Answers (0)

Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Are you sure you can't handle it in the dataset using extensions? You could hook in the insert method of the temp table and remove newlines from this field. Right? Of course I haven't seen the ISV code, but perhaps you can share it if my suggestion is not feasible.
Blue Wang on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Hi Mav,

Then.

Have you ever tried Regex?

There may be more than one. Replacement cannot simply implement it.

https://www.experts-exchange.com/questions/23593454/SSRS-removes-spaces-and-line-breaks-from-single-field-report.html

https://stackoverflow.com/questions/40613205/remove-blank-lines-from-string-ssrs
Mav on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

No its not in dataset it is a ISV report so the DP in ISV model has a line of code where it is replacing "/n" with "/n/n"

The ISV DP for this report is not extensible as I wasnt able to undo the above line of code using the COC.

Hence trying to do via SSRS. Only if in SSRS there could be a way to find "chr(10)chr(10)" & replace with "chr(10)"
Blue Wang on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Hi Mav,

Does your CompanyAddress field have a newline character in itself?

Why don't you try to remove it from the data set?
Mav on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Any one any solution for this.

How to find "chr(10)chr(10)" & replace with "chr(10)" in SSRS
Mav on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Already tried that it is the 1st internet search for replacing new line , it does not work in my case.

What is required to fix this is how to find "\n\n" or "Chr(10) Chr(10)" in a string & replace with single Chr(10) in SSRS.
Mav on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Already tried that it is the 1st internet search for replacing new line , it does not work in my case.

What is required to fix this is how to find "\n\n" or "Chr(10) Chr(10)" in a string & replace with single Chr(10) in SSRS.
Satish Panwar 14,653 Moderator on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

Take a look at link below

stoneridgesoftware.com/.../

They seems to have issues in first place and are using code what you have above.. and then there is alternate trick. See if this helps.
Mav on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

I cant reverse it & hence I am asking a question about how to reverse it using SSRS replace .
Satish Panwar 14,653 Moderator on at

Like (0)

Report

RE: How to remove new line using replace function in SSRS

If you can reverse it... can't you comment that "\n\n" in first place