Query for a data set

Let us specify the query data set.

1. Select the BalanceOfMaterials.BalanceAndTurnovers virtual table as the data source.
2. Select the following fields from this table (fig. 15.48):
   • Material
   • PropertySet 
   • QuantityOpeningBalance
   • QuantityReceipt
   • QuantityExpense
   • QuantityClosingBalance
   
   Fig. 15.48. Fields selected for the query
3. Click the Unions/Aliases tab and set the aliases for the numeric fields by removing Quantity from their names (fig. 15.49).
   
   
   Fig. 15.49. Unions/aliases
4. Click OK.
   
   This completes the query creation.

Next page: Resources