How to change the datasource dynamically

To change the report data source dynamically in Bold Reports® Embedded Reporting, set new data source credentials in the OnInitReportOptions method of your Web API controller, as in the following code:

    [NonAction]
    public void OnInitReportOptions(ReportViewerOptions reportOption)
    {
        string connectionString = "Data Source = <instancename>; Initial Catalog = <database>; User ID = <username>; Password = <password>";
        DataSourceCredentials.Name = "AdventureWorks";
        DataSourceCredentials.ConnectionString = connectionString;
        reportOption.ReportModel.DataSourceCredentials = new List<DataSourceCredentials> { DataSourceCredentials };
    }

To change data sources based on application parameters on each platform, see the following Report Viewer help documentation.