How to use CR within VB6

[Zoet]

Can anyone point me in the right direction?

New to CR within VB. Need to print a report based on SQL which is set at run time. Actually what is set is the Where clause of the SQL.

How can I run this type of Crystal Report from within VB6.

All help appreciated. [sig][/sig]

 

[kenhamady]

Crystal allows you to either pass the SQL statement, pass the record set from memory, or simply replace the crystal report selection formula (which indirectly changes the where clause).

The syntax for these will depend on which of the 4 techniques you use for launching the report from within VB.

[sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[Zoet]

Can anyone give me some sample code for VB6 to change the SQL within a Crystal Report and then run the report.

Regards [sig][/sig]

 

[Guest_imported]

Private Sub cmdCPOk_Click()
Select Case Menu_Name
Case