Crystal Reports in VB6

[ielashi]

I am recently working on an application to interact with databases and generate reports from the data collected. I have used crystal reports before, but I think it's too much of a hassle for the user to need the program to view the reports.

After some further reading and seaching on this forum, I realised that the Crystal Reports viewer will fill the need. I managed to make the viewer display the report, but there are still a few things I need to tackle.

I want to know how can I specify the database address through the VB code. Also I wanted to know how can I make queries in VB code to be executed in the report.

I am using VB 6 and Crystal Reports 10.
Any comments/suggestions would be greatly appreciated. :)

[Utpal Mehta]

It is better you use the ODBC connection to use the CR.
You can use the recordselectionformula property of the
CR from within VB code to make queried report...

Utpal Mehta

[mabbas110]

Hi,
I have one suggestion for you , that if u use version 8.5 of crystal report with VB 6.0 or higher for .NET . it will be more feasible and flexible.

[ielashi]

No problem. I almost got it here. :)