SSRS only displaying first row?

Up vote 1 down vote favorite share g+ share fb share tw.

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 don't 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? Sql-server-2008 reporting-services ssrs-2008 link|improve this question asked Sep 9 '11 at 15:00Blaze1081414 100% accept rate.

Check to make sure they aren't duplicate rows and you have the suppress feature checked. – mpminnich Sep 9 '11 at 15:05 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 Sep 9 '11 at 15:15.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.