Report Data Source
The HTML5 Angular Report Designer provides support to create an embedded or shared data source using built-in or data processing extension. You can have any number of data sources that connect to different local or server data bases.
Built-in data source
The Angular Report Designer supports a set of built-in data providers to create a data source. They are,
- Microsoft SQL Server
- SQL CE
- OLE DB
Custom data processing extensions
Provides support to add any additional data providers to connect to your own database or extend functionalities of the existing data providers. The .NET framework compatible custom data processing extensions need to be created using data extension interface. With minimal configurations, you can use any additional data source such as OData, SASS, WebApi, MySQL, SQLite, PostgreSQL, MongoDB, etc.
Embedded data source
The HTML5 Angular Report Designer allows you to create an embedded data source with your own data connection. The embedded data source is speciﬁc to a report and you can use the connection string as expressions.
Shared data source
You can add a shared data source to report that is stored on a Report Server and shared by multiple reports. The shared data source provides better security by hiding the connection details.
Report data set
This has a query and collection of ﬁelds to represent the data returned from the data source.
Embedded data set
You can create a data set using an embedded or shared data source. It stores query used to process the report data. The embedded data set is speciﬁc to a report and you can add query parameters, ﬁlters, table relationships, and have the query string as expression.
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 reﬂect it in referred reports.