passing select criteria

[MuraliKrishnaK]

Hi,

Is it possible to pass a select criteria from Visual Basic for the report recordset in crystal reports? If yes, can any body help me in this?

Murali Krishna

 

[kenhamady]

What integration method are you using? (if unsure, see the FAQ on "Questions should include&quot
How are you connecting to the database? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[MuraliKrishnaK]

I am using ADO to connect to the database. And the data base is of Access mdb.

I require to give choice to the user to select the a criteria from VB form (in my case 'year', to select only those records from the lot). I need to pass the year parameter to the crystal Reports to get the desired result.

I hope you can now understand my problem.

Murali Krishna

 

[kenhamady]

You need to clarify your connection.

ADO usually means that the application is assembling a recordset to pass to the report. The report should be created by ADO connection as a preparation for receiving a records set from the app.

If you are passing a recordset, there is no need to send a parameter to the report. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/