Passing Sql from vb6 to CR8 1

[jabbylay]

im new in using crystal reports. I would like to know how to pass an sql statement from a vb6 application system to crystal reports. Is this possible? if so, please help me. if not, is there a work around to this?

 

[synapsevampire]

If you intend the change the SQL, then it sounds like you'll also need to dynamically build a report. Here's the sample applications for VB using the RDC:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/apps_rdc.pdf.asp

If all you're doing is filtering data against a known set of tables/joins, then consider creating a report and passing a Crystal record selection formula or just Crystal Parameters to it as opposed to constructing a dynamic SQL statement and a report on the fly.

-k