Reporting services display only the last row

Question

I built the report pretty simple, just a table with 45 rows of data. The problem is only that it shows only one row of data and the last row. It displays very well in the dataset and proc. any suggestion?

The table is in the body of the report.

Answer 1

perhaps you put the fields in the title of the report,
create your first report using the report wizard and after changing it the way you want.

Answer 2

make sure the fields do not have first () or last () in them.

Answer 3

or you can just try to create a table in the details (not the header or footer) of your report and drag some fields from the data explorer to the table, after clicking on the preview tab, and you will see a table with some records, good luck

Answer 4

You can check if there are any filters associated with the dataset. Click the "Edit DataSet" button and open the "Filters" tab.