tablix returns only 1 record for dataset

Question

I have a tablix on an SSRS report:

When I run the report it only returns 1 record!

I did a sql server trace, and the query that is being executed is returning 14 rows.

On the same report, I dropped another table, and put just one field on it, and it returns 14 as expected. I noticed that the difference between the one that works and that one that doesnt is:

How can I get those 3 horizontal lines on the one that doesn't work?

What could be my issue? What did I do wrong?

Answer 1

The screen shot shows you don't have any groups. You deleted the details group from the Tablix. You can add it back in by inserting a new group or building a new tablix object from scratch.

To add a group, click on a cell in the row that should have a group, in this case the [ReferredBy] cell. Select Add Group -> Row Group -> Adjacent Above. If your data is already grouped at the correct level of granularity, then select Show detail data in the Tablix Group screen. This will add the details triple bar in a row above your current row. If you need to group on something, then pick the field to group on. This will add a ) in a row above your current row. Copy and paste the contents of the cells in your existing row into the new row and delete your original row.

Answer 2

One row when you expect multiple sounds like a grouping issue. Debugging something like this I would create a new table element below the current one and drag and drop a single column from the dataset. If it returns 14 you know it is not the dataset being evaluated as a problem but the table's expression. If it is also only returning one you probably have a predicate, filter expression, or parameter setting limiting the scope down as well.

Answer 3

Probably, you set the expression for Textbox and not for the RowGroup. Just find the Group Properties then put the same expression in Group On.