Solved

Only 1 record shows in Report Services

Posted on 2011-09-07
9
290 Views
Last Modified: 2012-06-27
I created a new Dataset called "GPSData" in Report Services and I'm linked to SQL Server database.  When I right click on the dataset and select "query" and then run the query I get 1517 records.  Then I go to design view, add one field "Street" and then I preview the report and I only get 1 record.  I had parameters but I deleted them all.  I have the field in the body of my report.  If I right click on the field and view the expression the code looks like this...
      =Fields!Street.Value
When I preview it shows 1 of 1.  
Is there some report property that I'm missing that is not allowing all 1517 records to show?
 I've tried deleting the report and redoing it but get the same result.
0
Comment
Question by:BobRosas
[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
  • 3
  • 3
  • 3
9 Comments
 
LVL 6

Expert Comment

by:c1nmo
ID: 36499666
Maybe dragged a total field onto the report?  Can you expand the field you dragged on, the actual field should be below it?
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36499667
Check to see if you have dopped the field in the header section instead of detailed section.
0
 
LVL 6

Expert Comment

by:c1nmo
ID: 36499674
See attached

total or actual?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:BobRosas
ID: 36499833
Thank you all for your responses.  I got called away to an unexpected meeting.  I've attached a print screen of what I have.  I don't know if it will help.  It is not a total field.  It's a text field.  I added headers and footers to show that my field is not within them.  The print screen shows both the design and Preview mode.  I'm sure it's something simple, I'm just missing it.
Dataset.jpg
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36499951
you make a tablix first in the rdl, and then drag and drop from the dataset to the second row of the tablix (first is header)
0
 
LVL 8

Accepted Solution

by:
venk_r earned 125 total points
ID: 36500033
Go to the toolbox and drag the matrix  into the detail section and assign the datasets to it.
0
 
LVL 6

Assisted Solution

by:c1nmo
c1nmo earned 125 total points
ID: 36500042
need to add a container before adding fields otherwise they are grouped, in your case first()

see attached
eessrs2.png
0
 

Author Comment

by:BobRosas
ID: 36503441
That was it!  Table/Matrix!  I tried both ways and they worked so I doubled points.
Thanks so much!
0
 

Author Closing Comment

by:BobRosas
ID: 36503452
Thanks again!
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

630 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