I have a 'Product' parameter in my report. Depending on the product the user chooses, it will call the report generator stored procedure from a different data source. Looking at this article, I've found how to do the first part of this solution. I've created two internal parameters, Server and Database, and the connection string will use them to connect to the right database.
But I need to set this two parameters when the user chooses a product. How could I do this?
(If @Product = X) => @Server = Y, @Database = Z