How to: Print Query Results in a Report or Label

If your report or label includes groups or you otherwise need to order the data, you can use the various clauses of the SELECT - SQL statement to get the exact results you need.

To send results to an existing report or label

• Use the SELECT - SQL statement with a REPORT or LABEL command.

  The following example uses the GROUP BY and ORDER BY clauses as well as the REPORT FORM command:

  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
  

  The following example uses a LABEL FORM command:

  SELECT * ;
     FROM tastrade!customer ;
     WHERE customer.country = "Canada" ;
     GROUP BY customer.region ;
     ORDER BY customer.postal_code, customer.company_name ;
     INTO CURSOR mycursor
  LABEL FORM MYLABEL.LBX
  

While the SELECT - SQL statement is the most flexible method for populating your report or label, it is not the only method.

See Also

Tasks

How to: Run Queries (Visual FoxPro)

Reference

SELECT - SQL Command

Concepts

Integrating Reports with Applications

Other Resources

Setting Query Output Destinations