SSRS only displaying first row

sql-server-2008 reporting-services ssrs-2008
Blaze picture Blaze · Sep 9, 2011 · Viewed 19.4k times · Source

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?

Answer

Blaze picture Blaze · Sep 9, 2011

The tablix was missing a row group.

Related questions

SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
Using the IN operator to filter in reporting services

Can anyone advise what the syntax should be when using the IN operator within a table filter. I have tried the below but the snytax is wrong:

Read More
"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB …

Read More