Solved

Only 1 record shows in Report Services

Posted on 2011-09-07
9
289 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 64
Disable TLS1.0 on Win 2012 server 7 117
sql server major issue  need help 2 82
Need a mirrored QA test site 2 95
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach 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.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

751 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