Operation =1 Option =0 Begin InputTables Name ="tbl_FormDep" Name ="r_DonneesImport2" End Begin OutputColumns Expression ="r_DonneesImport2.CodeAgent" Expression ="r_DonneesImport2.DateRH" Expression ="r_DonneesImport2.JourRH" Expression ="r_DonneesImport2.MoisRH" Expression ="r_DonneesImport2.AnneeRH" Alias ="HeureSup1" Expression ="r_DonneesImport2.SommeDeHeureSup1" Expression ="tbl_FormDep.HeuresDep" Alias ="HeureSup2" Expression ="r_DonneesImport2.SommeDeHeureSup2" Expression ="tbl_FormDep.HeuresDepNuit" Alias ="HS" Expression ="Nz([SommeDeHeureSup1]+[HeuresDep],0)" Alias ="HSNuit" Expression ="Nz([SommeDeHeureSup2]+[HeuresDepNuit],0)" Alias ="HeureSupDimanche" Expression ="r_DonneesImport2.SommeDeHeureSupDimanche" Alias ="HS_VHCanal" Expression ="r_DonneesImport2.SommeDeHS_VHCanal" Alias ="HS_Chantier" Expression ="r_DonneesImport2.SommeDeHS_Chantier" End Begin Joins LeftTable ="tbl_FormDep" RightTable ="r_DonneesImport2" Expression ="tbl_FormDep.CodeAgent = r_DonneesImport2.CodeAgent" Flag =1 LeftTable ="tbl_FormDep" RightTable ="r_DonneesImport2" Expression ="tbl_FormDep.AnneeRH = r_DonneesImport2.AnneeRH" Flag =1 LeftTable ="tbl_FormDep" RightTable ="r_DonneesImport2" Expression ="tbl_FormDep.MoisRH = r_DonneesImport2.MoisRH" Flag =1 LeftTable ="tbl_FormDep" RightTable ="r_DonneesImport2" Expression ="tbl_FormDep.JourRH = r_DonneesImport2.JourRH" Flag =1 End Begin OrderBy Expression ="r_DonneesImport2.CodeAgent" Flag =0 Expression ="r_DonneesImport2.JourRH" Flag =0 End dbBoolean "ReturnsRecords" ="-1" dbInteger "ODBCTimeout" ="60" dbByte "RecordsetType" ="0" dbBoolean "OrderByOn" ="0" dbByte "Orientation" ="0" dbByte "DefaultView" ="2" dbBoolean "FilterOnLoad" ="0" dbBoolean "OrderByOnLoad" ="-1" dbBoolean "TotalsRow" ="0" Begin Begin dbText "Name" ="HS" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HSNuit" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.HeuresDep" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="tbl_FormDep.HeuresDepNuit" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HeureSup1" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HeureSup2" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HeureSupDimanche" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.CodeAgent" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.JourRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.MoisRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.AnneeRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.DateRH" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="Expr1" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HS_VHCanal" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="r_DonneesImport2.SommeDeHS_Chantier" dbLong "AggregateType" ="-1" End Begin dbText "Name" ="HS_Chantier" dbLong "AggregateType" ="-1" End End Begin State =0 Left =0 Top =0 Right =797 Bottom =545 Left =-1 Top =-1 Right =781 Bottom =308 Left =0 Top =0 ColumnsShown =539 Begin Left =339 Top =12 Right =579 Bottom =344 Top =0 Name ="tbl_FormDep" Name ="" End Begin Left =48 Top =12 Right =262 Bottom =254 Top =0 Name ="r_DonneesImport2" Name ="" End End