I have a Silverlight report viewer to render the report from a class library within the same solution as the Silverlight project, following your best practices guide for creating reports.
In general I need a report to connect to multiple database(s) based on user selected options in a Silverlight application. I also have a Report Parameter which runs a SQL query on the database and returns a list of data that will be used to filter the report data. I’m having difficulty dynamically changing the connection string to the database, the report parameter still points to the initial database set during design time. It seems the report parameter can be accessed only in need_datasource event, but the report parameter needs this connection string to display the list of data that will be used to filter the report data.
1) Is there a way we could set reportParameter AvailableValues.DataSource in the need_datasource event or dynamically.
2) Is there a way to pass this connection string into the constructor in order to set the reportParameter in the constructor. Setting the value here seems to work but I cannot pass a value into the constructor.
3) Is there different design approach that we should be using?
Thanks for your help in advance.