I have a data field(text) which doesn't appear as what I see in preview. How
can I display the text with paragraphs?
I see squares between words from data I retrieved. I guess that is the
something indicates new line or new paragraph. In preview, the text is
properly displayed in different lines/paragraphs. But when I built ad
deployed it, the text becomes cramp into one paragraph. This reduce the
readability.
Appreciate if someone could give me an idea on where to set the format or
cast the data field. Thank you.Still couldn't solve my problem. Anyone can help?
More elaboration on this problem: -
When I preview I see the data field display nicely like below (eg.):
Stamp[xxx]
Subject: Server not up after rebooting
Assigned to mho3.
This has moderate impact to customer site.
--Then, after I deployed it, I browse it via IE and unfortunately I couldn't
get what I see in Preview. It gives me result like this:
Stamp[xxx] Subject: Server not up after rebooting Assigned to mho3. This has
moderate impact to customer site.
--Just imagine some have long data. It will be difficult to read.
Any help is highly appreciated. Thanks!
"sammy" wrote:
> I have a data field(text) which doesn't appear as what I see in preview. How
> can I display the text with paragraphs?
> I see squares between words from data I retrieved. I guess that is the
> something indicates new line or new paragraph. In preview, the text is
> properly displayed in different lines/paragraphs. But when I built ad
> deployed it, the text becomes cramp into one paragraph. This reduce the
> readability.
> Appreciate if someone could give me an idea on where to set the format or
> cast the data field. Thank you.
>|||Where do you get the data from? Is the new line formating something you get
by modifying fields from different columns in the database, or is it one
field that has some format in one column in your database?
Hilary Cotter suggested in a different thread that you use char(10) +
char(13) in your SQL select to get the line breaks and new lines directly
from the database. Like this:
SELECT @.a = '123' +char(10)+char(13)+ 'xyz'
I don't know why it works in preview but not on the server, though. Guess
it's the rendering format that is different. What happens when you export to
pdf on your server? Does it go all on one line or does the lines break?
Kaisa M. Lindahl Lervik
"sammy" <sammy@.discussions.microsoft.com> wrote in message
news:7D920AFA-1350-44A0-ABA9-1AA9CD71D65E@.microsoft.com...
> Still couldn't solve my problem. Anyone can help?
> More elaboration on this problem: -
> When I preview I see the data field display nicely like below (eg.):
> Stamp[xxx]
> Subject: Server not up after rebooting
> Assigned to mho3.
> This has moderate impact to customer site.
> --Then, after I deployed it, I browse it via IE and unfortunately I
> couldn't
> get what I see in Preview. It gives me result like this:
> Stamp[xxx] Subject: Server not up after rebooting Assigned to mho3. This
> has
> moderate impact to customer site.
> --Just imagine some have long data. It will be difficult to read.
> Any help is highly appreciated. Thanks!
>
>
> "sammy" wrote:
>> I have a data field(text) which doesn't appear as what I see in preview.
>> How
>> can I display the text with paragraphs?
>> I see squares between words from data I retrieved. I guess that is the
>> something indicates new line or new paragraph. In preview, the text is
>> properly displayed in different lines/paragraphs. But when I built ad
>> deployed it, the text becomes cramp into one paragraph. This reduce the
>> readability.
>> Appreciate if someone could give me an idea on where to set the format or
>> cast the data field. Thank you.|||Teng! Teng! Teng! The answer is:
=Replace(Fields!Activity_Log.Value,CHR(10),vbCrLf)
I found that those special character "squares" is represented by CHR(10) -
Line feed, from my try and error.
And in VB.NET, vbCrLf indicates new line as in "\n" for C.
Kaisa,
I got my data in a single field (not combining multiple fields), and that
field type is Text. I cast it to string so I found "squares" between words.
Before I applied the Replace function, I tried to export my report to PDF and
other format, it's just the same, no break lines. After applying the Replace
function, it works fine.
Anyway, Thks a lot for your hints, Kaisa. :-)
best regards,
sammy
