I have written a user survey application, collecting obvisiously user information. I have their information going into an Access database when they hit submit.

I have also written a viewer application, for anyone in my shop to be able to browse through the database, without having to know anything about Access.

I want to add to this viewer all sorts of different reports that will basically sort the different pieces of information for whatever us administrators want to see.

I started off with DataReport's in VB, but I didn't really like them... didn't seem to be nearly enough functionality. (If I am wrong here and these DataReport's can be made really nice and are fairly simple to throw code into, please let me know.)

Next I tried Crystal Reports, but as I had expected, for anyone else to use my application and the report found within, they need at the very least, the crystal.ocx(can't remember the exact name) file installed locally on their machine. --Sure I could write a script to install whatever files need to be installed but, I really don't feel like it :-P

So my final question is, is there any way to actually access a MS Access report from VB. Kind of the same thing as crystal reports maybe?? If this does exist, it would work fantastically considering everyone already has Access installed on their machines.

Basically can I bring up an Access Report from VB, should I just write a script and use Crystal Reports, or am I missing some functionality of DataReports??

Thanks... You guys are awesome and I know you'll get to this when you can.
Happy Holidays