Reporting Service HTML Tag Interpretaion

Hi,
I've developed report in Reporting Service.
I've data return by SQL server includes HTML tags.
i.e
Enonche Ameh<br>7600 Leesburg Pike<br>Falls Church, VA 22043
But it displayes the data in the report as it without line break and in the
same line as a single sentence. It doesn't interpret
line break.
It should display
Enonche Ameh
7600 Leesburg Pike
Falls Church, VA 22043
What would be the reason ?
Thanks
Malkesh
--
Message posted via http://www.sqlmonster.comI am not sure if you are output-ing your report to HTML or viewing report
with reporting services 'home'. But when I want to put a line break in a
report I use "vblf" since it looks to me like report output is more VBscript
than HTML
e.g. - this outputs name then address on next line
=Trim(Fields!cust_name.Value) & vbLf & Trim(Fields!cust_address.Value) & "
" & Trim(Fields!cust_cityzip.Value)
"Malkesh Sheth via SQLMonster.com" wrote:
> Hi,
> I've developed report in Reporting Service.
> I've data return by SQL server includes HTML tags.
> i.e
> Enonche Ameh<br>7600 Leesburg Pike<br>Falls Church, VA 22043
> But it displayes the data in the report as it without line break and in the
> same line as a single sentence. It doesn't interpret
> line break.
> It should display
> Enonche Ameh
> 7600 Leesburg Pike
> Falls Church, VA 22043
> What would be the reason ?
> Thanks
> Malkesh
> --
> Message posted via http://www.sqlmonster.com
>|||Thnaks GW,
What i want is that my data stored is in HTML format,
that include HTML formating tags like <br> etc..
When i bound it with Text box , rather display it as
formatted text it simpley displays the text as it is with
tags.
I come to know that RS doesn't support HTML or RTF
format directly.One have to used VB.Net and create custom
code for it.
Is there any function or code anyone have that can directly convert
HTML To text ?
--
Thanks & Regards
Malkesh
"GW" wrote:
> I am not sure if you are output-ing your report to HTML or viewing report
> with reporting services 'home'. But when I want to put a line break in a
> report I use "vblf" since it looks to me like report output is more VBscript
> than HTML
> e.g. - this outputs name then address on next line
> =Trim(Fields!cust_name.Value) & vbLf & Trim(Fields!cust_address.Value) & "
> " & Trim(Fields!cust_cityzip.Value)
> "Malkesh Sheth via SQLMonster.com" wrote:
> > Hi,
> > I've developed report in Reporting Service.
> > I've data return by SQL server includes HTML tags.
> > i.e
> > Enonche Ameh<br>7600 Leesburg Pike<br>Falls Church, VA 22043
> > But it displayes the data in the report as it without line break and in the
> > same line as a single sentence. It doesn't interpret
> > line break.
> > It should display
> >
> > Enonche Ameh
> > 7600 Leesburg Pike
> > Falls Church, VA 22043
> >
> > What would be the reason ?
> > Thanks
> > Malkesh
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||No, this is not currently supported in RS. It is on the list for the post
SQL 2005 release.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Malkesh" <Malkesh@.discussions.microsoft.com> wrote in message
news:217259B9-0969-4989-B69F-45F8C6DFE251@.microsoft.com...
> Thnaks GW,
> What i want is that my data stored is in HTML format,
> that include HTML formating tags like <br> etc..
> When i bound it with Text box , rather display it as
> formatted text it simpley displays the text as it is with
> tags.
> I come to know that RS doesn't support HTML or RTF
> format directly.One have to used VB.Net and create custom
> code for it.
> Is there any function or code anyone have that can directly convert
> HTML To text ?
> --
> Thanks & Regards
> Malkesh
>
> "GW" wrote:
>> I am not sure if you are output-ing your report to HTML or viewing report
>> with reporting services 'home'. But when I want to put a line break in a
>> report I use "vblf" since it looks to me like report output is more
>> VBscript
>> than HTML
>> e.g. - this outputs name then address on next line
>> =Trim(Fields!cust_name.Value) & vbLf & Trim(Fields!cust_address.Value) &
>> "
>> " & Trim(Fields!cust_cityzip.Value)
>> "Malkesh Sheth via SQLMonster.com" wrote:
>> > Hi,
>> > I've developed report in Reporting Service.
>> > I've data return by SQL server includes HTML tags.
>> > i.e
>> > Enonche Ameh<br>7600 Leesburg Pike<br>Falls Church, VA 22043
>> > But it displayes the data in the report as it without line break and in
>> > the
>> > same line as a single sentence. It doesn't interpret
>> > line break.
>> > It should display
>> >
>> > Enonche Ameh
>> > 7600 Leesburg Pike
>> > Falls Church, VA 22043
>> >
>> > What would be the reason ?
>> > Thanks
>> > Malkesh
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>> >|||Thanks,
But how to parse HTML using VB.Net ?
Is there any fucntion in VB.Net ?
Reference to any site will also
help me to find out the solution.
Thanks
--
Message posted via http://www.sqlmonster.com|||If you want rich text (bold, underline, particular fonts,etc) that is coming
out of the database you are out of luck. RS does not support this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Malkesh Sheth via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:80e1fc57f268409e93d33f3230d4f093@.SQLMonster.com...
> Thanks,
> But how to parse HTML using VB.Net ?
> Is there any fucntion in VB.Net ?
> Reference to any site will also
> help me to find out the solution.
> Thanks
> --
> Message posted via http://www.sqlmonster.com|||We don't natively support this but this could be done with a custom
renderer.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23DpMJm9TFHA.3280@.TK2MSFTNGP09.phx.gbl...
> If you want rich text (bold, underline, particular fonts,etc) that is
> coming out of the database you are out of luck. RS does not support this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Malkesh Sheth via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:80e1fc57f268409e93d33f3230d4f093@.SQLMonster.com...
>> Thanks,
>> But how to parse HTML using VB.Net ?
>> Is there any fucntion in VB.Net ?
>> Reference to any site will also
>> help me to find out the solution.
>> Thanks
>> --
>> Message posted via http://www.sqlmonster.com
>