Reporting services only displaying the last row.

Question

I have built a report pretty basic just a table wiht 45 rows of data. Problem is its only showing one row of data and its the last row. It displays just fine in the dataset and proc. any suggestiosn?

The table is in the body of the report.

Answer 1

probably you have put the fields in the header of the report
build your first report with the report creation wizard and after change it the way you want it

Answer 2

or you can just try create a table in the detail part (not header nor footer) of your report and drag some fields from the datasource explorer into the table, after click the preview tab and you will some a table with some records. good luck

Answer 3

make sure the fields don't have first() or last() in them.