CR 8.5 and VB6

[EugeneShr]

I'm trying to use CR 8.5 from VB6 application. I know that there are several ways to do it - CR API, CR Designer, CR ActiveX etc.

I would like to build report using Access or Oracle DB and than I want to be able change the connection string in run-time.
In other case I'd like to build the report dynamicly with possibility to change the connection string up to user.

What is the best way to perform these operations?

Eugene

 

[ScottGS]

Eugene,

I am fairly new to this automation stuff, but I'm using the Automation Server Active-X control. It makes it pretty easy to take a report designed by the report designer program and load/view it within a VB program. You can set or override most of the report settings, including the record selection formula and data source.

There are samples on how to do this with Crystal. I'm also using the book Seagate Crystal Reports 8: The Complete Reference, by George Peck (pub by Osborne). It has a companion CD with more examples of the different integration methods.

Scott