Solved

Missing data in rdl table

Posted on 2013-06-21
3
468 Views
Last Modified: 2013-06-21
I'm working on a .rdl report in VS2008/SQL server 2008 R2.  

The data of a table in .rdl report is from a store procedure. Multiple rows are returned from the store procedure, but only the first row is displayed in .rdl report. I'm wondering why this is happening. Is there a special property setting for it? I appreciate any help.
0
Comment
Question by:minglelinch
[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 500 total points
ID: 39265980
One common reason this happens is that the tablix had its Detail row deleted, and the way to tell is if the grey bars to the left of the rows does not have one with three lines in it.

Last I recall the only way to resolve this is to delete the tablix, and re-create it.
0
 
LVL 1

Author Closing Comment

by:minglelinch
ID: 39266182
Thank you for the answer. I corrected it.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 39266200
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

724 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