Main > Knowledge Base > Knowledge Base > Knowledge base > Practical developer guide 8.3 > Lesson 13 (4:30). Reports > Using calculated fields in reports > In Designer mode > Query for a data set > Practical developer guide 8.3 > Lesson 13 (4:30). Reports > Using calculated fields in reports > In Designer mode > Query for a data set

Query for a data set

Let us specify the query data set.

  1. Select the Sales.Turnovers virtual table as the data source.
  2. Select the following fields from this table (fig. 13.100):
    • SalesTurnovers.Customer
    • SalesTurnovers.RevenueTurnover
    • SalesTurnovers.CostTurnover

    Fig. 13.100. Fields selected for the query
  3. Click the Unions/Aliases tab.
  4. Change RevenueTurnover to Revenue and change CostTurnover to Cost.
  5. Click OK.

    This completes the query creation. Since the query contains only expressions that you already know, we will not explain it in detail. Let us proceed to editing the data composition schema.
Next page: Calculated fields



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.