Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Tablix only displaying one record

Posted on 2014-03-12
3
Medium Priority
?
2,447 Views
Last Modified: 2014-03-16
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:

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

columns
0
Comment
Question by:canuckconsulting
  • 2
3 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1500 total points
ID: 39924731
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.
0
 

Author Comment

by:canuckconsulting
ID: 39924984
Thanks.

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

snip
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:

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

output
0
 

Author Closing Comment

by:canuckconsulting
ID: 39932407
In the end I had to recreate the report but at least this helped me see the tablix was beyond help.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question