tablix returns only 1 record for dataset
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
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.