To polish the result, let us create a report that shows the availability of materials with certain properties. To create the report, you will use the data composition system features that provide support for characteristics (fig. 15.47).
Fig. 15.47. Resulting report
Briefly, a data set for the data composition system it retrieved by a simple query to the BalanceOfMaterials register. The platform automatically includes the material option properties to the report based on the description that you created for the MaterialOptions catalog in section Description of material option characteristics.
Based on the description, the platform generates a straightforward and user-friendly interface for selecting characteristics. It also generates the required database queries based on the user-selected values.