I wanna make a report which is simple.IT should list all of employees but it just list one row?Why any idea

[havvauslu5]

I wanna make a report which is simple but ı could not do .IT should list all of employees(I made a server connection and wrote a query like "select * from employees") but it just list one row?Why any idea

[Tarun Gupta]

hello,,,,,

you should put some data in ur database,,,,,,,,,,,

and try again ,,,,,its working may be,,,,,,

[hozawa]

I've uploaded a simple video which shows how to create a simple list from a database. (I'm using Japanese version of Studio)

I think you only seem to be getting 1 row because you haven't deleted unnecessary bands so that ony 1 record is showing per page.

Have you tried executing your sql statement from the database to see how many rows you should be getting?

[Tom C]

Assuming you indeed have more than one record in your query resultant dataset, most likely you did not display the record field in Detail section of the report. If, for example, the field is displayed in report Title band, you will only see the first record from the result set in the report. If, on the other hand, it is displayed in the Summary band, then you will only see the last record from the result set in your report.

[Tom C]

Here is the example of what you will see in the report depending on data being displayed in different report bands.