Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSRS Tablix only displaying one record

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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

860 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