question

Marli avatar image
Marli asked

encoded newline character"
"

I am using SQL 2008 R2 Report Writer 3.0 I wrote a report however the output displays erroneous symbols " " I attempted to correct the issue by using =replace(Fields!Task_Notes.Value, " ",chr(13)) and setting HTML to interpret HTML tags as styles What happened to my report was the the rows of data that contained the " " was eliminated from the report entirely. Any suggestions would be greatly appreciated. I am fairly new at this Thank you in advance
htmlreport-builder3tags
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

veliz.jaime avatar image veliz.jaime commented ·
I would like to see the select statement, and the database table script or structure with the type of the column you use to your report. Regards.
1 Like 1 ·
veliz.jaime avatar image veliz.jaime commented ·
can you send the select and the table structure / script.???
0 Likes 0 ·
Marli avatar image Marli commented ·
Jaime [link text][1]See attached [1]: /storage/temp/1861-erroneous+symbols.pdf
0 Likes 0 ·

1 Answer

·
Fatherjack avatar image
Fatherjack answered
have you tried using HTML line break or paragraph tags rather than ascii? [br /] is a line break - a self closing tag so you can place one or many of these in text to cause new lines. [p] your paragraph of text here [/p] - to create a paragraph of text wrap it in

tags. You need one to open and one to close. NOTE: I have had to use [ and ] above but in HTML you need to use however in the forum the HTML tags get interpreted as actual line breaks and format the answer. Please use in your solution.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.