Passing Record sets to Crystal Reports 4.0 1

[chrispchenry]

Hey,
This program i've been working on is still being a pain. What i hate most is how the SQL syntax is different for VB and CR.

How would I go about setting a recordset in VB and passing that recordset to CR4.0? Thus making the report generated display only the information in the recordset.

Thanks

 

[zemp]

You can pass an ADO recordset from VB directly to a Crystal report by using a data definition file (.ttx).

Here is the information link at the crystal web site.

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

Basically you are using ADO to create a specific database that is part of the crystal .rpt file. You then feed this 'database' with an ADO recordset and print the report.
This method does not embed the report as part of the exe. So you will have to include them manually with any setup package. It also eliminates Crystal Reports from calling your database, which can free up a busy database.

I use this method often without problems. Thanks and Good Luck!

zemp

 

[chrispchenry]

thanks! this looks like it'll work!

 

[CCLINT]

And for CR version 7 users, this method will work as well. [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}