Ed,
Unfortunately, not currently. We have determined this is going to take a re-write to implement but it is definitely on our list as a highly important feature. In the meantime, the only real workarounds known are:
- Implement a type of database authentication that doesn't require credentials to be typed in (i.e. Active Directory authentication).
- You can use File DSNs instead of System / User DSNs and store the password within the .dsn file itself.
- Implement database views that cross over multiple databases so that your reports only need to point to one "database" - the one that contains the views.
Nothing ideal but that is where we stand currently.
-Adam
