home *** CD-ROM | disk | FTP | other *** search
/ Programmer 7500 / MAX_PROGRAMMERS.iso / CLIPPER / DATABASE / DBR10.ZIP / TEST2.FMT < prev    next >
Encoding:
Text File  |  1993-06-23  |  2.0 KB  |  87 lines
  1. *
  2. .Fields
  3. Combined     01
  4. Company      02
  5. Salary       03
  6. Age          04
  7. HiredDate    05
  8. Married      06
  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. *
  24. .VariableIf
  25. AgeSalary     IF Age >= 50
  26. AgeTally      IF Age >= 50
  27. DateTally     IF HiredDate < "01/01/86"
  28. TotMarried    IF Married == .t.
  29. TotSingle     IF Married == .f.
  30. *
  31. .VariableClear
  32. SubTotal 01
  33. *
  34. .Group 01
  35. Company
  36. .ReportHeader
  37.  
  38.                              dbReport Demo
  39.  
  40.                            Copyright (c) 1993
  41.                          Raymond J. Kuyvenhoven
  42.  
  43. *
  44. .PageHeader
  45.  
  46.                                                             Page: ^#
  47.                                                             Date: ^D
  48.                                                             Time: ^T
  49.  
  50. .GroupHeader 01
  51.  
  52. Company: ^F2<<
  53.  
  54.   Name                                   Num    Married    Salary
  55.   -------------------------------------- -----  -------    -----------
  56. .ReportBody
  57.   ^F1<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< ^F7<<    ^F6!   ^F3$$$$$$$.$$
  58. .GroupFooter 01
  59.                                                         --------------
  60. SubTotal                                                ^V1$$$$$$$$.$$
  61.                                                         ==============
  62.  
  63.  
  64. .PageFooter
  65.  
  66.  
  67. .ReportFooter
  68.  
  69.                                                         --------------
  70. Total                                                   ^V2$$$$$$$$.$$
  71.                                                         ==============
  72.  
  73.  
  74. Min Salary: ^V4$$$$$$$.$$
  75. Max Salary: ^V5$$$$$$$.$$
  76. Avg Salary: ^V6$$$$$$$.$$
  77. Num People: ^V3<
  78.  
  79. Total Married: ^V10<
  80.  Total Single: ^V11<
  81.  
  82. Employees over 50: ^V8<
  83.    Total Salaries: ^V7$$$$$$$$.$$
  84.  
  85. People hired before Jan 1, 1986: ^V9<<
  86.  
  87.