Hi,
It could be userfull to have a way to dynamically prompt for user name and password for the database connection. The proposed solution to put the connection string in a report parameter exposes sensitive information. It could be an option in the "Configure SQL Data Source" where we could set a checkbox as "Prompt for user name and password". At the end, everything would be saved with the report definition except the user name and password. On the report rendering, the user name and password will raised a dialog box for user name and password for the report.
Thanks,