Urgent :Showing all the records in the report

[meenasrs]

Hai,
I want to show all the records of an access table in the report. I have designed the report. But I am able to show only the first record. Anybody pl. help me in showing all the records of the table? (That table has links with another tables for showing the details in the report).

Meenakshi.R

[dsWA]

Hai,
I want to show all the records of an access table in the report. I have designed the report. But I am able to show only the first record. Anybody pl. help me in showing all the records of the table? (That table has links with another tables for showing the details in the report).

Meenakshi.R
Did you place the fields to be displayed in the details section of the report? It sounds as though you have placed them in a group, page or report header section.

Also check to see if you have put in a restrictive selection criteria that is limiting your data returned. Check to see if you have your links defined correctly (using the database expert) and your SQL is correct (can be seen using the Database/Show SQL menu option). You can try cutting and pasting the SQL generated into your database query tool to see what it returns.

[meenasrs]

Sir,
I have put all the fields in the details section itself. My query is correct. Since I am getting the related fields from various tables for the first records. But I am able to get the first record only from the parent table. I could not get the other records.

I herewith attach the report file. Pl. give me a way to get the report.
Meenakshi.R

[meenasrs]

Hello,
Pl. clarify my doubt.
Meenakshi.R