On this stage you should specify the data column to be used for sorting, and to select the sorting direction. Sorting criteria are specified in the Sort step. In this case, the selected data source Products. You should also select a data source on which to setup a new one. In our example, the alias name and the data source name is DataSource1. On this stage, you must specify the Name of a new data source and its Alias. The picture below shows the second form of the New Data Source dialog:Īs can be seen from the picture above, the process of creating data from other sources includes the following steps:ĭata Source. To do this, select Data from other Data Source item in the New Data Source dialog and setup the data source you create. But the easiest way is to create a data source based on another data. If you want to create a report that displays the name of the category and the total value of all products included in this category, it can be done in various ways.
The picture below shows a page of the Master-Detail report (shown partially):Īs can be seen from the picture above, the name of the category, product name (related to this category) and the price of the product are displayed in the report.
Suppose there is a Master-Detail report, to which each category corresponds a number of products. Consider the example of creating data from other data sources. When creating a data source using the visual interface, in the process of creating a data source, to perform sorting, grouping, filtering, and calculating of totals using aggregate functions. The Data from other Data Source provides analogical features like the query to the database.
#Stimulsoft calculated column with aggregate function generator
In the report generator you can create a data source based on existing data sources.
0 kommentar(er)
