Hi Grasshopper,

I'm not shure how hardcoding the UserName and Password in the DataSource tab would improve the security, please explain.

If you have a large number of reports, and the username and password that you use on the reports leaks out, you will have to change it for every report, making it a nearly impossible task, where as if you use shared datasources, you would only change a few datasources. This in my opinion is a major security risk.

I am also very conservative with using patterns in database names, we typically try to stay away from it as it can become a limitation if your application scales out drastically...