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?
SSRS only displaying first row
reporting-servicessql-server-2008ssrs-2008
Best Answer
The tablix was missing a row group.