Crystal Report Help

[wbc12]

Hi,

I'm new in Crystal Report 4. I would like to know how do i use a VB6 application to pass in the SQL Query and it's field into a CR template and displaying it in the system itself?

I don't want to hardcode the fields and query string in the template.

[Hack]

Moved from ClassicVB

The way that I did it using 4.5 was by use of a "report table". I had an Access database that I deployed with the application. In that database, I had a variety of tables, each corresponding to a specific report. Each report was bound to one of my report tables.

My VB6 application sent an SQL query back to the database, and returned a recordset. The recordset results were then dumped into the appropriate "report table", and the Crystal Report that was bound to that table was run.

With 4 or 4.5 that is the only way I know of to do it. With later versions of Crystal, you can bind the report to an actual recordset so you don't need the bound report tables.