I am already using an ADODB connection to the database. I have gotten the VB DataReport to work, and the Crystal Reports to work from my application. However, when I created the .exe and put it on our network for one of our other admins to try out, the crystal reports didn't work because it said crystal.ocx(or something of that sort) not found.

With VB DataReports, it just doesn't seem like it would be very easy to throw code into to change the report around. I could use Crystal Reports, but I would have to write a script to push out the required files to all our admin machines, and I don't really want to do that.

OR.

Are you saying that you can say something like
Code:
dim myReport as new ADODB.Report

'the connection will already be active to the db through the var "conn"

Set myReport = New ADODB.Report
'on click of menu item
myReport.open
sorry if I confused you before, and if you still are just let me know.

Thanks in advance.

Buddy