• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Only 1 record shows in Report Services

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
BobRosas
Asked:
BobRosas
  • 3
  • 3
  • 3
2 Solutions
 
c1nmoCommented:
Maybe dragged a total field onto the report?  Can you expand the field you dragged on, the actual field should be below it?
0
 
venk_rCommented:
Check to see if you have dopped the field in the header section instead of detailed section.
0
 
c1nmoCommented:
See attached

total or actual?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
BobRosasAuthor Commented:
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
 
venk_rCommented:
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
 
venk_rCommented:
Go to the toolbox and drag the matrix  into the detail section and assign the datasets to it.
0
 
c1nmoCommented:
need to add a container before adding fields otherwise they are grouped, in your case first()

see attached
eessrs2.png
0
 
BobRosasAuthor Commented:
That was it!  Table/Matrix!  I tried both ways and they worked so I doubled points.
Thanks so much!
0
 
BobRosasAuthor Commented:
Thanks again!
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 3
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now