I have an app which allows users to select different predifined data sources for some crystal reports (XI R2) one of which is the connection saved on the report. I can change between the datasources without too much problem e.g.
Code:
.Database.Tables(i).SetLogOnInfo ...
.Database.LogOnServerEx ...
However, if a user changes the database connection to be used and then saves the report (so that the data is saved on the report), the original report connection is overwritten and is therefore not available to the next user.

Does anyone know of either -
A method to change the database being used to return the data without altering the reports Log On details,
Or,
A way of only saving the data on the report without saving any other changes to it?

Both seem unlikely, but there's no harm in asking...