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.