Virtual table parameters

Let us specify the Periodicity virtual table parameter.

  1. In the Tables field, click the SalesTurnovers table, and then click the Virtual table parameters  button (fig. 13.58).

    Fig. 13.58. Specifying virtual table parameters
  2. In the Virtual table parameters window, set Periodicity to Day (fig. 13.59).

    Fig. 13.59. Specifying virtual table parameters
  3. Click OK.
  4. Select the following table fields (fig. 13.60):
    • SalesTurnovers.Technician
    • SalesTurnovers.Period
    • SalesTurnovers.Customer
    • SalesTurnovers.RevenueTurnover

    Fig. 13.60. Selected fields
  5. Click the Unions/Aliases tab and type Revenue as the alias for the SalesTurnovers.RevenueTurnover field (fig. 13.61).

    Fig. 13.61. Unions/aliases
  6. Click OK.
Next page: Analyzing query text
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.