asked on

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.

c1nmo

Maybe dragged a total field onto the report? Can you expand the field you dragged on, the actual field should be below it?

venk_r

Check to see if you have dopped the field in the header section instead of detailed section.

c1nmo

See attached

BobRosas

ASKER

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

venk_r

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)

ASKER CERTIFIED SOLUTION

venk_r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

c1nmo

membership

This solution is only available to members.