CODEWITHSUNDEEP
sql-serverreporting-services
Jeff
Jeff

Reputation: 77

Reporting services only displaying the last row

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.

Upvotes: 1

Views: 3253

Answers (5)

Todayboy
Todayboy

Reputation: 355

What I did is insert a new table; this time, don't delete the header (I found out I deleted it before), and then create the table again.

(Restarting can always help fix something in IT... hilarious...ha ha)

Upvotes: 0

live-love
live-love

Reputation: 52366

You could check if there are any filters associated with the dataset. Click on the Edit DataSet button and check the Filters tab.

Upvotes: 0

DForck42
DForck42

Reputation: 20347

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

Upvotes: 2

Omu
Omu

Reputation: 71198

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

Upvotes: 1

Omu
Omu

Reputation: 71198

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

Upvotes: 1

Related Questions