Live Chat Icon For mobile
Live Chat Icon

Report Data Sources

HTML5/JavaScript Report Designer

The HTML5/JavaScript Report Designer allows you to create presentation-ready reports using built-in data sources or data processing extensions against any local/server database.

What you can do with report data sources

Built-in data sources

The HTML5/JavaScript Report Designer supports a set of built-in data providers to create a report data source. They are:

  • Microsoft SQL Server and Azure SQL Database
  • SQL CE
  • Oracle
  • OLE DB, ODBC, and XML

Create stunning beautiful reports with built-in data-sources
Create stunning beautiful reports with custom-data-processing-extensions

Custom data processing extensions​

Add any additional data providers to connect to your own database or extend functionalities of the existing data providers. .NET Framework-compatible custom data processing extensions can be created using a data extension interface. With minimal configuration, you can use any additional data source such as OData, SASS, Web API, MySQL, SQLite, PostgreSQL, MongoDB, and more in the Report Designer.

Embedded data sources​

The HTML5/JavaScript Report Designer allows you to create an embedded data source with your own data connection. The embedded data source is specific to a report and you can use the connection string as expressions.

Create stunning beautiful reports with embedded data sources
Create stunning beautiful reports with shared data sources

Shared data sources

You can add a shared data source to any report stored on the Report Server, and it can be shared by multiple reports. Shared data sources provide better security by hiding connection details.

Embedded data sets

You can create a data set using an embedded or shared data source. The data set stores queries used to process the report data. The embedded data set is specific to a report and you can add query parameters, filters, table relationships, and have the query string as expression.

Create stunning beautiful reports with embedded data sets
Create stunning beautiful reports with shared data sets

Shared data set

Like shared data source, you can add a dataset that is published on a Report Server. It provides an easy way to change query at one place and reflect it in referred reports.