Operation =1
Option =0
Begin InputTables
    Name ="tbl_ad"
    Name ="qry_Solarcheck2_Termine_MonatJahr_RL"
    Name ="qry_Solarcheck4_AnzahlADRegion"
    Name ="qry_Solarcheck2_Abschluesse_MonatJahr_RL"
    Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL"
End
Begin OutputColumns
    Expression ="tbl_ad.AD"
    Expression ="tbl_ad.Vorname"
    Expression ="tbl_ad.Name"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter"
    Expression ="qry_Solarcheck4_AnzahlADRegion.[Anzahl AD in Region]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.[Monat Jahr]"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.Termine"
    Expression ="qry_Solarcheck2_Abschluesse_MonatJahr_RL.[Anzahl Abschluss]"
    Alias ="Quote"
    Expression ="IIf([Anzahl Abschluss] Is Not Null,[Anzahl Abschluss]/[Termine],0)"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.Vertragseingang"
    Alias ="Vertragseingang %"
    Expression ="IIf([Vertragseingang]>0,[Vertragseingang]/[Termine],0)"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.[Storno Kunde]"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.[Storno Kunde %]"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.KW"
    Expression ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.[KW provisionsfähig]"
End
Begin Joins
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="tbl_ad"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter = tbl_ad.ID"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="qry_Solarcheck4_AnzahlADRegion"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter = qry_Solarcheck4_Anzah"
        "lADRegion.idad_regionalleiter"
    Flag =1
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="qry_Solarcheck2_Abschluesse_MonatJahr_RL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter = qry_Solarcheck2_Absch"
        "luesse_MonatJahr_RL.idad_regionalleiter"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="qry_Solarcheck2_Abschluesse_MonatJahr_RL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.[Monat Jahr] = qry_Solarcheck2_Abschluesse_"
        "MonatJahr_RL.[Monat Jahr]"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter = qry_Solarcheck5_Vertr"
        "aegeSST_MonatJAhr_RL.idad_regionalleiter"
    Flag =2
    LeftTable ="qry_Solarcheck2_Termine_MonatJahr_RL"
    RightTable ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL"
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.[Monat Jahr] = qry_Solarcheck5_VertraegeSST"
        "_MonatJAhr_RL.[Monat Jahr]"
    Flag =2
End
Begin OrderBy
    Expression ="qry_Solarcheck2_Termine_MonatJahr_RL.[Monat Jahr]"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
Begin
    Begin
        dbText "Name" ="Quote"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="0"
        dbInteger "ColumnWidth" ="705"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="Vertragseingang %"
        dbInteger "ColumnWidth" ="1830"
        dbBoolean "ColumnHidden" ="0"
        dbText "Format" ="Percent"
        dbByte "DecimalPlaces" ="2"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_RL.idad_regionalleiter"
        dbInteger "ColumnWidth" ="1500"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Abschluesse_MonatJahr_RL.[Anzahl Abschluss]"
        dbInteger "ColumnWidth" ="1755"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_RL.[Monat Jahr]"
        dbInteger "ColumnWidth" ="1140"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck2_Termine_MonatJahr_RL.Termine"
        dbInteger "ColumnWidth" ="870"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.[Storno Kunde]"
        dbInteger "ColumnWidth" ="1365"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL.KW"
        dbInteger "ColumnWidth" ="1230"
        dbBoolean "ColumnHidden" ="0"
    End
    Begin
        dbText "Name" ="tbl_ad.AD"
        dbInteger "ColumnWidth" ="2160"
        dbBoolean "ColumnHidden" ="0"
    End
End
Begin
    State =2
    Left =-6
    Top =-32
    Right =1922
    Bottom =1003
    Left =-1
    Top =-1
    Right =1637
    Bottom =417
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =248
        Top =174
        Right =344
        Bottom =288
        Top =4
        Name ="tbl_ad"
        Name =""
    End
    Begin
        Left =66
        Top =9
        Right =459
        Bottom =108
        Top =0
        Name ="qry_Solarcheck2_Termine_MonatJahr_RL"
        Name =""
    End
    Begin
        Left =375
        Top =142
        Right =682
        Bottom =226
        Top =0
        Name ="qry_Solarcheck4_AnzahlADRegion"
        Name =""
    End
    Begin
        Left =620
        Top =7
        Right =892
        Bottom =106
        Top =0
        Name ="qry_Solarcheck2_Abschluesse_MonatJahr_RL"
        Name =""
    End
    Begin
        Left =855
        Top =144
        Right =1332
        Bottom =258
        Top =0
        Name ="qry_Solarcheck5_VertraegeSST_MonatJAhr_RL"
        Name =""
    End
End
