Word Wrap Wrapping (S) to The Next Line

Question

We had finished converting a lot of our reports from Crystal Reports to SSRS. Upon doing so, one report, the customer's invoice has comments in the report that contain (s) at then end of a word to indicate singular or plural. Crystal reports handled the wrap correctly and kept the word together including the (s), but in SSRS, the (s) is being wrapped to the next line, which doesn't look good at all.  I've looked and looked but have not found an answer.  Is there a fix to this or does Microsoft plan on fixing this issue? Thanks for any help. 

---

CEDeveloper

Answer 1

Hi CEDeveloper,

According to your description, the word which contains ‘s’ will wrap the ‘s’ to the next line in reporting services, right?

As we tested in our environment, we can’t reproduce the issue like yours. Sometimes, we might meet the wrap issue when the length of value is longer than the width of the textbox. In Reporting Services, since the width of the textbox is static, we should increase the width of the textbox to make the value can display on one line if possible. Please refer to similar thread: can grow property is not working in ssrs 2008 R2

In your scenario, if the issue persists, please share report design in reporting services and preview results for our analysis.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 2

Hello.  Sorry, the s is surrounded by parenthesis like this "(s)" and that is what reporting services is wrapping to the next line.  It is apparently treating the "(" as the start of another word.  Thanks.

---

CEDeveloper

Answer 3

Hi CEDeveloper,

According to your description, when the end of the word is "(S)", the "(S)" is wrapping to the second line, right?

As we tested in our environment, the word like "report(s)" can display on one line and "(s)" won’t wrap to next line if there is no line break in the string. In your scenario, please check if you have inserted the line break behind the "(s)". Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 4

The data is being pulled from an SQL Server 2014 database via a stored procedure. I used the replace function in the stored procedure to remove all char(10) and char(13) occurrences and the report is still acting the same way. I created a test stored procedure using the code below:

CREATE PROCEDURE Rep_Comments_Test

AS

	select comments = 'TESTING THE CODE REALLY GOOD TO MAKE SURE THERE IS NO ERROR(S)'

I created the data source and added this procedure as the dataset for the report.  Dragging the field onto the report and adjusting the text box to where the end of the box ends slightly past error causes the "(s)" to wrap shown in the image below.

Any help would be greatly appreciated.  Thanks.

---

CEDeveloper

Answer 5

It even does the same thing filling the text into a text box via an expression.

---

CEDeveloper

Answer 6

Hi CEDeveloper,,

According to the screenshots, it seems that the length of the textbox is sufficient to contains the string in one line. Since the textbox width couldn’t increase automatically based on its content, you could increase the textbox width manually to a proper value which can make the string display on one line.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 7

That would work in this one situation, but I can't do this for every single instance this may occur.  We display almost 60,000 comments like these per year for customer reporting.  I need reporting services to wrap correctly, as it is not doing that correctly now.  Is there no course of action to get a fix for this?

---

CEDeveloper

Answer 8

Hi CEDeveloper,

In Reporting Services, the textbox width can't be expanded dynamically based on the length of the content then to make the value display on one line. Besides, there is no property to specify dynamic width. So for your requirement, it can't be achieved currently.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support