data report

[engnouna]

Hi
I have a listbox that loads its item from an SQL server table

rs.open"Select * from Person",cnn,adopenStatic,adLockOptimistic
Rs.moveFirst
Do while not rs.EOF
sname=rs!PersonName
list1.AddItem sname
DataReport1.Label1.Caption = sname
rs.movenext
loop
rs.close

I have a Datareport and for each sname(for each rs!PersonName) i want to add it to my report into a label(RptLabel)

Can anyone guide me?
Thanks

[BestS]

What is wrong with the textboxes
put one and you'll get all name listed, it looks just like label...