Last post Dec 20, 2011 10:36 AM by jeeveshfuloria08
Dec 12, 2011 02:12 PM|thilakmsc|LINK
I have a string like " Select option<br />
</li></ul>" I need to Show the Bullets in the RDLC report may i know how to achieve this task.
Dec 12, 2011 02:23 PM|N_EvilScott|LINK
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.
Dec 16, 2011 03:03 PM|thilakmsc|LINK
Really thank you for your reply., May i know one more thing how i do that in SQL.
Dec 20, 2011 12:45 AM|jeeveshfuloria08|LINK
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:-
In list level values can be 1,2 & in liststyle value can be
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
Dec 20, 2011 09:39 AM|thilakmsc|LINK
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.
Dec 20, 2011 10:36 AM|jeeveshfuloria08|LINK
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 valuequestion id 1 1question id 1 2question id 1 3question id 1 4question id 1 5question id 2 1question id 2 2question id 2 3question 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 value1 11 21 31 41 52 12 22 32 4
make Sno to row group in reports then you will find same format in report as you mentioned in post like this:-