locked
Html Tag In RDLC report. RRS feed

  • Question

  • User-1561841327 posted

    Dear all.,

    I have a string like " Select option<br />
    <ul>
    <li>1</li>
    <li>2</li>
    <li>3<br />
    </li></ul>" I need to Show the Bullets in the RDLC report may i know how to achieve this task.

    Monday, December 12, 2011 2:12 PM

All replies

  • User-1528094326 posted

    The ReportViewer will not render that HTML markup as far as I know. I googled for an answer and it looks like the most common work around is to use WingDings font and put in a bullet that way.

    Monday, December 12, 2011 2:23 PM
  • User-1561841327 posted

    Really thank you for your reply., May i know one more thing how i do that in SQL.

    Friday, December 16, 2011 3:03 PM
  • User-1051986203 posted

    In report also you can show bullets, highlight the text box:->go to properties windows:->

    there is one property called "Lists" have two sub properties:-

    1.ListLevel

    2.ListStyle 

    In list level values can be 1,2 & in liststyle value can be Numbered,bulleted.

    you can set these 2 properties to give a bullet in reports as per requirements.

    if you want to give sequence number in reports for each row, so you can do this using RowNumber() function.

    right click on textbox:->expression:->put the expression:-> =RowNumber("DataSet1")

    the function require data set name,expression is =RowNumber("DataSetName")

    and in sql you can use row_number() function to generate sequence number.

    select ROW_NUMBER() over (order by no) as Sno,* from employees

    Tuesday, December 20, 2011 12:45 AM
  • User-1561841327 posted

    Dear All.,

    I have database value like  1,2,3,4,5 for Question ID 1 and 1,2,3,4 for Question ID 2.

    While load in the RDLC report I need to show like follows.

    1        1

              2

              3

             4

             5

    2       1

             2

             3

             4

    Tuesday, December 20, 2011 9:39 AM
  • User-1051986203 posted
    Do this way if you have table structure like this:-
    create table reportssrs(quesID varchar(20),value int)
    insert into reportssrs values('question id 1',1),('question id 1',2)
    ,('question id 1',3),('question id 1',4),('question id 1',5)
    ,('question id 2',1),('question id 2',2)
    ,('question id 2',3),('question id 2',4)
    select * from reportssrs
    quesID	      value
    question id 1 1
    question id 1 2
    question id 1 3
    question id 1 4
    question id 1 5
    question id 2 1
    question id 2 2
    question id 2 3
    question id 2 4
    
    
    while showing in report use this query:-
    select Sno,value from(
    select dense_rank() over (order by quesID ) as Sno,* from reportssrs
    ) h1
    Sno	value
    1 1
    1 2
    1 3
    1 4
    1 5
    2 1
    2 2
    2 3
    2 4
    make Sno to row group in reports then you will find same format in report as you mentioned in post like this:-

    1        1

              2

              3

             4

             5

    2       1

             2

             3

             4

    Tuesday, December 20, 2011 10:36 AM