sql reporting not able to output exactly user key in

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard - 02 Jul 2008 01:41 GMT

We create a table in sql reporting and drag the field into the detail row.
User key into the system :
Hello world 1;
Hello world 2;
Hello world 3:

but the table output the line as "Hello world 1; Hello world 2; Hello world
3;"
What properties i need to set on the field so the report will able to show
exactly user has keyed in?

Reply to this Message

TheRealRobbie - 02 Jul 2008 10:27 GMT

If the database data contains the carriage return, you can do this:

=First(Fields!string.Value).Replace("\r",VbCrLf)

(found in a previous post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2235413&SiteID=1)

> We create a table in sql reporting and drag the field into the detail row.
> User key into the system :
[quoted text clipped - 7 lines]
> exactly user has keyed in?
>

Reply to this Message

richard - 02 Jul 2008 16:50 GMT

I have tried out First(Fields!string.Value).Replace("\r",VbCrLf). But it
won't work.
However, this give an idea to archieve what i want.

This is what i wrote in the expression of the column
Replace(Fields!ITEMDESC.Value, CHR(13),VbCrLf)

so finally it able the show what exactly user key in.
Anyway, Thanks TheRealRobbie

> If the database data contains the carriage return, you can do this:
>
[quoted text clipped - 16 lines]
>> show
>> exactly user has keyed in?

Reply to this Message

Jim M. - 03 Jul 2008 21:05 GMT

First(Fields!string.Value).Replace(CHR(13),VbCrLf) worked for me. thanks for
posting your solution!

> I have tried out First(Fields!string.Value).Replace("\r",VbCrLf). But it
> won't work.
[quoted text clipped - 26 lines]
> >> show
> >> exactly user has keyed in?

Reply to this Message