I have a working crystal reports viewer embedding in an access form.
I would like to store the DSN connection Property for an opened crystal report into an ACCESS table. Is there a way via code to access the DSN connection string used by a crystal report to connect to a back-end database?
Background: I see that there is a way to change an opened reports data-set by first clearing the current data set and then passing it a new ADO record-set. To achieve this automatically, I would like to get the connection information for the report and use it for the ADO record-set to pass a different set of data.
Start Free Trial