>Hi all,
>
>How can I change the printing order on my report form. Sometimes I want to print order by customer id. and sometimes want to print the order by more than two combined field. And I want to print out the records printed field in the footer when the condition is changed.
>Waiting for your help.
>
>Thanks
>
>Dennis

You cannot change the order of the record using REPORT FORM command. You have to have your cursor in specific order before you execute REPORT FORM.

You can do this by adding ORDER BY clause to your SQL statment or by having INDEX on specific fields.