John,
from your original post, the report will run in whatever order the table is in, so you would need to:
SELECT MyTable
SET ORDER TO ReportOrder
if you are not using Tom's (and my) method of selecting data, exactly as you would like it to appear in the report, into a cursor and printing from there. When using a report cursor, you do not need to refer to the data as MyTable.MyField, but simply MyField.
To get the tables out of the report environment, right-click anywhere in the report and choose "Data Environment..." from the popup menu. Then select the table and click the delete key.
Now, about "getting the cursor information into the report" - I'm not entirely sure what you mean, but think of the report as a window through which you can see the data. REPORT FORM ... PREVIEW shows this window and the data under it on the screen and allows the user to make sure it looks ok, or to see how many pages it will be, or eyeball it to choose a particular page or section to print. REPORT FORM ... TO PRINTER takes the "window" of the report format, with the data showing through, and puts it on paper. Use PROPMT to bring up the Windows dialog so the user can choose a range of pages, choose a printer, etc.
Hope this helps.
>Good Morning Tom, and a Happy Easter:
>I'm trying to do the same thing, give the user the option to enter data in a form, then search and output the results into a report. Thank you for taking the time to explain. In the last line of your example, you wrote.
>INTO Cursor CuReport ;
>order By Client.LastName
>
>Do I put the command report form Payment.frx preview to get the cursor information into the report ? And Should I go in and change all of my fields in the report as you have explained. And do I remove the DA (tables) from the report ?
>
>Please Help
>Thanks Tom