Result set in SSRS

• m--S3qU3L

  Hall of Fame

  Points: 3706

  More actions

  February 6, 2011 at 4:11 am

  #234575

  Hi,

  I have created a simple report to display the status of databases. But when I try to view the result in preview, its only showing one row, though the query in DS produces 10 rows.

  Any ideas friends?

  Thanks

  John

• m--S3qU3L

  Hall of Fame

  Points: 3706

  More actions

  February 6, 2011 at 4:19 am

  #1282853

  All OK now.

  I was using textbox instead of table or matrix in the report layout.

  Corrected now and its giving me multiple rows in the result.

  Thanks

  John