SSRS only displaying first row

13
votes

I have a very basic report in SSRS that displays a grid of data. The query correctly returns multiple rows but the report only displays the first row. The query is as simple as SELECT * FROM... I dont have any special formatting and the tablix is in the details part of the report, not header or footer by accident. What else can I check?

2
sql-server-2008reporting-servicesssrs-2008
Check to make sure they aren't duplicate rows and you have the suppress feature checked. – Matt M
They are non-duplicate rows. I can change the ORDER BY and get the first row of the reversed query, so I know the query is "working". Where do I find the suppress feature? – Blaze

2 Answers

15
votes

The tablix was missing a row group.

0
votes

A similar issue is driving me nuts. I created a report manually from scratch in VS2012, threw a tablix on it and added the columns returned by a simple select. The report preview returns only the first group by primary key. Then I created a similar report using a wizard and that report, although having only cosmetic differences, returns all groups by primary key.