Abrechnung} TPF0 TDataSource Datasource1TagDataSetQuery1TPF0 TQRDWQueryQuery1TagActive ConnectionDMWK.ADOConnection1 CursorTypectStatic Parameters SQL.StringsSELECT Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr, Raenge.Rang, Raenge.HauptErg, Raenge.Einheit, Wettb_def.Titel, CDbl([betrag]) AS GeldBetrag, preise.geldpreis, preise.rangvon, preise.rangbisFROM (Verein INNER JOIN (Starter INNER JOIN (Wettb_def INNER JOIN Raenge ON Wettb_def.ID = Raenge.ErglistID) ON Starter.Startnr = Raenge.Startnr) ON Verein.Vereinsnr = Starter.Vereinsnr) INNER JOIN preise ON Wettb_def.ID = preise.idqWHERE (((preise.geldpreis)=True) AND ((preise.rangvon)<=[Raenge]![Rang]) AND ((preise.rangbis)>=[Raenge]![Rang]))IORDER BY Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr; RequestLiveOriginalSQL.StringsSELECT Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr, Raenge.Rang, Raenge.HauptErg, Raenge.Einheit, Wettb_def.Titel, CDbl([betrag]) AS GeldBetrag, preise.geldpreis, preise.rangvon, preise.rangbisFROM (Verein INNER JOIN (Starter INNER JOIN (Wettb_def INNER JOIN Raenge ON Wettb_def.ID = Raenge.ErglistID) ON Starter.Startnr = Raenge.Startnr) ON Verein.Vereinsnr = Starter.Vereinsnr) INNER JOIN preise ON Wettb_def.ID = preise.idqWHERE (((preise.geldpreis)=True) AND ((preise.rangvon)<=[Raenge]![Rang]) AND ((preise.rangbis)>=[Raenge]![Rang]))IORDER BY Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr;TWideStringField FieldNameNameSize<TWideStringField FieldNameNachnameSizeTWideStringField FieldNameVornameTSmallintField FieldNameRang TFloatField FieldNameHauptErgTWideStringField FieldNameEinheitSizeTWideStringField FieldNameTitelSize2 TFloatField FieldName GeldBetragReadOnly TBooleanField FieldName geldpreis TIntegerField FieldNamerangvon TIntegerField FieldNamerangbis TIntegerField FieldNameStartnrTPF0 TADOCommand CommandText SELECT Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr, Raenge.Rang, Raenge.HauptErg, Raenge.Einheit, Wettb_def.Titel, CDbl([betrag]) AS GeldBetrag, preise.geldpreis, preise.rangvon, preise.rangbis FROM (Verein INNER JOIN (Starter INNER JOIN (Wettb_def INNER JOIN Raenge ON Wettb_def.ID = Raenge.ErglistID) ON Starter.Startnr = Raenge.Startnr) ON Verein.Vereinsnr = Starter.Vereinsnr) INNER JOIN preise ON Wettb_def.ID = preise.id WHERE (((preise.geldpreis)=True) AND ((preise.rangvon)<=[Raenge]![Rang]) AND ((preise.rangbis)>=[Raenge]![Rang])) ORDER BY Verein.Name, Starter.Nachname, Starter.Vorname, Starter.Startnr; ConnectionDMWK.ADOConnection1 Parametersl@@ @@@@ @ AbrechnungdGruppe=Auszahlung/Beschreibung= Preisgelder je Verein aufsummiert Arial QuickReportTPF0 TQRDesignBand DetailbandLeft&TopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.ValuesUUUUUU@v @BandTyperbDetail EditorEnabled QRDesigner QRepDesigner1BandNumTQRDesignDBText QRDBText3LeftTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@@UUUUUUU@ @ AlignmenttaRightJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldRang TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignDBText QRDBText4LeftsTopWidth'Height Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@f@`@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldHauptErgMask####0.0 TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignDBText QRDBText5LeftHTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@@8@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldTitel TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignDBTextLeftTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@ @@@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldEinheit TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignDBTextLeftTopWidthBHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@ @@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataField GeldBetragMask ###0.00 DM TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignLabelLeft'TopWidth=Height Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@UUUUUU!@UUUUUUU@UUUUUUe@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchCaption . Rang mitColorclWhite TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TPF0 TQRDesignBand PageheaderLeft&Top&WidthHeight6 Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.Values@v @BandType rbPageHeader EditorEnabled QRDesigner QRepDesigner1BandNumTPF0 TQRDesignBand TitlebandLeft&Top\WidthHeight2 Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.ValuesJ@v @BandTyperbTitle EditorEnabled QRDesigner QRepDesigner1BandNumTQRDesignLabel QRLabel10LeftTopWidthuHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@@@VUUUUU@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchCaption Auszahlungsliste fr die VereineColorclWhite Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBold ParentFont TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSizeTPF0TQRDesignGroupBAND1Left&TopWidthHeight( Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.Values@v @ Expression Query1.Name FooterBandBAND2Master QuickReportReprintOnNewPage EditorEnabled BandNum QRDesigner QRepDesigner1TQRDesignDBTextLeftTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.ValuesUUUUUU@UUUUUUU@UUUUUUU@UUUUUU @ Alignment taLeftJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldName Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBoldfsItalic fsUnderline ParentFont TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TPF0 TQRDesignBandBAND2Left&Top WidthHeight( Frame.ColorclBlack Frame.DrawTopFrame.DrawBottom Frame.DrawLeftFrame.DrawRight Frame.Width AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.Values@v @BandType rbGroupFooter EditorEnabled QRDesigner QRepDesigner1BandNum TQRDesignExprLeft$TopWidthkHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@UUUUUU= @UUUUUUU@UUUUUU@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretch Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBold fsUnderlineColorclWhite ParentFontResetAfterPrint TransparentWordWrap Expressionsum(GeldBetrag)Mask ####0.00 DM QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignDBTextLeftdTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@z@UUUUUUU@UUUUUU@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretchColorclWhiteDataSetQuery1 DataFieldName Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBold fsUnderline ParentFont TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TPF0 TQRDesignBandLeft&TopWidthHeight2 Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.ValuesJ@v @BandType rbPageFooter EditorEnabled QRDesigner QRepDesigner1BandNumTQRDesignLabelARLIZLeftTopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@UUUUUUU@@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchCaption7Lizenziert fr Schieen des Lizenznehmers Stein, RainerColorclWhite Font.CharsetDEFAULT_CHARSET Font.ColorclBlack Font.Height Font.NameArial Font.Style ParentFont TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSizeTPF0TQRDesignGroupBAND3Left&TopWidthHeight Frame.ColorclBlack Frame.DrawTop Frame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.Values*@v @ ExpressionQuery1.Startnr FooterBandBAND4Master QuickReportReprintOnNewPage EditorEnabled BandNum QRDesigner QRepDesigner1 TQRDesignExprLeft,TopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@VUUUUU@UUUUUUU@̘@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchColorclWhiteResetAfterPrint TransparentWordWrap Expression"Query1.Nachname+' '+Query1.Vorname QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TPF0 TQRDesignBandBAND4Left&TopWidthHeight( Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.Values@v @BandType rbGroupFooter EditorEnabled QRDesigner QRepDesigner1BandNum TQRDesignExprLeftTopWidthkHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@ؒ @UUUUUUU@UUUUUU@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretch Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBold fsUnderlineColorclWhite ParentFontResetAfterPrint TransparentWordWrap Expressionsum(GeldBetrag)Mask ####0.00 DM QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TPF0 TQRDesignBandBAND5Left&Top5WidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight AlignToBottomColorclWhiteForceNewColumn ForceNewPage Size.ValuesUUUUUUU@v @BandType rbSummary EditorEnabled QRDesigner QRepDesigner1BandNum TQRDesignExprLeft TopWidthkHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@ @UUUUUUU@UUUUUU@ AlignmenttaRightJustify AlignToBandAutoSize AutoStretch Font.CharsetDEFAULT_CHARSET Font.Color clWindowText Font.Height Font.NameArial Font.Style fsBold fsUnderlineColorclWhite ParentFontResetAfterPrint TransparentWordWrap Expressionsum(GeldBetrag)Mask ####0.00 DM QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize TQRDesignLabelLeft\TopWidthHeight Frame.ColorclBlack Frame.DrawTopFrame.DrawBottomFrame.DrawLeftFrame.DrawRight Size.Values@0@UUUUUUU@@ Alignment taLeftJustify AlignToBandAutoSize AutoStretchCaptionGesamte Auszahlungssumme:ColorclWhite TransparentWordWrap QRDesigner QRepDesigner1FixBottomPositionStretchHeightWithBandFontSize