Post reply

HTML in SSRS

  • March 10, 2014 at 5:47 am

    #305178

    Hi,

    Can anyone help me in getting the output in SSRS for HTML input.

    In Textbox i have below code

    <html><body> <table> <tr><td>Name:</td><td>Guest</td></tr><tr><td>Empcode:</td><td>101010</td></tr></table></body></html>

    And after selecting HTML-InterpretHTML tags as styles

    I get the output as Name: GuestEmpcode: 101010

    But i need output as below

    Name: Guest

    Empcode: 101010

    I am aware that SSRS supports only Hyperlinks: <A HREF>

    Fonts: <FONT>

    Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>, <DIV>, <LI>, <HN>

    Text format: <B>, <I>, <U>, <S>

    List handling: <OL>, <UL>, <LI>

    But is ther any other option to display HTML table using SSRS Reports??/

    Thanks in advance,

    JB

  • March 10, 2014 at 5:54 am

    #1695492

    Using text boxes, I'm afraid you are stuck with the limitations of SSRS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 10, 2014 at 5:55 am

    #1695493

    Koen,

    Let me know even if there is any other option to display the HTML data without using textbox in Report Builder

    Thanks,

    JB

  • March 10, 2014 at 5:58 am

    #1695494

    Is there a particular reason why it has to be a HTML table?

    SSRS can generate regular tables just fine 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 10, 2014 at 6:00 am

    #1695495

    The actual problem here is , i will be getting input in HTML format which contains normal text and Table datas. And i want to display the same in SSRS /Report Builder.

    Thanks,

    JB

  • March 10, 2014 at 6:05 am

    #1695496

    OK. Why does it have to be SSRS?

    If you already have the HTML, you can just show the HTML.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 10, 2014 at 6:09 am

    #1695498

    lhave to show in SSRS only.

  • March 10, 2014 at 6:12 am

    #1695499

    You can parse the HTML file, extract the data and show that in SSRS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 10, 2014 at 6:35 am

    #1695502

    How to do it. Can you please reply with step by step procedure for parsing HTML

    THanks,

    JB

  • March 10, 2014 at 7:04 am

    #1695504

    I haven't done it myself.

    It is basically sort of XML, so I'm sure there are plenty of parsers available on the net.

    C# has classed dedicated to parsing XML.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply