A report must have a data source and dataset to include data. The ASP.NET Core 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.
The ASP.NET Core Report Designer supports Microsoft SQL Server built-in data provider to create a data source.
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.
The ASP.NET Core 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.
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.
This has a query and collection of fields to represent the data returned from the data source.
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 specific to a report and you can add query parameters, filters, table relationships, and have the query string as expression.
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.