Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS Tablix only displaying one record

Posted on 2014-03-12
3
Medium Priority
?
2,315 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
[X]
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
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

722 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