Passing Parameters

[Guest_imported]

How can I pass SQL Query from VB

for eg
(select * from employee_details&quot ---- Written in Crystal reports

where date_join>txt_joindate.text ----- want to pass from VB

and I want only those records matching the criteria (II)

Thanks
anil

 

[betaanish]

Hi anil kumar,


try using recordselection fomula.

Cr1.Selectionformula = &quot;{FldName1} = <value>&quot;

Where Cr1 is Crystal Report ActiveX Control Name

 

[Guest_imported]

Everytime I try to refresh the report from VB I get OLEDB error. How do I write these parameters.

I am using
VB 6.0
SQL Server 7.0