Nap,
This is usually caused by including the alias in the fields on the report and running the report while another cursor is selected.
Say you built the report using table XYZ and the fields on the report are tied to the table like:
xyz.field1
Now you switch to using a report cursor:
select * ;
from xyz ;
into cursor thisreport ;
where ...
order by ...
report form MyReport
the report iterates the rows of your cursor, but it keeps printing the one current row of the original table because of the table attachment in the report field.
When you create reports, don't add the table to the DE and do not assign the alias, this will let your report run against whatever the current alias is.
>I've created a cursor and an ID report.
>Cursor name: cprint
>fields: pic, studidn, fname, mname, lname, course
>
>the cursor has 4 record for now, when I preview the report, it show 4 of the same records, usually when I give a command of go top it show 4 pictures of the first record, how can I control or which one will I control the report or the cursor?
>
>The reason why I used a cursor is to prevent the .fpt file from growing into a large file.