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

VB Code:
  1. rs.open"Select * from Person",cnn,adopenStatic,adLockOptimistic

  2. Rs.moveFirst

  3. Do while not rs.EOF

  4. sname=rs!PersonName

  5. list1.AddItem sname

  6. DataReport1.Label1.Caption = sname

  7. rs.movenext

  8. loop

  9. 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