I have decided to try using the DataReport, but afew questions have sprung up.
1- When setting the properties for the connection, I had to set the location of the database, can't I be able to set it remotely as in, as long as I go to any machine that has the same databse, i will be able to link to instead of specifying the path each time? Eg The same way we set ADODB eg cnAddMovie.Open App.Path & "./databases/visualtek.mdb"

2 - So far am only able to set my report in column & row format, how can I set it to my own taste?

3 - How can I allow my users to set the title of the report, as in they are able to set the header, title and footer.

Thanks