Create a Report in VB6?

[KenBZim]

I write all my applications in VB6 and Use an access database all of the time.
My question is : what is the best method of creating reports where data may be extracted from the access database possibly tabulated and presented to the user in VB6 ?
The report should be available on screen, or may be printed (possibly even exported ???)

[Hack]

You could use either Data Reports or Access Reports depending on which you are more familiar with.

[KenBZim]

Thanks Hack
Excuse my ignorance but I once created a report in VB specifying a data environment etc. etc. but I couldnt figure out how to get this to work if the database was on a server with multi users, it was also a while ago and I can't remember how I did it.
I was hoping for a method that could be used to create reports even after the app has been distributed to the user, or reports that may even be created by the user himself.
Is this possible ?

[kulitag]

you can use system dsn to connect to your system.

[RobDog888]

If you have Crystal Reports available to you it would be the best chioce in my opinion. You can use the CR Viewer control to open and view a report. also, it has an Export button that practically automatically exports the report in many formats like Excel, PDF, etc.

[Hack]

I was hoping for a method that could be used to create reports even after the app has been distributed to the user, or reports that may even be created by the user himself.
Is this possible ?

Creating a report usually involves some form of database query to return a result set, that, in turn, gets nicely formatted for printing.

If your users have access and rights to your database, then they could do this themselves, but it would be completely external to the application you have written.

[KenBZim]

Thanks Guys

[Hack]

So, what is the final verdict? What did you decide to go with?