I have a report that I would like to switch between vendor's Production and DEV environments). I know how to make it dynamic for the datasources. I would use something similar to this:
="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=DBabc"
Is it possible to change credentials? The production and DEV environments have user id and password that are different from each other. How would I do this and still secure the password (credentials)? Also, I cannot prompt the users to enter password because we have to keep this secure.