How to configure data source extension

To add data connectors such as Web API, JSON, XML, and OData to the Bold Reports® JavaScript Report Designer, install the respective data extension NuGet package and register the extension assembly in Application_Start. The Report Designer application provides only the following data connectors as built-in data sources.

Built in data connectors

Other data connectors, such as Web API, JSON, XML, and OData, are provided as separate NuGet packages. Follow these steps to register and connect with these data connectors in the Report Designer application.

Create Report Designer JavaScript application

To create a Report Designer JavaScript application, follow Getting started.

How do I install a data source extension in the JavaScript Report Designer?

Based on the required data connector, install the respective NuGet package in the Report Designer application. The following table lists the NuGet package for each data connector.

Data source Package Name Assembly Name
Web data sources(WebAPI, JSON, XML, and OData) BoldReports.Data.WebData BoldReports.Data.WebData.dll
Postgre SQL data source BoldReports.Data.PostgreSQL BoldReports.Data.PostgreSQL.dll
MySQL data sources(MySQL, MariaDB, MemSQL) BoldReports.Data.MySQL BoldReports.Data.MySQL.dll
Excel data source BoldReports.Data.Excel BoldReports.Data.Excel.dll
CSV data source BoldReports.Data.Csv BoldReports.Data.Csv.dll
Oracle data source BoldReports.Data.Oracle BoldReports.Data.Oracle.dll
ElasticSearch data source BoldReports.Data.ElasticSearch BoldReports.Data.ElasticSearch.dll
Snowflake data source BoldReports.Data.Snowflake BoldReports.Data.Snowflake.dll

For example, to register and load web data sources in the application install BoldReports.Data.WebData package in the application.

Right-click the project or solution in the Solution Explorer tab, and choose Manage NuGet Packages. Alternatively, select the Tools > NuGet Package Manager > Manage NuGet Packages for Solution menu command.

Refer to the NuGet Packages to learn more details about installing and configuring Report Designer NuGet packages.

Search for BoldReports.Data.WebData NuGet package, and install it in your application.

Built in data connectors

BoldReports.Data.WebData installs into your application. Click OK. The assembly is then added to the respective project references.

Assembly reference

How do I register the web data source extension in the JavaScript Report Designer?

To register the extension in the Report Designer application, follow these steps.

  1. Open the code-behind file Global.asax.cs and add the following using statement.

        using BoldReports.Web;

  2. Register the assembly name of the required extension in Application_Start as follows:

        protected void Application_Start(object sender, EventArgs e)
    {
        System.Web.Http.GlobalConfiguration.Configuration.Routes.MapHttpRoute(
        name: "DefaultApi",
        routeTemplate: "api/{controller}/{action}/{id}",
        defaults: new { id = RouteParameter.Optional });

        AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);

        //Use the below code to register extensions assembly into report designer
        ReportConfig.DefaultSettings = new ReportSettings().RegisterExtensions(new List<string> { "BoldReports.Data.WebData" });
    }

To register multiple data extensions in the application, provide the assembly names as a list of strings.

Connect with data

  1. Launch the Report Designer application. Click the Data icon in the configuration panel to open a Data configuration panel. Create new reporting application project
  2. Click on the NEW DATA button in DATA panel. New data panel
  3. In list of connection types, you can find Web API, OData, JSON, and XML connection types. Loaded web data sources

To connect with these data sources in the Report Designer, see Data connectors.