Operation =1
Option =0
Begin InputTables
    Name ="ocvertrag_ocv"
    Name ="ocvertragstatus_ocs"
    Name ="tbl_tarifepos"
End
Begin OutputColumns
    Expression ="ocvertragstatus_ocs.vertragstatus"
    Alias ="Anzahl"
    Expression ="Count(ocvertragstatus_ocs.vertragstatus)"
    Alias ="Provision abzgl HW Kosten bei Bundle"
    Expression ="Sum(tbl_tarifepos.ProvGesamt)"
    Alias ="Provision AD"
    Expression ="Sum(tbl_tarifepos.Provision5)"
End
Begin Joins
    LeftTable ="ocvertrag_ocv"
    RightTable ="ocvertragstatus_ocs"
    Expression ="ocvertrag_ocv.vertragstatus_ocv = ocvertragstatus_ocs.id_ocvertragstatus"
    Flag =1
    LeftTable ="ocvertrag_ocv"
    RightTable ="tbl_tarifepos"
    Expression ="ocvertrag_ocv.idpos_ocv = tbl_tarifepos.ID"
    Flag =1
End
Begin Groups
    Expression ="ocvertrag_ocv.vertragstatus_ocv"
    GroupLevel =0
    Expression ="ocvertragstatus_ocs.vertragstatus"
    GroupLevel =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="ocvertragstatus_ocs.vertragstatus"
        dbInteger "ColumnWidth" ="3000"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="anzahl"
        dbInteger "ColumnWidth" ="750"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Provision abzgl HW Kosten bei Bundle"
        dbInteger "ColumnWidth" ="3525"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="#,##0.00 €;-#,##0.00 €"
        dbByte "DecimalPlaces" ="0"
    End
    Begin
        dbText "Name" ="Provision AD"
        dbInteger "ColumnWidth" ="1290"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="#,##0.00 €;-#,##0.00 €"
        dbByte "DecimalPlaces" ="0"
    End
End
Begin
    State =2
    Left =-4
    Top =-30
    Right =2560
    Bottom =1243
    Left =-1
    Top =-1
    Right =2553
    Bottom =145
    Left =0
    Top =0
    ColumnsShown =543
    Begin
        Left =38
        Top =6
        Right =134
        Bottom =120
        Top =1
        Name ="ocvertrag_ocv"
        Name =""
    End
    Begin
        Left =172
        Top =6
        Right =268
        Bottom =90
        Top =0
        Name ="ocvertragstatus_ocs"
        Name =""
    End
    Begin
        Left =306
        Top =6
        Right =402
        Bottom =120
        Top =10
        Name ="tbl_tarifepos"
        Name =""
    End
End
