PRB: Cannot Create a Quick Report/Wizard Report from a Cursor (142393)

MORE INFORMATION

Steps to Demonstrate Behavior

1. Open or switch to Microsoft Visual FoxPro.
2. Open a free table (one that is not part of a database), and type the following command in the Command window -- where <TableName> is the name of the free table:

      SELECT * FROM <TableName> INTO CURSOR MyCursor
   						

3. On the Tools Menu, click Wizards - Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK.
4. Note that the cursor MYCURSOR is listed in the Databases/Tables list box and is therefore available for the creation of the report. Click Cancel, and then close the table and the cursor.
5. Open a table that is part of a database, and type the following command in the Command window -- where <TableName> is the name of the table you just opened:

      SELECT * FROM <TableName> INTO CURSOR MyCursor
   						

6. On the Tools Menu, click Wizards - Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK.
7. Note that the cursor MyCursor is not listed in the Databases/Tables list box and is therefore not available for the creation of the report. Click Cancel, and then close the table and the cursor.
8. Open a free table and type in the following command in the Command window:

         SELECT * FROM <TableName> INTO CURSOR MyCursor where ;
            fieldname="some variable"
   						

9. On the Tools menu, click Wizards-Report. Then in the Wizard Selection dialog box, click Report Wizard, and then click OK.
10. Note that the cursor MyCursor is not listed in the Databases/Tables list box and is therefore not available for the creation of the report. Click Cancel, and then close the table and the cursor.