home *** CD-ROM | disk | FTP | other *** search
/ Monster Media 1993 #2 / Image.iso / clipper / dbr11.zip / TEST2.FMT < prev    next >
Text File  |  1993-07-27  |  2KB  |  104 lines
  1. *
  2. .Fields
  3. Combined     01
  4. Company      02
  5. Salary       03
  6. Age          04
  7. HiredDate    [DD MON YY] 05
  8. Married      06  [Yes/No]
  9. PersonNum    07
  10. *
  11. .Variables
  12. SubTotal      := SUM Salary
  13. Total         := SUM Salary
  14. PersonTally   := TALLY
  15. SalaryMin     := MIN Salary
  16. SalaryMax     := MAX Salary
  17. SalaryAvg     := AVERAGE Salary
  18. AgeSalary     := SUM Salary
  19. AgeTally      := TALLY
  20. DateTally     := TALLY
  21. TotMarried    := TALLY
  22. TotSingle     := TALLY
  23. Variance1     := VARIANCE Age
  24. StdDev1       := STDDEV Age
  25. Variance2     := VARIANCE Salary
  26. StdDev2       := STDDEV Salary
  27. *
  28. *
  29. .VariableIf
  30. AgeSalary     IF Age >= 50
  31. AgeTally      IF Age >= 50
  32. DateTally     IF HiredDate < "01/01/86"
  33. TotMarried    IF Married == .t.
  34. TotSingle     IF Married == .f.
  35. *
  36. .VariableClear
  37. SubTotal 01
  38. *
  39. .Group 01
  40. Company
  41. .ReportHeader
  42.  
  43.                              dbReport Demo
  44.  
  45.                            Copyright (c) 1993
  46.                          Raymond J. Kuyvenhoven
  47.  
  48. *
  49. .PageHeader
  50.  
  51.                                                             Page: ^#
  52.                                                             Date: ^D
  53.                                                             Time: ^T
  54.  
  55. .GroupHeader 01
  56.  
  57. Company: ^F2<<
  58.  
  59.   Name                                Num   Married  HiredDate    Salary
  60.   ----------------------------------- ----- -------  ---------    -----------
  61. .ReportBody
  62.   ^F1<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< ^F7<<   ^F6!   ^F5<<<<<<  ^F3$$$$$$$.$$
  63. .GroupFooter 01
  64.                                                                --------------
  65. SubTotal                                                       ^V1$$$$$$$$.$$
  66.                                                                ==============
  67.  
  68.  
  69.  
  70. .PageFooter
  71.  
  72.  
  73. .ReportFooter
  74.  
  75.                                                                --------------
  76. Total                                                          ^V2$$$$$$$$.$$
  77.                                                                ==============
  78.  
  79.  
  80.  
  81.  
  82.  
  83. Min Salary: ^V4$$$$$$$.$$
  84. Max Salary: ^V5$$$$$$$.$$
  85. Avg Salary: ^V6$$$$$$$.$$
  86. Num People: ^V3<
  87.  
  88. Total Married: ^V10<
  89.  Total Single: ^V11<
  90.  
  91. Employees over 50: ^V8<
  92.    Total Salaries: ^V7$$$$$$$$.$$
  93.  
  94. People hired before Jan 1, 1986: ^V9<<
  95.  
  96.  
  97.    Age Variance: ^V12<<<<<<<.<<
  98.     Age Std Dev: ^V13<<<<<<<.<<
  99.  
  100. Salary Variance: ^V14<<<<<<<.<<
  101.  Salary Std Dev: ^V15<<<<<<<.<<
  102.  
  103. *
  104.