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
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.