Only 1 record shows in Report Services
Posted on 2011-09-07
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...
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.