using .net core connection string for bold reports?

[Lyndon]

Hi ,

I am using bold reports in my .net core razor application.  The application uses entity framework for data access and standard scaffolded code. In appsettings.json I define the connection strings as 

  "AllowedHosts": "*",

  "ConnectionStrings": {

    "WorkManagerV4Context": "Server=WIN10DESKTOP\\VS2019;Database=WorkmanagerV5;Trusted_Connection=True;MultipleActiveResultSets=true"

  }

In my bold reports I notice that the sql server information is hard coded into the definition of each report:

  <DataSources>

    <DataSource Name="DataSource1">

      <ConnectionProperties>

        <DataProvider>SQL</DataProvider>

        <ConnectString>Data Source=WIN10DESKTOP\VS2019;Initial Catalog=WorkManagerV4</ConnectString>

        <IntegratedSecurity>true</IntegratedSecurity>

      </ConnectionProperties>

      <rd:SecurityType>Integrated</rd:SecurityType>

      <rd:DataSourceID>d435ec7e-2564-47a6-a21f-dad31354076d</rd:DataSourceID>

    </DataSource>

  </DataSources>

Is there any way of having all the bold report definitions be referencing the datasource  in appsettings.json or just once somewhere in my .net c# code- so that if that source changes each report definition doesnt have to also be changed?

Thanks

[Manoranjan Rajendran]

Hi Lyndon, 

We have validated your requirement. You want change the data source in report dynamically. You can change the report datasource in application while report processing please refer the below document for this, 

https://help.boldreports.com/embedded-reporting/aspnet-core-reporting/report-viewer/how-to/change-datasource-dynamic-at-server-side/ 

Regards, 

Manoranjan  R