We are using RDLX reports and displaying them with the HTML5 Report Viewer in and ASP.NET MVC 5 application. Right now, the connection string for all of the reports is in a RDSX file that all reports point to. This becomes a problem when deploying to PROD vs QA vs UAT environments as they each have a different database and hence database connection string.
Is there a way to specify the connection string from the Web.config. Please remember that we are using the HTML5 viewer b/c that is all that seems to be supported in an MVC environment.
If there is any sample code for this, that would be ideal. Thanks!!