Is it possible to send a access report to client?

[hellswraith]

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.

[Edneeis]

The best thing would be the SQL Reporting Tool but its still in Beta. Its great though you can host reports from SQl to a site directly. That would still mean rewriting the reports though.

Anyway this is a bit of a cheese way of doing it but you could have the server execute the report and export it to another format, all on demand. You could just make an Access Macro that does all the work and have the server open access run the macro and link to the exported report. Access can even export directly to HTML and can use an HTML template if need be. Some of the formatting doesn't come out as clean when you export though but its not bad.

[hellswraith]

Never thought about exporting it to HTML....something to look into.

Thanks.

Any other ideas are welcome if anyone has em.