I have SQL statement designed in Access. I want to write a report using Crystal report writer in VB5 using the SQL statement as the data source. The problem is My SQL statement requires a parameter and it is not listed when designing the report.
The SQL statement is
SELECT * FROM customer
WHERE customer.name = anyname
I want to dynamically pass anyname to Crystal report and have it display a report.
Please let me know if that can be done.