r_Donneesimport2.bas 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  1. Operation =1
  2. Option =0
  3. Begin InputTables
  4. Name ="r_DonneesImport"
  5. End
  6. Begin OutputColumns
  7. Expression ="r_DonneesImport.CodeAgent"
  8. Expression ="r_DonneesImport.DateRH"
  9. Expression ="r_DonneesImport.JourRH"
  10. Expression ="r_DonneesImport.MoisRH"
  11. Expression ="r_DonneesImport.AnneeRH"
  12. Alias ="SommeDeHeureSup1"
  13. Expression ="Sum(r_DonneesImport.HeureSup1)"
  14. Alias ="SommeDeHeureSup2"
  15. Expression ="Sum(r_DonneesImport.HeureSup2)"
  16. Alias ="SommeDeHeureSupDimanche"
  17. Expression ="Sum(r_DonneesImport.HeureSupDimanche)"
  18. Alias ="SommeDeRepas"
  19. Expression ="Sum(r_DonneesImport.Repas)"
  20. Alias ="SommeDeHS_VHCanal"
  21. Expression ="Sum(r_DonneesImport.HS_VHCanal)"
  22. Alias ="SommeDeHS_Chantier"
  23. Expression ="Sum(r_DonneesImport.HS_Chantier)"
  24. End
  25. Begin Groups
  26. Expression ="r_DonneesImport.CodeAgent"
  27. GroupLevel =0
  28. Expression ="r_DonneesImport.DateRH"
  29. GroupLevel =0
  30. Expression ="r_DonneesImport.JourRH"
  31. GroupLevel =0
  32. Expression ="r_DonneesImport.MoisRH"
  33. GroupLevel =0
  34. Expression ="r_DonneesImport.AnneeRH"
  35. GroupLevel =0
  36. End
  37. dbBoolean "ReturnsRecords" ="-1"
  38. dbInteger "ODBCTimeout" ="60"
  39. dbByte "RecordsetType" ="0"
  40. dbBoolean "OrderByOn" ="0"
  41. dbByte "Orientation" ="0"
  42. dbByte "DefaultView" ="2"
  43. dbBoolean "FilterOnLoad" ="0"
  44. dbBoolean "OrderByOnLoad" ="-1"
  45. dbBoolean "TotalsRow" ="0"
  46. Begin
  47. Begin
  48. dbText "Name" ="r_DonneesImport.DateRH"
  49. dbLong "AggregateType" ="-1"
  50. End
  51. Begin
  52. dbText "Name" ="r_DonneesImport.JourRH"
  53. dbLong "AggregateType" ="-1"
  54. End
  55. Begin
  56. dbText "Name" ="r_DonneesImport.AnneeRH"
  57. dbLong "AggregateType" ="-1"
  58. End
  59. Begin
  60. dbText "Name" ="SommeDeHeureSup1"
  61. dbLong "AggregateType" ="-1"
  62. End
  63. Begin
  64. dbText "Name" ="SommeDeHeureSup2"
  65. dbLong "AggregateType" ="-1"
  66. End
  67. Begin
  68. dbText "Name" ="SommeDeHeureSupDimanche"
  69. dbLong "AggregateType" ="-1"
  70. End
  71. Begin
  72. dbText "Name" ="SommeDeRepas"
  73. dbLong "AggregateType" ="-1"
  74. End
  75. Begin
  76. dbText "Name" ="r_DonneesImport.CodeAgent"
  77. dbLong "AggregateType" ="-1"
  78. End
  79. Begin
  80. dbText "Name" ="SommeDeHS_VHCanal"
  81. dbLong "AggregateType" ="-1"
  82. End
  83. Begin
  84. dbText "Name" ="r_DonneesImport.HS_Chantier"
  85. dbLong "AggregateType" ="-1"
  86. End
  87. Begin
  88. dbText "Name" ="SommeDeHS_Chantier"
  89. dbLong "AggregateType" ="-1"
  90. End
  91. Begin
  92. dbText "Name" ="r_DonneesImport.FraisValide"
  93. dbLong "AggregateType" ="-1"
  94. End
  95. Begin
  96. dbText "Name" ="MaxDeFraisValide"
  97. dbLong "AggregateType" ="-1"
  98. End
  99. End
  100. Begin
  101. State =0
  102. Left =0
  103. Top =0
  104. Right =1072
  105. Bottom =840
  106. Left =-1
  107. Top =-1
  108. Right =1056
  109. Bottom =383
  110. Left =0
  111. Top =0
  112. ColumnsShown =543
  113. Begin
  114. Left =53
  115. Top =-13
  116. Right =307
  117. Bottom =274
  118. Top =0
  119. Name ="r_DonneesImport"
  120. Name =""
  121. End
  122. End