Changing Report Datasource at Runtime using RAS

Hi all,

Hopefully someone out there can shed some light on this matter. I am creating a web page that will display reports. I have set up the crystal report application server and can get simple reports working no problem.

Currently i have a reports that are run from access databases. There are a number of identically structured databases with different data in each. What i want to do is to be able to change the datasource of te report to any one of these databases.

I have looked around for examples of how to do this but have had no luck. It looks like i can do it if the databases are sql using the SetTableLocationByServerDatabaseName method of the reportdocumentclient.

Can anyone please tell me how to do this if its possible.

Thanks in advance.