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

I have the same question (0)

All responses (10)

Answers (0)

Satish Panwar 14,671 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

I cant reverse it & hence I am asking a question about how to reverse it using SSRS replace .

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

Any one any solution for this.

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

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Mav,

Does your CompanyAddress field have a newline character in itself?

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

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

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)"

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No