Freddie,
First, in the Report Form command you use the report name:

Select .....  into cursor RPTA
SELECT RPTA
report form MyReport PREVIEW

You seem to be using the cursor name not the report name in the "REPORT FORM" command.

As for your other questions:

1: Yes, you can use a field name unless you have a union or other other complex code.

2: The field names in the cursor must match the field names in the report FRX file. Otherwise it is unimportant whether they match the original table.

3: Should work. See first comment

4: The cursor must have every field that will be in the report. However the cursor name is not used in the REPORT FORM.... command. Just the report name.

HTH
Barbara

>Hi Barbara:
>
>Everything looks good except for last line of code I am getting Command contains
>unrecognized phrase/keyword. I have a copy of hacker's Guide to Visual FoxPro 6.0 and dosen't give much on setting up PREVIEW logic. Copy my logic is shown below:
>
>cFilt = "Status = 'WORKING'"
>SELECT ;
... < snip >
>
>REPORT FORM Rpta PREVIEW. --- Command contains unrecognized phrase/keyword.
>
>Question 1: Could I use a field name on ORDER BY 1.
>
>Question 2: INTO CURSOR Rpta ; Field names under Rpta are not the same as in table.
>Question 3: REPORT FORM Rpta PREVIEW. --- Should work.
>Question 4: Should I list every CURSOR field that should show up in PREVIEW?
>
>Barbara Rpta is my report layout for CURSOR fields. should I list every CURSOR after PREVIEW