The connection between a report and a dataset is known as data binding. When you connect a report to a dataset, the report extracts the information from the data source to display the required data.
With the help of the Data panel, you can connect your report to the desired dataset. The Data panel categorizes the data sources into server, new based on model entity, and new based on server data source. In this article, you will learn about the types of datasets available in the Wyn report designer, steps to connect a report to a dataset, and the different ways to manage a dataset in a report.
This section elaborates about the different types of datasets supported in Wyn Enterprise:
The following sections describe the different ways to bind a dataset to a report in Wyn Enterprise.
Consider a scenario where you want to use a dataset already available on the Wyn Server. Such a dataset type is extremely useful for non-technical users since configuring the dataset requires no SQL queries, parameters, or other related data options.
Let's suppose, you want to create an ad hoc report for real-time data visualization and exploration. This is only possible when you bind a report to a model entity. A data model helps to transform the technical data structures from database tables and views into real-world entities, attributes, and relationships. It also helps to improve the readability of the data.
Let's say, you want to fetch data from a data source to be used only in one report. Apart from this, you want to configure its related data options such as fields, parameters, and filters to display only the required information in the report.
This section describes the different ways to manage a dataset in the report designer.