Solved

SSRS Tablix only displaying one record

Posted on 2014-03-12
3
1,898 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 65

Accepted Solution

by:
Jim Horn earned 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
How to increase the row limit in Jasper Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

823 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