If I have a paramter that has query based available values, how do I get it to use a connection string specified in another paramter to do the query?
The scenario is that I have one set of reports that pull from a number of databases that have identical schemas and each serve a different customer. i need to be able to somehow populate the valid values with the right data from the appropriate database at runtime.
Nevermind, I found it.
I just had to populate an array of ParameterValues with just the connection string and then do a call to GetReportParameters, that made sure that the other parameters had the data that they needed.
No comments:
Post a Comment