WebDesigner Custom Data Providers

The WebDesigner Custom Data Providers sample demonstrate the method to use custom data providers (such as SQLite and OData) for supplying data to the report in the ActiveReports WebDesigner.

Data Provider in Web Designer

type=note

Note: To run this sample, you must have

Visual Studio 2022 (version 17.0 or later)

.NET 6.0 SDK

.NET Core Hosting Bundle (for deployment to IIS)

Sample Location

https://github.com/activereports/WebSamples19/tree/main/WebDesigner_CustomDataProviders

Details

This sample describes the following methods.

Using SQLite Provider
Using C1 ODATA Provider
Using ODATA Datasets

Using SQLite Provider

In order to use SQLite provider to add a data source, go to Data tab and click Add next to Data Sources. In the Data Source dialog, select the 'SQLite Provider' option in the Provider, set the path of the desired sqlite file in the Connection String, and click Add button. This will add a data source using the SQLite provider to the report.

Using C1 ODATA Provider

In order to use C1 ODATA Provider to add a data source, go to Data tab and click Add next to Data Sources. In the Data Source dialog, select the 'C1 ODATA Provider' option in the Provider, set the URL of the desired data from where the data will be fetched in the Connection String, and click Add button. This will add a data source using the C1 ODATA Provider to the report.

Using ODATA Datasets

In order to add ODATA Datasets, go to Data tab and click Add next to Data Sets. Select NWWIND dataset, an ODATA whose definition is available in the datasets folder.

type=note

Note:

In case you face any problem related to C1 ODATA Provider, kindly register and install the trial version of the ComponentOne's 'Service Components'.

This sample does not have a built-in license for C1 Data Connector, so you may need to buy this license separately.

The project consists of the following elements.

Datasets Folder

This folder contains two JSON files named as Employees and Invoices.

Northwind.sqlite

This is the sample SQLite data source added in the project for reference. Retrieves the data to be displayed in the report.

Resources Folder

This folder consists of three files - Cosmo.rdlx-theme, InvoiceOData.rdlx and ListSqlite.rdlx. You can load the sample report 'InvoiceOData.rdlx' and 'ListSqlite.rdlx' that uses OData Data Source and Sqlite Data Source.

Implementation Folder

This folder consists of two files - FileSystemTemplates.cs and ODataDataSets.cs. FileSystemTemplates.cs is used to define the template extension whereas 'ODataDataSets.cs' is used to set the ODATA datasets.