If a data source is set to prompt the user for an ID and password, two more parameters are created at runtime for the data source. Because they are created at runtime, they do not show up in the Report Parameters dialog box. The only way to find the names is by making a web service call to the Report Server. Report Server web service calls are explained in more detail in Chapter 25, "How to Use Reporting Services Web Services." This does not preclude them from being passed in via a URL; however, this is not recommended because the user ID and password would be in clear text. |