I have built a Report but it only displays one record. The source of the data is a Query that when run, returns 26 records. The report will only display one record. If i change the sorting method, it will give me the first record in that particular sort, but will not display any other ones. How do i get all of the records to display on the report at the same time? The query is the same one being used on a seperate report that works fine.

This sounds like you are missing part of the report, or that the report is formatted to show only one record (TOP 1 parameter somewhere?)

Is there a Detail section on the report? How was the report made? Custom or wizard or code?



mmcdonal