What is the difference between Single Instance Data Region and Collection Data Region in Astera ReportMiner?

A Single Instance Data Region is used when the relationship between two regions is a one-to-one relationship. For example, in a dataset of orders, an order can only be placed by one customer. Therefore, we will use Single Instance Data Region to extract details of the customer from the data source.

A Collection Data Region is used when the relationship between two regions is a one-to-many relationship. For example, in a dataset of orders, there can be multiple items in one order. Therefore, we will use Collection Data Region to extract details of the items ordered.