SQLQuery

SQLQuery specifies the SQL query string used by the specified report.

Syntax

[form.]Report.SQLQuery[=SQLQuery$]

For example:

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.»

Remarks
CrystalReport1.SQLQuery="SELECT...FROM...
WHERE..." + CHR$(13) + CHR$(10) + "ORDER BY..."
Data Type

String

Availability

Design Time; Runtime

Related Report Engine Functions

PEGetSQLQuery



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com