I have a project that has a bunch of reports already done in Access. We are converting the whole thing over to asp.net, and consolidating all the seperate databases to one central sql server.

Now, since all the reports are already created in access, it would be a great time saver if we could keep a staging access db on the server to run the already made reports with. The problem is that the reports will be done on the server, but need to be sent to the client somehow.

Obviously ease of use is key. Can this be done? How would you go about doing this?

Is our only option something like Crystal Reports? We don't want to have to spend all the time recreating reports if we don't have to.