Formatting text field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joejoe851@gmail.com - 03 Jun 2008 16:49 GMT

I've created a report in SRS that displays the contents of a text
field in a SQL Server database, but it doesn't hold any of the line
breaks. It comes as one big blob of a paragraph. When I open the
screen that displays the information in our ERP system, it is all
nicely formatted.

How can I somehow get the formatting to show in this SRS report? Do I
scan the data in the field for char(10) and char(13) and force a break
somehow? I am not sure how to go about doing this.

Any assistance is appreciated. Thanks in advance.

-Joe

Reply to this Message

joejoe851@gmail.com - 02 Jul 2008 20:57 GMT

In case anyone else wants to know what happened...I finally figured it
out.

This is the expression I had to use to get RS to format it properly:

=REPLACE(First(Fields!TXTFIELD.Value, "DataSource1"), CHR(13), vbcrlf)

-Joe

On Jun 3, 10:49 am, joejoe...@gmail.com wrote:

> I've created a report in SRS that displays the contents of a text
> field in a SQL Server database, but it doesn't hold any of the line
[quoted text clipped - 9 lines]
>
> -Joe

Reply to this Message