ActiveReports 16 .NET Edition
ActiveReports 16 User Guide / Samples and Walkthroughs / Samples / Web Samples / Custom Data Providers
In This Topic
    Custom Data Providers
    In This Topic

    The 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 Web Designer.

    Radar Chart-Area

    Sample Location

    C#

    https://github.com/activereports/WebSamples16/tree/main/WebDesignerSamples/WebDesigner_CustomDataProviders

    Details

    This sample describes the following methods.

    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.

    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 build-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 datasource 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 DataSource and Sqlite DataSource.

    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.