Desktop version

Main > Knowledge Base > Knowledge Base > Knowledge base > Practical developer guide 8.3 > Lesson 18 (3:40). Using calculation registers > Employee accruals report > In Designer mode > Query for a data set > Practical developer guide 8.3 > Lesson 18 (3:40). Using calculation registers > Employee accruals report > In Designer mode > Query for a data set

Query for a data set

Let us specify the query data set.

  1. Select the Accruals register table as the data source (fig. 18.22).


    Fig. 18.22. Accruals table fields 
  2. Select the following fields from this table (fig. 18.23):
    • Employee
    • CalculationType 
    • BegOfActionPeriod
    • EndOfActionPeriod
    • Recorder
    • Result

    Fig. 18.23. Fields selected for the query
  3. Click the Unions/Aliases tab and set the aliases for the BegOfActionPeriod and EndOfActionPeriod fields (fig. 18.24).

     
    Fig. 18.24. Unions/aliases
  4. Click OK.

    This completes the query creation.
Next page: Resources



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