SSRS Tablix only displaying one record

I have a SSRS report which was working well but is now only displaying one record.

It was grouping by status type and displaying some totals for each type.  Now it only displays the first records and while that data appears correct I need the rest.

There are a number of columns which have been formatted and parameters set on the report which is why I don't create a new one.

Here is a shot of the report in design:

And here is a snip of some of the totalled columns:

Who is Participating?
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
In Design View eyeballeth the grey box to the left of your detail row.
If it does not show three lines in it, then the problem is that the detail row was deleted, and it's only showing a header/footer row, which displays as a single row.

To fix, you'll have to add it back.
canuckconsultingAuthor Commented:

I did only have two rows but still only showing one record as below:

And here's what the advanced row/col looks like>

Row/col settings
I also manually had to add Detail_Collection to the DataElementName as shown:

Finally here is the actual output...there should be six records:

canuckconsultingAuthor Commented:
In the end I had to recreate the report but at least this helped me see the tablix was beyond help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.