Hi Grasshopper,

Thanks for the reply. The reason why I don't use Custom Datasources is because of the security configuration required. We use shared datasources executing on a specific SQL login. If we need to change the password of the reports login, we only do it in the shared datasources.

We have often found that knowledgeable users exploit Windows Authentication on SQL server, which is another reason why I don't want to pass the Server Name and Database Name in a URL, it opens up the security even wider.

I was hoping that there is a way that I can manipulate the datasource through a class library, and have the report extract the data from a specified database (and Server), without having to pass security information in URLs...