Problem with SQL 2005 Reporting Services

[WarrenW]

Hi,

I have created a Report Server Project in Visual Studio 2005 that is basically just like the demo they included. I added a data source. In the data I selected the top 100 records which shows. I designed the report in the Layout tab and then clicked Preview and it shows which is the first record.

Now I Build the project which is fine and run it. A new window showing the report comes up. But it only gives me the first page. It has 1 of 1 at the top instead of 1 of 100. How do i get it to show all of the records from the data so I can view them?

I'm still learning this so maybe its something very simple I left out.

Thanks

Warren

[Hack]

100 records does not necessarily mean 100 pages.

How many records are on the one page?

[schaefer]

The error is most likely in the Layout. If you are putting the results into a table then make sure the table is not filtering for just the first record. In fact, whatever object you are using to show the fields - make sure there is not a filter set to limit the results more than what the query is already doing.