SQLQuery specifies the SQL query string used by the specified report.
[form.]Report.SQLQuery[=SQLQuery$]
CrystalReport1.SQLQuery = "SELECT authors.au_id, authors.au_lname, authors.au_fname FROM pubs2.dbo.authors authors WHERE authors.au_lname > 'Madison'"«Queries the SQL database to return only the records where the authors last name falls after Madison alphabetically.»
CrystalReport1.SQLQuery="SELECT...FROM...
WHERE..." + CHR$(13) + CHR$(10) + "ORDER BY..."
| Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |