General information
Category:
ActiveX controls
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only