>The online help lists the following statements for creating a report based on an SQL Select statement. However, I don't understand how MYREPORT.FRX knows to use MyCursor for the data environment. How can I create a report based on a Cursor?
>
>SELECT * ;
> FROM tastrade!customer ;
> WHERE customer.country = "Canada" ;
> GROUP BY customer.region ;
> ORDER BY customer.postal_code, customer.company_name ;
> INTO CURSOR MyCursor
>REPORT FORM MYREPORT.FRX
I never use the DE of the report. I always open my tables before calling my report. So, if you do the same, you'll be able to apply this example.