Hi,

You can do this in two ways:

1. use SelectionFormula property of the crystal report to pass your criteria
2. Add Chr$(13) & Chr$(10) after your "Where" clause and before your "Order By" clause in SQLQuery

Eg:- Report1.SQLQuery = "select supplier.name,... from supplier where supplier.status = 'X'" & Chr$(13) & Chr$(10)
The selection list should be the same as the one defined in the report
to test it, paste the value of the SQLQuery in the Report SQL statement and see if it works

Prasanna