object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.DS_SchuelerDaten PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Leistungs'#252'bersicht_HJ_waehlbar_1.rtm' PrinterSetup.Duplex = dpHorizontal PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 13000 PrinterSetup.mmMarginRight = 13000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\ASGSG-Reports\ab_2014\Leistungs'#252'ber' + 'sichten\Leistungs'#252'bersicht_HJ_waehlbar_1.rtm' Template.Format = ftASCII Units = utMillimeters AllowPrintToArchive = True AllowPrintToFile = True ArchiveFileName = '($MyDocuments)\ReportArchive.raf' DeviceType = 'Screen' DefaultFileDeviceType = 'PDF' EmailSettings.ReportFormat = 'PDF' EmailSettings.DeleteFile = False EmailSettings.Enabled = True LanguageID = 'Default' OpenFile = False OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = False ThumbnailSettings.Enabled = True ThumbnailSettings.Visible = True ThumbnailSettings.DeadSpace = 30 PDFSettings.EmbedFontOptions = [] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.EncryptSettings.KeyLength = kl40Bit PDFSettings.FontEncoding = feAnsi PDFSettings.ImageCompressionLevel = 25 PreviewFormSettings.ZoomSetting = zs100Percent PreviewFormSettings.SinglePageOnly = True RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] ShowAutoSearchDialog = True TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'ReportBuilder' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 175000 DataPipelineName = 'DS_SchuelerDaten' object ppHeaderBand2: TppHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 8731 mmPrintPosition = 0 object ppShape1: TppShape UserName = 'Sh_Name' Pen.Style = psClear mmHeight = 6688 mmLeft = 5027 mmTop = 794 mmWidth = 27781 BandType = 4 LayerName = Foreground end object ppShape16: TppShape UserName = 'ShapeBackSperre1' Brush.Color = clGray Brush.Style = bsBDiagonal mmHeight = 6615 mmLeft = 76720 mmTop = 529 mmWidth = 8930 BandType = 4 LayerName = Foreground end object ppSubReport1: TppSubReport UserName = 'SubReportHJ1FG1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' mmHeight = 6615 mmLeft = 41540 mmTop = 529 mmWidth = 34131 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False Columns = 4 ColumnPositions.Strings = ( '0' '8500' '17000' '25500') DataPipeline = daADOQueryDataView2.DS_SchuelerLeistungenHJ1FG1 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'HGG - Liste - Klassen'#252'bersicht mit Versetzungsentscheidungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 176000 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 8500 DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' object ppColumnHeaderBand1: TppColumnHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand3: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear ColumnTraversal = ctLeftToRight mmBottomOffset = 0 mmHeight = 6500 mmPrintPosition = 0 object ppShape9: TppShape UserName = 'ShapeBack' ParentHeight = True ParentWidth = True mmHeight = 6500 mmLeft = 0 mmTop = 0 mmWidth = 8500 BandType = 4 LayerName = Foreground1 end object ppDBText3: TppDBText UserName = 'DBTextFach' DataField = 'FachKrz' DataPipeline = daADOQueryDataView2.DS_SchuelerLeistungenHJ1FG1 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' mmHeight = 3260 mmLeft = 0 mmTop = 0 mmWidth = 4500 BandType = 4 LayerName = Foreground1 end object ppDBText4: TppDBText UserName = 'DBTextNote' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView2.DS_SchuelerLeistungenHJ1FG1 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 10 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' mmHeight = 4106 mmLeft = 4500 mmTop = 1058 mmWidth = 3750 BandType = 4 LayerName = Foreground1 end object ppDBText1: TppDBText UserName = 'DBTextLehrer' DataField = 'FachLehrer' DataPipeline = daADOQueryDataView2.DS_SchuelerLeistungenHJ1FG1 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' mmHeight = 2879 mmLeft = 0 mmTop = 3440 mmWidth = 4500 BandType = 4 LayerName = Foreground1 end end object ppColumnFooterBand1: TppColumnFooterBand AlignToBottom = True Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule2: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650CD401000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A566172200D0A2020734E6F74 65203A20537472696E673B0D0A0D0A626567696E0D0A20200D0A2020734E6F74 65203A3D2044535F53636875656C65724C65697374756E67656E484A31464731 5B274E6F74656E4B727A275D3B0D0A20200D0A20204442546578744E6F74652E 436F6C6F72203A3D20636C57686974653B0D0A20204442546578744E6F74652E 5472616E73706172656E743A3D20547275653B0D0A202053686170654261636B 2E42727573682E436F6C6F723A3D20636C77686974653B0D0A20200D0A202020 0D0A2020496620734E6F7465203C3E202727205468656E0D0A20202020426567 696E200D0A202020202020496620706F7328734E6F74652C27312B23312D2729 203E2030205468656E2053686170654261636B2E42727573682E436F6C6F723A 3D2069436F6C417573676C656963683B0D0A2020202020204966202828734E6F 7465203D2027342D2729206F722028706F7328734E6F74652C27352B23352D23 362729203E20302929205468656E2053686170654261636B2E42727573682E43 6F6C6F72203A3D2069436F6C446566697A69743B0D0A20202020456E643B2020 0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C 094576656E744E616D65060B4265666F72655072696E74074576656E74494402 18084361726574506F730102050214000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end end end object ppSubReport2: TppSubReport UserName = 'SubReportHJ1FG2' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' mmHeight = 6615 mmLeft = 97367 mmTop = 529 mmWidth = 65881 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport2: TppChildReport AutoStop = False Columns = 9 ColumnPositions.Strings = ( '0' '8500' '17000' '25500' '34000' '42500' '51000' '59500' '68000') DataPipeline = daADOQueryDataView3.DS_SchuelerLeistungenHJ1FG2 PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'HGG - Liste - Klassen'#252'bersicht mit Versetzungsentscheidungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 133500 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 8500 DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' object ppColumnHeaderBand2: TppColumnHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand4: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear ColumnTraversal = ctLeftToRight mmBottomOffset = 0 mmHeight = 6500 mmPrintPosition = 0 object ppShape3: TppShape UserName = 'ShapeBack' ParentHeight = True ParentWidth = True mmHeight = 6500 mmLeft = 0 mmTop = 0 mmWidth = 8500 BandType = 4 LayerName = Foreground2 end object ppDBText5: TppDBText UserName = 'DBTextFach' DataField = 'FachKrz' DataPipeline = daADOQueryDataView3.DS_SchuelerLeistungenHJ1FG2 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' mmHeight = 3260 mmLeft = 0 mmTop = 0 mmWidth = 7415 BandType = 4 LayerName = Foreground2 end object ppDBText7: TppDBText UserName = 'DBTextNote' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView3.DS_SchuelerLeistungenHJ1FG2 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 10 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' mmHeight = 3576 mmLeft = 4500 mmTop = 2648 mmWidth = 3750 BandType = 4 LayerName = Foreground2 end object ppDBText8: TppDBText UserName = 'DBTextLehrer' DataField = 'FachLehrer' DataPipeline = daADOQueryDataView3.DS_SchuelerLeistungenHJ1FG2 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' mmHeight = 2879 mmLeft = 0 mmTop = 3440 mmWidth = 4500 BandType = 4 LayerName = Foreground2 end end object ppColumnFooterBand2: TppColumnFooterBand AlignToBottom = True Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule3: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650CD401000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A566172200D0A2020734E6F74 65203A20537472696E673B0D0A0D0A626567696E0D0A20200D0A2020734E6F74 65203A3D2044535F53636875656C65724C65697374756E67656E484A31464732 5B274E6F74656E4B727A275D3B0D0A20200D0A20204442546578744E6F74652E 436F6C6F72203A3D20636C57686974653B0D0A20204442546578744E6F74652E 5472616E73706172656E743A3D20547275653B0D0A202053686170654261636B 2E42727573682E436F6C6F723A3D20636C77686974653B0D0A20200D0A202020 0D0A2020496620734E6F7465203C3E202727205468656E0D0A20202020426567 696E200D0A202020202020496620706F7328734E6F74652C27312B23312D2729 203E2030205468656E2053686170654261636B2E42727573682E436F6C6F723A 3D2069436F6C417573676C656963683B0D0A2020202020204966202828734E6F 7465203D2027342D2729206F722028706F7328734E6F74652C27352B23352D23 362729203E20302929205468656E2053686170654261636B2E42727573682E43 6F6C6F72203A3D2069436F6C446566697A69743B0D0A20202020456E643B2020 0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C 094576656E744E616D65060B4265666F72655072696E74074576656E74494402 18084361726574506F730102050214000000} end object ppDesignLayers3: TppDesignLayers object ppDesignLayer3: TppDesignLayer UserName = 'Foreground2' LayerType = ltBanded Index = 0 end end end end object ppSubReport5: TppSubReport UserName = 'SubReportHJ1EP' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' mmHeight = 6615 mmLeft = 76720 mmTop = 529 mmWidth = 19315 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport5: TppChildReport AutoStop = False Columns = 2 ColumnPositions.Strings = ( '0' '8500') DataPipeline = daADOQueryDataView6.DS_SchuelerLeistungenHJ1EP PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'HGG - Liste - Klassen'#252'bersicht mit Versetzungsentscheidungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 193000 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 8500 DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' object ppColumnHeaderBand5: TppColumnHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand7: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear ColumnTraversal = ctLeftToRight mmBottomOffset = 0 mmHeight = 6500 mmPrintPosition = 0 object ppShape7: TppShape UserName = 'ShapeBack' ParentHeight = True ParentWidth = True mmHeight = 6500 mmLeft = 0 mmTop = 0 mmWidth = 8500 BandType = 4 LayerName = Foreground3 end object ppDBText14: TppDBText UserName = 'DBTextFach' DataField = 'FachKrz' DataPipeline = daADOQueryDataView6.DS_SchuelerLeistungenHJ1EP Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' mmHeight = 3260 mmLeft = 0 mmTop = 0 mmWidth = 4500 BandType = 4 LayerName = Foreground3 end object ppDBText15: TppDBText UserName = 'DBTextNote' DataField = 'NotenKrz' DataPipeline = daADOQueryDataView6.DS_SchuelerLeistungenHJ1EP Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 10 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' mmHeight = 4106 mmLeft = 4500 mmTop = 1058 mmWidth = 3750 BandType = 4 LayerName = Foreground3 end object ppDBText16: TppDBText UserName = 'DBTextLehrer' DataField = 'FachLehrer' DataPipeline = daADOQueryDataView6.DS_SchuelerLeistungenHJ1EP Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' mmHeight = 2879 mmLeft = 0 mmTop = 3440 mmWidth = 4500 BandType = 4 LayerName = Foreground3 end end object ppColumnFooterBand5: TppColumnFooterBand AlignToBottom = True Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule6: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650CD301000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A566172200D0A2020734E6F74 65203A20537472696E673B0D0A0D0A626567696E0D0A20200D0A2020734E6F74 65203A3D2044535F53636875656C65724C65697374756E67656E484A3145505B 274E6F74656E4B727A275D3B0D0A20200D0A20204442546578744E6F74652E43 6F6C6F72203A3D20636C57686974653B0D0A20204442546578744E6F74652E54 72616E73706172656E743A3D20547275653B0D0A202053686170654261636B2E 42727573682E436F6C6F723A3D20636C77686974653B0D0A20200D0A2020200D 0A2020496620734E6F7465203C3E202727205468656E0D0A2020202042656769 6E200D0A202020202020496620706F7328734E6F74652C27312B23312D272920 3E2030205468656E2053686170654261636B2E42727573682E436F6C6F723A3D 2069436F6C417573676C656963683B0D0A2020202020204966202828734E6F74 65203D2027342D2729206F722028706F7328734E6F74652C27352B23352D2336 2729203E20302929205468656E2053686170654261636B2E42727573682E436F 6C6F72203A3D2069436F6C446566697A69743B0D0A20202020456E643B20200D 0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C09 4576656E744E616D65060B4265666F72655072696E74074576656E7449440218 084361726574506F730102050214000000} end object ppDesignLayers4: TppDesignLayers object ppDesignLayer4: TppDesignLayer UserName = 'Foreground3' LayerType = ltBanded Index = 0 end end end end object ppSubReport8: TppSubReport UserName = 'SubReportHJ1ErgStd' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'DS_SchuelerFoerderung1HJ' mmHeight = 6615 mmLeft = 163776 mmTop = 529 mmWidth = 20000 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport8: TppChildReport AutoStop = False Columns = 2 ColumnPositions.Strings = ( '0' '10000') DataPipeline = daADOQueryDataView17.DS_SchuelerFoerderung1HJ PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'HGG - Liste - Klassen'#252'bersicht mit Versetzungsentscheidungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 190000 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 10000 DataPipelineName = 'DS_SchuelerFoerderung1HJ' object ppColumnHeaderBand3: TppColumnHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand10: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear ColumnTraversal = ctLeftToRight mmBottomOffset = 0 mmHeight = 6500 mmPrintPosition = 0 object ppShape14: TppShape UserName = 'ShapeBack' ParentHeight = True ParentWidth = True mmHeight = 6500 mmLeft = 0 mmTop = 0 mmWidth = 10000 BandType = 4 LayerName = Foreground4 end object ppDBText23: TppDBText UserName = 'DBTextFach' DataField = 'FachKrz' DataPipeline = daADOQueryDataView17.DS_SchuelerFoerderung1HJ Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerFoerderung1HJ' mmHeight = 3260 mmLeft = 0 mmTop = 0 mmWidth = 9790 BandType = 4 LayerName = Foreground4 end object ppDBText24: TppDBText UserName = 'DBTextNote' Color = clWindow DataField = 'NotenKrz' DataPipeline = daADOQueryDataView17.DS_SchuelerFoerderung1HJ Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerFoerderung1HJ' mmHeight = 3302 mmLeft = 0 mmTop = 2910 mmWidth = 5292 BandType = 4 LayerName = Foreground4 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'FachLehrer' DataPipeline = daADOQueryDataView17.DS_SchuelerFoerderung1HJ Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial Narrow' Font.Size = 6 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'DS_SchuelerFoerderung1HJ' mmHeight = 5556 mmLeft = 5821 mmTop = 2910 mmWidth = 3969 BandType = 4 LayerName = Foreground4 end end object ppColumnFooterBand3: TppColumnFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule9: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650CD101000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A566172200D0A2020734E6F74 65203A20537472696E673B0D0A0D0A626567696E0D0A20200D0A2020734E6F74 65203A3D2044535F53636875656C6572466F6572646572756E6731484A5B274E 6F74656E4B727A275D3B0D0A20200D0A20204442546578744E6F74652E436F6C 6F72203A3D20636C57686974653B0D0A20204442546578744E6F74652E547261 6E73706172656E743A3D20547275653B0D0A202053686170654261636B2E4272 7573682E436F6C6F723A3D20636C77686974653B0D0A20200D0A2020200D0A20 20496620734E6F7465203C3E202727205468656E0D0A20202020426567696E20 0D0A202020202020496620706F7328734E6F74652C27312B23312D2729203E20 30205468656E2053686170654261636B2E42727573682E436F6C6F723A3D2069 436F6C417573676C656963683B0D0A2020202020204966202828734E6F746520 3D2027342D2729206F722028706F7328734E6F74652C27352B23352D23362729 203E20302929205468656E2053686170654261636B2E42727573682E436F6C6F 72203A3D2069436F6C446566697A69743B0D0A20202020456E643B20200D0A0D 0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C094576 656E744E616D65060B4265666F72655072696E74074576656E74494402180843 61726574506F730102050214000000} end object ppDesignLayers5: TppDesignLayers object ppDesignLayer5: TppDesignLayer UserName = 'Foreground4' LayerType = ltBanded Index = 0 end end end end object ppSubReport6: TppSubReport UserName = 'SubReportFehlStd1HJ' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentPrinterSetup = False ParentWidth = False TraverseAllData = False DataPipelineName = 'DS_SchuelerAbschnitt1HJ' mmHeight = 6615 mmLeft = 33867 mmTop = 529 mmWidth = 6615 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport6: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView7.DS_SchuelerAbschnitt1HJ PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'HGG - 2HJ-S1 - P3 - Leistungs'#252'bersichten.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 0 PrinterSetup.mmMarginLeft = 0 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 0 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Offset = 284 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'DS_SchuelerAbschnitt1HJ' object ppDetailBand8: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6500 mmPrintPosition = 0 object ppDBText18: TppDBText UserName = 'DBText2' Color = clGray DataField = 'SumFehlStdU' DataPipeline = daADOQueryDataView7.DS_SchuelerAbschnitt1HJ Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered DataPipelineName = 'DS_SchuelerAbschnitt1HJ' mmHeight = 3600 mmLeft = 0 mmTop = 3144 mmWidth = 6000 BandType = 4 LayerName = Foreground5 end object ppDBText17: TppDBText UserName = 'DBText1' Color = clGray DataField = 'SumFehlStd' DataPipeline = daADOQueryDataView7.DS_SchuelerAbschnitt1HJ Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [fsBold] TextAlignment = taCentered DataPipelineName = 'DS_SchuelerAbschnitt1HJ' mmHeight = 3429 mmLeft = 0 mmTop = 0 mmWidth = 6000 BandType = 4 LayerName = Foreground5 end end object raCodeModule7: TraCodeModule ProgramStream = {00} end object ppDesignLayers6: TppDesignLayers object ppDesignLayer6: TppDesignLayer UserName = 'Foreground5' LayerType = ltBanded Index = 0 end end end end object ppDBText2: TppDBText UserName = 'DBTextName' DataField = 'Name' DataPipeline = daADOQueryDataView1.DS_SchuelerDaten Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'DS_SchuelerDaten' mmHeight = 3959 mmLeft = 5821 mmTop = 264 mmWidth = 26988 BandType = 4 LayerName = Foreground end object ppDBText26: TppDBText UserName = 'DBTextVorname' DataField = 'Vorname' DataPipeline = daADOQueryDataView1.DS_SchuelerDaten Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'DS_SchuelerDaten' mmHeight = 3959 mmLeft = 5821 mmTop = 3704 mmWidth = 26988 BandType = 4 LayerName = Foreground end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DisplayFormat = '0"."' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount mmHeight = 3959 mmLeft = 265 mmTop = 264 mmWidth = 4182 BandType = 4 LayerName = Foreground end object ppRegion3: TppRegion UserName = 'RegionAbschlusslinie' Brush.Style = bsClear ParentWidth = True Pen.Style = psClear Stretch = True Transparent = True mmHeight = 1852 mmLeft = 0 mmTop = 6879 mmWidth = 184000 BandType = 4 LayerName = Foreground mmBottomOffset = 700 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppLine1: TppLine UserName = 'Line1' ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 6879 mmWidth = 184000 BandType = 4 LayerName = Foreground end end end object ppGroup2: TppGroup BreakName = 'Abschnitt' DataPipeline = daADOQueryDataView1.DS_SchuelerDaten GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'DS_SchuelerDaten' NewFile = False object ppGroupHeaderBand2: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand2: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup1: TppGroup BreakName = 'Klasse_2' DataPipeline = daADOQueryDataView1.DS_SchuelerDaten GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True ResetPageNo = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'DS_SchuelerDaten' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 19579 mmPrintPosition = 0 object ppSystemVariable3: TppSystemVariable UserName = 'SystemVariableSeiten' AutoSize = False VarType = vtPageNo Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 3228 mmLeft = 794 mmTop = 7673 mmWidth = 182827 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppShape5: TppShape UserName = 'Shape5' Brush.Color = clGray ParentWidth = True Pen.Color = clGray mmHeight = 6350 mmLeft = 0 mmTop = 0 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel37: TppLabel UserName = 'LabelHeader' AutoSize = False Border.Weight = 1.250000000000000000 Caption = 'Leistungen' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 5430 mmLeft = 0 mmTop = 265 mmWidth = 183886 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'LabelKL' AutoSize = False Caption = 'LabelKL' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Arial Narrow' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3959 mmLeft = 794 mmTop = 7408 mmWidth = 80000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLine12: TppLine UserName = 'Line12' Pen.Width = 2 ParentWidth = True Position = lpBottom Weight = 1.250000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 11642 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLine16: TppLine UserName = 'Line16' Pen.Width = 2 ParentWidth = True Position = lpBottom Weight = 1.250000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 5292 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLine17: TppLine UserName = 'Line17' Pen.Width = 2 ParentWidth = True Weight = 1.250000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 0 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppShape6: TppShape UserName = 'Shape6' Brush.Color = clGray ParentWidth = True Pen.Color = clGray mmHeight = 6615 mmLeft = 0 mmTop = 12700 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Caption = 'Name' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 5821 mmTop = 15875 mmWidth = 26988 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'F'#228'chergruppe I' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 41540 mmTop = 15875 mmWidth = 34131 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Caption = 'F'#228'chergruppe II' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 2910 mmLeft = 94721 mmTop = 15875 mmWidth = 68263 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel11: TppLabel UserName = 'Label101' AutoSize = False Caption = 'FSU' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 33867 mmTop = 15875 mmWidth = 6615 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel13: TppLabel UserName = 'Label13' AutoSize = False Caption = 'FSG' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 33867 mmTop = 13229 mmWidth = 6615 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel14: TppLabel UserName = 'LabelErgStd1' AutoSize = False Caption = 'Erg'#228'nz.' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 163777 mmTop = 13229 mmWidth = 20108 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel15: TppLabel UserName = 'LabelErgStd2' AutoSize = False Caption = 'Std.' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 163777 mmTop = 15875 mmWidth = 20108 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel16: TppLabel UserName = 'Label16' AutoSize = False Caption = 'Epochen-' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 76729 mmTop = 13229 mmWidth = 11906 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel18: TppLabel UserName = 'Label18' AutoSize = False Caption = 'unterricht' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial Narrow' Font.Size = 7 Font.Style = [fsBold] Transparent = True VerticalAlignment = avCenter mmHeight = 2910 mmLeft = 76729 mmTop = 15875 mmWidth = 11906 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLine4: TppLine UserName = 'Line4' ParentWidth = True Position = lpBottom Weight = 0.500000000000000000 mmHeight = 1588 mmLeft = 0 mmTop = 17991 mmWidth = 184000 BandType = 3 GroupNo = 0 LayerName = Foreground end end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup3: TppGroup BreakName = 'ID' DataPipeline = daADOQueryDataView1.DS_SchuelerDaten GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group3' mmNewColumnThreshold = 0 mmNewPageThreshold = 10000 DataPipelineName = 'DS_SchuelerDaten' NewFile = False object ppGroupHeaderBand3: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand3: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_DS_SchuelerDaten' Height = 511 Left = 765 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 61 TypeColumnWidth = 52 Width = 296 AutoSearchTabOrder = 0 object DS_SchuelerDaten: TppChildDBPipeline AutoCreateFields = False UserName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'SchuelerLernabschnittsdaten' end object ppField4: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 3 TableName = 'SchuelerLernabschnittsdaten' end object ppField5: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 4 TableName = 'Schueler' end object ppField6: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 5 TableName = 'Schueler' end object ppField7: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 6 TableName = 'SchuelerLernabschnittsdaten' end object ppField8: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 7 TableName = 'SchuelerLernabschnittsdaten' end object ppField9: TppField FieldAlias = 'Folgeklasse' FieldName = 'Folgeklasse' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 8 TableName = 'SchuelerLernabschnittsdaten' end object ppField10: TppField FieldAlias = 'VersetzungKrz' FieldName = 'VersetzungKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 9 TableName = 'SchuelerLernabschnittsdaten' end object ppField11: TppField FieldAlias = 'MoeglNPFaecher' FieldName = 'MoeglNPFaecher' FieldLength = 0 IsDetail = True Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 10 TableName = 'SchuelerLernabschnittsdaten' end object ppField12: TppField FieldAlias = 'Wiederholung' FieldName = 'Wiederholung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 11 TableName = 'SchuelerLernabschnittsdaten' end object ppField13: TppField FieldAlias = 'Abschluss' FieldName = 'Abschluss' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 12 TableName = 'SchuelerLernabschnittsdaten' end object ppField14: TppField FieldAlias = 'KLKrz' FieldName = 'KlassenLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 13 TableName = 'SchuelerLernabschnittsdaten' end object ppField15: TppField FieldAlias = 'KLAnrede' FieldName = 'Anrede' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 14 TableName = 'K_Lehrer' end object ppField16: TppField FieldAlias = 'KLNachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 15 TableName = 'K_Lehrer' end object ppField17: TppField FieldAlias = 'KLVorname' FieldName = 'Vorname_2' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 16 TableName = 'K_Lehrer' end object ppField18: TppField FieldAlias = 'SKLKrz' FieldName = 'Kuerzel' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 17 TableName = 'K_Lehrer_2' end object ppField19: TppField FieldAlias = 'SKLAnrede' FieldName = 'Anrede_2' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 18 TableName = 'K_Lehrer_2' end object ppField20: TppField FieldAlias = 'SKLNachname' FieldName = 'Nachname_2' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 19 TableName = 'K_Lehrer_2' end object ppField21: TppField FieldAlias = 'SKLVorname' FieldName = 'Vorname_3' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 20 TableName = 'K_Lehrer_2' end object ppField22: TppField FieldAlias = 'Konferenzdatum' FieldName = 'Konferenzdatum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 21 TableName = 'SchuelerLernabschnittsdaten' end object ppField23: TppField FieldAlias = 'ZeugnisDatum' FieldName = 'ZeugnisDatum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 22 TableName = 'SchuelerLernabschnittsdaten' end object ppField24: TppField FieldAlias = 'Klasse (2)' FieldName = 'Klasse_2' FieldLength = 6 DisplayWidth = 6 Position = 23 TableName = 'Schueler' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerDaten' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.ID, Schueler.Status, ' ' SchuelerLernabschnittsdaten.Jahr, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' Schueler.Name, Schueler.Vorname, ' ' SchuelerLernabschnittsdaten.ASDJahrgang, ' ' SchuelerLernabschnittsdaten.Klasse, ' ' SchuelerLernabschnittsdaten.Folgeklasse, ' ' SchuelerLernabschnittsdaten.VersetzungKrz, ' ' SchuelerLernabschnittsdaten.MoeglNPFaecher, ' ' SchuelerLernabschnittsdaten.Wiederholung, ' ' SchuelerLernabschnittsdaten.Abschluss, ' ' SchuelerLernabschnittsdaten.KlassenLehrer, ' ' K_Lehrer.Anrede, K_Lehrer.Nachname, ' ' K_Lehrer.Vorname AS Vorname_2, ' ' K_Lehrer_2.Kuerzel, ' ' K_Lehrer_2.Anrede AS Anrede_2, ' ' K_Lehrer_2.Nachname AS Nachname_2, ' ' K_Lehrer_2.Vorname AS Vorname_3, ' ' SchuelerLernabschnittsdaten.Konferenzdatum, ' ' SchuelerLernabschnittsdaten.ZeugnisDatum, ' ' Schueler.Klasse AS Klasse_2' 'FROM ((((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' LEFT OUTER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = SchuelerLernabschnittsdaten.KlassenLehr' + 'er) )' ' LEFT OUTER JOIN K_Lehrer K_Lehrer_2 ON ' ' (K_Lehrer_2.ID = SchuelerLernabschnittsdaten.StvKlassenlehr' + 'er_ID) )' ' INNER JOIN EigeneSchule EigeneSchule ON ' ' (EigeneSchule.Schuljahr = SchuelerLernabschnittsdaten.Jahr)' + ' )' 'WHERE ' ' ( SchuelerLernabschnittsdaten.Abschnitt = 2 )' ' AND ( Schueler.Geloescht = '#39'-'#39' )' ' AND ( Schueler.Status IN (2) )' ' AND ( SchuelerLernabschnittsdaten.SemesterWertung = '#39'+'#39' )' ' AND ( Schueler.ASDJahrgang IN ('#39'05'#39','#39'06'#39','#39'07'#39','#39'08'#39','#39'09'#39','#39 + '10'#39') )' 'ORDER BY SchuelerLernabschnittsdaten.Abschnitt, ' ' Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '2' object TdaField Alias = 'Abschnitt' AutoSearch = True DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' Mandatory = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object TdaNumericValue Value = 2.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Klasse' object TdaField Alias = 'Klasse' AutoSearch = True DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' ShowAllValues = True SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Value = '-' object TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Status' Value = '2' object TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' Mandatory = True SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object TdaNumericValue Value = 2.000000000000000000 end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'SemesterWertung' DisplayWidth = 1 FieldAlias = 'SemesterWertung' FieldLength = 1 FieldName = 'SemesterWertung' SQLFieldName = 'SemesterWertung' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object daCriteria6: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '05,06,07,08,09,10' object TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField4: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField5: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField6: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField7: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' IsDetail = True SQLFieldName = 'ASDJahrgang' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField8: TdaField Alias = 'Klasse' DisplayWidth = 15 FieldAlias = 'Klasse' FieldLength = 15 FieldName = 'Klasse' IsDetail = True SQLFieldName = 'Klasse' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField9: TdaField Alias = 'Folgeklasse' DisplayWidth = 15 FieldAlias = 'Folgeklasse' FieldLength = 15 FieldName = 'Folgeklasse' IsDetail = True SQLFieldName = 'Folgeklasse' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField Alias = 'VersetzungKrz' DisplayWidth = 2 FieldAlias = 'VersetzungKrz' FieldLength = 2 FieldName = 'VersetzungKrz' IsDetail = True SQLFieldName = 'VersetzungKrz' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField11: TdaField Alias = 'MoeglNPFaecher' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'MoeglNPFaecher' FieldLength = 0 FieldName = 'MoeglNPFaecher' IsDetail = True Linkable = False SQLFieldName = 'MoeglNPFaecher' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField Alias = 'Wiederholung' DisplayWidth = 1 FieldAlias = 'Wiederholung' FieldLength = 1 FieldName = 'Wiederholung' IsDetail = True SQLFieldName = 'Wiederholung' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField13: TdaField Alias = 'Abschluss' DisplayWidth = 50 FieldAlias = 'Abschluss' FieldLength = 50 FieldName = 'Abschluss' IsDetail = True SQLFieldName = 'Abschluss' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField14: TdaField Alias = 'KLKrz' DisplayWidth = 10 FieldAlias = 'KlassenLehrer' FieldLength = 10 FieldName = 'KlassenLehrer' IsDetail = True SQLFieldName = 'KlassenLehrer' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField15: TdaField Alias = 'KLAnrede' DisplayWidth = 10 FieldAlias = 'Anrede' FieldLength = 10 FieldName = 'Anrede' IsDetail = True SQLFieldName = 'Anrede' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField16: TdaField Alias = 'KLNachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' IsDetail = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField17: TdaField Alias = 'KLVorname' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField18: TdaField Alias = 'SKLKrz' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' IsDetail = True SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer_2' end object daField19: TdaField Alias = 'SKLAnrede' DisplayWidth = 10 FieldAlias = 'Anrede' FieldLength = 10 FieldName = 'Anrede' IsDetail = True SQLFieldName = 'Anrede_2' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer_2' end object daField20: TdaField Alias = 'SKLNachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' IsDetail = True SQLFieldName = 'Nachname_2' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer_2' end object daField21: TdaField Alias = 'SKLVorname' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_3' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer_2' end object daField22: TdaField Alias = 'Konferenzdatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Konferenzdatum' FieldLength = 0 FieldName = 'Konferenzdatum' IsDetail = True SQLFieldName = 'Konferenzdatum' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField Alias = 'ZeugnisDatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'ZeugnisDatum' FieldLength = 0 FieldName = 'ZeugnisDatum' IsDetail = True SQLFieldName = 'ZeugnisDatum' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField24: TdaField Alias = 'Klasse (2)' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse_2' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField25: TdaField ChildType = 2 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField26: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField27: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField28: TdaField ChildType = 2 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField30: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField29: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'K_Lehrer' JoinType = dajtLeftOuter SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin2: TdaTableJoin ChildType = 6 object daField32: TdaField ChildType = 3 Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField31: TdaField ChildType = 4 Alias = 'KlassenLehrer' DisplayWidth = 10 FieldAlias = 'KlassenLehrer' FieldLength = 10 FieldName = 'KlassenLehrer' SQLFieldName = 'KlassenLehrer' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'K_Lehrer' JoinType = dajtLeftOuter SQLAlias = 'K_Lehrer_2' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' object daTableJoin3: TdaTableJoin ChildType = 6 object daField34: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Lehrer (2)' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer_2' end object daField33: TdaField ChildType = 4 Alias = 'StvKlassenlehrer_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'StvKlassenlehrer_ID' FieldLength = 0 FieldName = 'StvKlassenlehrer_ID' SQLFieldName = 'StvKlassenlehrer_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable5: TdaTable ChildType = 5 Alias = 'EigeneSchule' SQLAlias = 'EigeneSchule' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' object daTableJoin4: TdaTableJoin ChildType = 6 object daField36: TdaField ChildType = 3 Alias = 'Schuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schuljahr' FieldLength = 0 FieldName = 'Schuljahr' SQLFieldName = 'Schuljahr' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField35: TdaField ChildType = 4 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_DS_SchuelerLeistungenHJ1FG1' Height = 270 Left = 1392 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 30 TypeColumnWidth = 52 Width = 271 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_DS_SchuelerDaten' object DS_SchuelerLeistungenHJ1FG1: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'DS_SchuelerLeistungenHJ1FG1' MasterDataPipelineName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 1 TableName = 'EigeneSchule_Faecher' end object ppField3: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 2 TableName = 'SchuelerLeistungsdaten' end object ppField4: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 3 TableName = 'SchuelerLeistungsdaten' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'VorherAbgeschl' FieldName = 'VorherAbgeschl' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 6 TableName = 'SchuelerLeistungsdaten' end object ppField8: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'EigeneSchule_Faecher' end object ppField9: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 8 TableName = 'SchuelerLernabschnittsdaten' end object ppField10: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'SchuelerLernabschnittsdaten' end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerLeistungenHJ1FG1' IsCaseSensitive = True LinkColor = clNavy LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Schueler.ID, EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.NotenKrz, ' ' SchuelerLeistungsdaten.FachLehrer, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.Warnung, ' ' SchuelerLeistungsdaten.VorherAbgeschl, ' ' EigeneSchule_Faecher.Sortierung, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' SchuelerLernabschnittsdaten.Jahr' 'FROM (((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( SchuelerLeistungsdaten.AufZeugnis = '#39'+'#39' )' ' AND (( EigeneSchule_Faecher.FachKrz IN ('#39'D'#39','#39'M'#39','#39'E'#39','#39'E5'#39',' + #39'F'#39','#39'F6'#39','#39'L'#39','#39'L6'#39') )' ' OR ( SchuelerLeistungsdaten.Kursart IN ('#39'WPI'#39','#39'WP1FS'#39','#39'WP' + '1NT'#39','#39'WP1SW'#39','#39'WP1MU'#39') )' ' )' ' AND ( SchuelerLeistungsdaten.Kursart NOT IN ('#39'EES'#39','#39'EGS1'#39 + ') )' 'ORDER BY EigeneSchule_Faecher.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'AufZeugnis' DisplayWidth = 1 FieldAlias = 'AufZeugnis' FieldLength = 1 FieldName = 'AufZeugnis' SQLFieldName = 'AufZeugnis' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria2: TdaCriteria ChildType = 7 CriteriaType = dacrBegin Level = 0 end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'FaecherFG1' Value = 'D,M,E,E5,F,F6,L,L6' object TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' Mandatory = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end end object daCriteria4: TdaCriteria ChildType = 7 CriteriaType = dacrOR Level = 0 end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'KursartenFG1' Value = 'WPI,WP1FS,WP1NT,WP1SW,WP1MU' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' Mandatory = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria6: TdaCriteria ChildType = 7 CriteriaType = dacrEnd Level = 0 end object daCriteria7: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotInList ParamName = 'KursartenNotFG1' Value = 'EES,EGS1' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' Mandatory = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField3: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField4: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField5: TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' IsDetail = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' IsDetail = True SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField8: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField9: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField14: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField16: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object TdaSQLLink ChildType = 9 object daField18: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField19: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object TdaSQLLink ChildType = 9 object daField20: TdaField ChildType = 10 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField21: TdaField ChildType = 11 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object TdaSQLLink ChildType = 9 object daField22: TdaField ChildType = 10 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField ChildType = 11 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_DS_SchuelerLeistungenHJ1FG2' Height = 270 Left = 1397 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 320 TypeColumnWidth = 52 Width = 271 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_DS_SchuelerDaten' object DS_SchuelerLeistungenHJ1FG2: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'DS_SchuelerLeistungenHJ1FG2' MasterDataPipelineName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 1 TableName = 'EigeneSchule_Faecher' end object ppField3: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 2 TableName = 'SchuelerLeistungsdaten' end object ppField4: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 3 TableName = 'SchuelerLeistungsdaten' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'VorherAbgeschl' FieldName = 'VorherAbgeschl' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 6 TableName = 'SchuelerLeistungsdaten' end object ppField8: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'EigeneSchule_Faecher' end object ppField9: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 8 TableName = 'SchuelerLernabschnittsdaten' end object ppField10: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'SchuelerLernabschnittsdaten' end end object daSQL3: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerLeistungenHJ1FG2' IsCaseSensitive = True LinkColor = clGreen LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Schueler.ID, EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.NotenKrz, ' ' SchuelerLeistungsdaten.FachLehrer, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.Warnung, ' ' SchuelerLeistungsdaten.VorherAbgeschl, ' ' EigeneSchule_Faecher.Sortierung, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' SchuelerLernabschnittsdaten.Jahr' 'FROM (((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( SchuelerLeistungsdaten.AufZeugnis = '#39'+'#39' )' ' AND ( SchuelerLeistungsdaten.VorherAbgeschl = '#39'-'#39' )' ' AND ( EigeneSchule_Faecher.FachKrz NOT IN ('#39'D'#39','#39'M'#39','#39'E'#39','#39'E' + '5'#39','#39'F'#39','#39'F6'#39','#39'L'#39','#39'L6'#39') )' ' AND ( SchuelerLeistungsdaten.Kursart IN ('#39'PUK'#39','#39'PUT'#39','#39'WPI' + 'I'#39','#39'FS3'#39') )' 'ORDER BY EigeneSchule_Faecher.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'AufZeugnis' DisplayWidth = 1 FieldAlias = 'AufZeugnis' FieldLength = 1 FieldName = 'AufZeugnis' SQLFieldName = 'AufZeugnis' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Value = '-' object TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotInList ParamName = 'FaecherNotFG2' Value = 'D,M,E,E5,F,F6,L,L6' object TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' Mandatory = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'KursartenFG2' Value = 'PUK,PUT,WPII,FS3' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' Mandatory = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField3: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField4: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField5: TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' IsDetail = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' IsDetail = True SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField8: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField9: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField14: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField16: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object TdaSQLLink ChildType = 9 object daField18: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField19: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object TdaSQLLink ChildType = 9 object daField20: TdaField ChildType = 10 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField21: TdaField ChildType = 11 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object TdaSQLLink ChildType = 9 object daField22: TdaField ChildType = 10 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField ChildType = 11 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end object daADOQueryDataView6: TdaADOQueryDataView UserName = 'Query_DS_SchuelerLeistungenHJ2EP' Height = 267 Left = 340 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 280 TypeColumnWidth = 52 Width = 271 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_DS_SchuelerDaten' object DS_SchuelerLeistungenHJ1EP: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'DS_SchuelerLeistungenHJ1EP' MasterDataPipelineName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 1 TableName = 'EigeneSchule_Faecher' end object ppField3: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 2 TableName = 'SchuelerLeistungsdaten' end object ppField4: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 3 TableName = 'SchuelerLeistungsdaten' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'VorherAbgeschl' FieldName = 'VorherAbgeschl' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 6 TableName = 'SchuelerLeistungsdaten' end object ppField8: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'EigeneSchule_Faecher' end object ppField9: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 8 TableName = 'SchuelerLernabschnittsdaten' end object ppField10: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'SchuelerLernabschnittsdaten' end end object daSQL6: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerLeistungenHJ1EP' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Schueler.ID, EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.NotenKrz, ' ' SchuelerLeistungsdaten.FachLehrer, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.Warnung, ' ' SchuelerLeistungsdaten.VorherAbgeschl, ' ' EigeneSchule_Faecher.Sortierung, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' SchuelerLernabschnittsdaten.Jahr' 'FROM (((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( SchuelerLeistungsdaten.AufZeugnis = '#39'+'#39' )' ' AND ( SchuelerLeistungsdaten.VorherAbgeschl = '#39'+'#39' )' ' AND ( EigeneSchule_Faecher.FachKrz NOT IN ('#39'D'#39','#39'M'#39','#39'E'#39','#39'E' + '5'#39','#39'F'#39','#39'F6'#39','#39'L'#39','#39'L6'#39') )' ' AND ( SchuelerLeistungsdaten.Kursart IN ('#39'PUK'#39','#39'PUT'#39','#39'WPI' + 'I'#39','#39'FS3'#39') )' 'ORDER BY EigeneSchule_Faecher.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'AufZeugnis' DisplayWidth = 1 FieldAlias = 'AufZeugnis' FieldLength = 1 FieldName = 'AufZeugnis' SQLFieldName = 'AufZeugnis' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotInList ParamName = 'FaecherNotFG2' Value = 'D,M,E,E5,F,F6,L,L6' object TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' Mandatory = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'KursartenFG2' Value = 'PUK,PUT,WPII,FS3' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' Mandatory = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField3: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField4: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField5: TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' IsDetail = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' IsDetail = True SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField8: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField9: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField14: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField16: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object TdaSQLLink ChildType = 9 object daField18: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField19: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object TdaSQLLink ChildType = 9 object daField20: TdaField ChildType = 10 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField21: TdaField ChildType = 11 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object TdaSQLLink ChildType = 9 object daField22: TdaField ChildType = 10 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField ChildType = 11 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end object daADOQueryDataView7: TdaADOQueryDataView UserName = 'Query_DS_SchuelerAbschnitt1HJ' Height = 235 Left = 336 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 28 TypeColumnWidth = 52 Width = 275 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_DS_SchuelerDaten' object DS_SchuelerAbschnitt1HJ: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'DS_SchuelerAbschnitt1HJ' MasterDataPipelineName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'SchuelerLernabschnittsdaten' end object ppField3: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'SchuelerLernabschnittsdaten' end object ppField4: TppField FieldAlias = 'SumFehlStd' FieldName = 'SumFehlStd' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 3 TableName = 'SchuelerLernabschnittsdaten' end object ppField5: TppField FieldAlias = 'SumFehlStdU' FieldName = 'SumFehlStdU' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerLernabschnittsdaten' end object ppField6: TppField FieldAlias = 'ZeugnisBem' FieldName = 'ZeugnisBem' FieldLength = 0 IsDetail = True Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 5 TableName = 'SchuelerLernabschnittsdaten' end object ppField7: TppField FieldAlias = 'ASV' FieldName = 'ASV' FieldLength = 0 IsDetail = True Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 6 TableName = 'SchuelerLD_PSFachBem' end object ppField8: TppField FieldAlias = 'AUE' FieldName = 'LELS' FieldLength = 0 IsDetail = True Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 7 TableName = 'SchuelerLD_PSFachBem' end end object daSQL7: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerAbschnitt1HJ' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Schueler.ID, ' ' SchuelerLernabschnittsdaten.Jahr, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' SchuelerLernabschnittsdaten.SumFehlStd, ' ' SchuelerLernabschnittsdaten.SumFehlStdU, ' ' SchuelerLernabschnittsdaten.ZeugnisBem, ' ' SchuelerLD_PSFachBem.ASV, ' ' SchuelerLD_PSFachBem.LELS' 'FROM ((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLD_PSFachBem SchuelerLD_PSFachBem ON ' ' (SchuelerLD_PSFachBem.Abschnitt_ID = SchuelerLernabschnitts' + 'daten.ID) )' 'ORDER BY SchuelerLernabschnittsdaten.Abschnitt') SQLType = sqSQL2 object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField3: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField4: TdaField Alias = 'SumFehlStd' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SumFehlStd' FieldLength = 0 FieldName = 'SumFehlStd' IsDetail = True SQLFieldName = 'SumFehlStd' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField5: TdaField Alias = 'SumFehlStdU' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SumFehlStdU' FieldLength = 0 FieldName = 'SumFehlStdU' IsDetail = True SQLFieldName = 'SumFehlStdU' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField6: TdaField Alias = 'ZeugnisBem' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'ZeugnisBem' FieldLength = 0 FieldName = 'ZeugnisBem' IsDetail = True Linkable = False SQLFieldName = 'ZeugnisBem' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField7: TdaField Alias = 'ASV' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'ASV' FieldLength = 0 FieldName = 'ASV' IsDetail = True Linkable = False SQLFieldName = 'ASV' TableAlias = 'SchuelerLD_PSFachBem' TableName = 'SchuelerLD_PSFachBem' TableSQLAlias = 'SchuelerLD_PSFachBem' end object daField8: TdaField Alias = 'AUE' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'LELS' FieldLength = 0 FieldName = 'LELS' IsDetail = True Linkable = False SQLFieldName = 'LELS' TableAlias = 'SchuelerLD_PSFachBem' TableName = 'SchuelerLD_PSFachBem' TableSQLAlias = 'SchuelerLD_PSFachBem' end object daField9: TdaField ChildType = 2 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField11: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLD_PSFachBem' SQLAlias = 'SchuelerLD_PSFachBem' TableAlias = 'SchuelerLD_PSFachBem' TableName = 'SchuelerLD_PSFachBem' object daTableJoin2: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLD_PSFachBem' TableName = 'SchuelerLD_PSFachBem' TableSQLAlias = 'SchuelerLD_PSFachBem' end object daField12: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object TdaSQLLink ChildType = 9 object daField14: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField15: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object TdaSQLLink ChildType = 9 object daField16: TdaField ChildType = 10 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField17: TdaField ChildType = 11 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object TdaSQLLink ChildType = 9 object daField18: TdaField ChildType = 10 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField19: TdaField ChildType = 11 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end object daADOQueryDataView17: TdaADOQueryDataView UserName = 'Query_DS_SchuelerFoerderung1HJ' Height = 262 Left = 338 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 562 TypeColumnWidth = 52 Width = 273 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_DS_SchuelerDaten' object DS_SchuelerFoerderung1HJ: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'DS_SchuelerFoerderung1HJ' MasterDataPipelineName = 'DS_SchuelerDaten' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 1 TableName = 'EigeneSchule_Faecher' end object ppField3: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 2 TableName = 'SchuelerLeistungsdaten' end object ppField4: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 3 TableName = 'SchuelerLeistungsdaten' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'VorherAbgeschl' FieldName = 'VorherAbgeschl' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 6 TableName = 'SchuelerLeistungsdaten' end object ppField8: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'EigeneSchule_Faecher' end object ppField9: TppField FieldAlias = 'Abschnitt' FieldName = 'Abschnitt' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 8 TableName = 'SchuelerLernabschnittsdaten' end object ppField10: TppField FieldAlias = 'Jahr' FieldName = 'Jahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 9 TableName = 'SchuelerLernabschnittsdaten' end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_SchuelerFoerderung1HJ' IsCaseSensitive = True LinkColor = clNavy LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Schueler.ID, EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.NotenKrz, ' ' SchuelerLeistungsdaten.FachLehrer, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.Warnung, ' ' SchuelerLeistungsdaten.VorherAbgeschl, ' ' EigeneSchule_Faecher.Sortierung, ' ' SchuelerLernabschnittsdaten.Abschnitt, ' ' SchuelerLernabschnittsdaten.Jahr' 'FROM (((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( SchuelerLeistungsdaten.AufZeugnis = '#39'+'#39' )' ' AND ( SchuelerLeistungsdaten.Kursart IN ('#39'EES'#39','#39'EGS1'#39','#39'FO' + 'GT'#39','#39'ZUV'#39') )' 'ORDER BY EigeneSchule_Faecher.Sortierung') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'AufZeugnis' DisplayWidth = 1 FieldAlias = 'AufZeugnis' FieldLength = 1 FieldName = 'AufZeugnis' SQLFieldName = 'AufZeugnis' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'KursartenFoerderung' Value = 'EES,EGS1,FOGT,ZUV' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' Mandatory = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField3: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField4: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField5: TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' IsDetail = True SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'VorherAbgeschl' DisplayWidth = 1 FieldAlias = 'VorherAbgeschl' FieldLength = 1 FieldName = 'VorherAbgeschl' IsDetail = True SQLFieldName = 'VorherAbgeschl' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField8: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' IsDetail = True SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField9: TdaField Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField10: TdaField Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField11: TdaField ChildType = 2 Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daTable1: TdaTable ChildType = 5 Alias = 'Schueler' JoinType = dajtNone SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' end object daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin1: TdaTableJoin ChildType = 6 object daField13: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField12: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField15: TdaField ChildType = 3 Alias = 'Abschnitt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt_ID' FieldLength = 0 FieldName = 'Abschnitt_ID' SQLFieldName = 'Abschnitt_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField14: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin3: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField16: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object TdaSQLLink ChildType = 9 object daField18: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField19: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object TdaSQLLink ChildType = 9 object daField20: TdaField ChildType = 10 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField21: TdaField ChildType = 11 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' IsDetail = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end object TdaSQLLink ChildType = 9 object daField22: TdaField ChildType = 10 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField ChildType = 11 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' IsDetail = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F7572636514B803000070726F6365647572 65205661726961626C65733B0D0A7661720D0A20207B5661726961626C65207A 757220466573746C6567756E672064657220656967656E656E20426572656368 756E677D0D0A20205573654F776E43616C63203A20426F6F6C65616E3B0D0A20 206253686F7745726761656E7A756E6773556E7465727269636874203A20426F 6F6C65616E3B0D0A202073536368756C666F726D203A20537472696E673B200D 0A20200D0A20207B5661726961626C656E2066C3BC7220416E7A656967652064 657220416267C3A46E6765727D0D0A20206941626761656E676572203A20496E 74656765723B0D0A20200D0A20207B5661726961626C656E2066C3BC72206469 6520656967656E65205665727365747A756E6773626572656368756E677D200D 0A20204647315F364D2C204647315F354D2C204647325F364D2C204647325F35 4D2C204647315F364E2C204647315F354E2C204647325F364E2C204647325F35 4E2C204647315F412C204647325F41203A20496E74656765723B0D0A20207344 6566697A697446616563686572464731203A20537472696E673B0D0A20206941 6E7A4647314F686E654E6F74652C2069416E7A4647324F686E654E6F7465203A 20496E74656765723B0D0A20207B5661726961626C656E2066C3BC7220464F52 517D0D0A2020736C52535F464F52515F464731203A2054537472696E674C6973 743B0D0A2020736C52535F464F52515F464732203A2054537472696E674C6973 743B0D0A20207B5661726961626C656E2066C3BC722064696520322E20467265 6D647370726163686520616E20646572205265616C736368756C652E20497374 20696E2064657220362E204B6C61737365206E69636874206E65672E20766572 7365747A756E67737769726B73616D7D0D0A20207352535A7765697465465346 616563686572203A20537472696E673B0D0A20200D0A20207B46617262656E20 66C3BC722064696520486572766F7268657262756E672062657374696D6D7465 72204E6F74656E7D0D0A202062466F756E644147484A314647312C2062466F75 6E644147484A314647323A20426F6F6C65616E3B200D0A202069436F6C4D6168 6E756E672C2069436F6C446566697A69742C2069436F6C417573676C65696368 2C2069436F6C5761726E68696E776569732C2069436F6C5072756566756E672C 2069436F6C41626761656E6765722C2069436F6C42656D2C2069436F6C415356 2C2069436F6C415545203A20496E74656765723B2020202020202020200D0A0D 0A626567696E0D0A0D0A656E643B0D0A084361726574506F7301020102010000 01060A54726150726F6772616D094368696C645479706502130B50726F677261 6D4E616D65060E476C6F62616C4F6E4372656174650B50726F6772616D547970 65070B747450726F63656475726506536F757263650C1A09000070726F636564 75726520476C6F62616C4F6E4372656174653B0D0A626567696E200D0A0D0A0D 0A20205265706F72742E506172616D65746572732E4974656D735B2746616563 686572464731275D2E4175746F53656172636853657474696E67732E53656172 636845787072657373696F6E203A3D2027442C4D2C45352C46372C4C37273B0D 0A200D0A20205265706F72742E506172616D65746572732E4974656D735B274B 757273617274656E464731275D2E4175746F53656172636853657474696E6773 2E53656172636845787072657373696F6E203A3D2027575049273B0D0A20200D 0A20205265706F72742E506172616D65746572732E4974656D735B274B757273 617274656E4E6F74464731275D2E4175746F53656172636853657474696E6773 2E53656172636845787072657373696F6E203A3D2027454753312C5A55562C45 45532C464F47542C41474754273B0D0A20202020202020202020202020202020 2020202020202020202020202020202020202020202020202020202020202020 2020202020202020202020202020202020202020202020202020202020202020 2020202020200D0A20205265706F72742E506172616D65746572732E4974656D 735B274B757273617274656E464732275D2E4175746F53656172636853657474 696E67732E53656172636845787072657373696F6E203A3D202750554B2C5055 542C57504949273B0D0A0D0A20205265706F72742E506172616D65746572732E 4974656D735B27466165636865724E6F74464732275D2E4175746F5365617263 6853657474696E67732E53656172636845787072657373696F6E203A3D202744 2C4D2C45352C46372C4C37273B0D0A20200D0A20205265706F72742E50617261 6D65746572732E4974656D735B274B757273617274656E466F6572646572756E 67275D2E4175746F53656172636853657474696E67732E536561726368457870 72657373696F6E203A3D2027454753312C5A55562C414747542C415354273B0D 0A20200D0A20205265706F72742E506172616D65746572732E4974656D735B27 616B74416273275D2E4175746F53656172636853657474696E67732E53656172 636845787072657373696F6E203A3D202731273B0D0A20200D0A20207352535A 7765697465465346616563686572203A3D202746273B0D0A0D0A20206253686F 7745726761656E7A756E6773556E7465727269636874203A3D20547275653B20 0D0A0D0A20206941626761656E676572203A3D20313B20200D0A0D0A20206943 6F6C446566697A6974203A3D20524742283235352C3136362C313636293B0D0A 202069436F6C417573676C65696368203A3D20524742283136392C3230392C31 3339293B0D0A20200D0A20202F2F5265706F72742E506172616D65746572732E 4974656D735B27536368756C6A616872275D2E4175746F536561726368536574 74696E67732E53656172636845787072657373696F6E203A3D20496E74546F53 747228456967656E65536368756C655B27536368756C6A616872275D293B0D0A 200D0A207B20496620456967656E65536368756C655B27416E7A61686C416273 63686E69747465275D203D2032205468656E0D0A20202020426567696E0D0A20 20202020205265706F72742E506172616D65746572732E4974656D735B275363 68756C6A616872275D2E4175746F53656172636853657474696E67732E536561 72636845787072657373696F6E203A3D20496E74546F53747228456967656E65 536368756C655B27536368756C6A616872275D293B0D0A202020202020526570 6F72742E506172616D65746572732E4974656D735B2741627363686E69747431 275D2E4175746F53656172636853657474696E67732E53656172636845787072 657373696F6E203A3D202731273B0D0A2020202020205265706F72742E506172 616D65746572732E4974656D735B2741627363686E69747432275D2E4175746F 53656172636853657474696E67732E53656172636845787072657373696F6E20 3A3D202732273B0D0A20202020456E640D0A2020456C73650D0A202020204265 67696E0D0A2020202020205265706F72742E506172616D65746572732E497465 6D735B27536368756C6A616872275D2E4175746F53656172636853657474696E 67732E53656172636845787072657373696F6E203A3D20496E74546F53747228 456967656E65536368756C655B27536368756C6A616872275D293B0D0A202020 2020205265706F72742E506172616D65746572732E4974656D735B2741627363 686E69747431275D2E4175746F53656172636853657474696E67732E53656172 636845787072657373696F6E203A3D202732273B0D0A2020202020205265706F 72742E506172616D65746572732E4974656D735B2741627363686E6974743227 5D2E4175746F53656172636853657474696E67732E5365617263684578707265 7373696F6E203A3D202734273B0D0A20202020456E643B20207D0D0A0D0A2020 73536368756C666F726D203A3D20456967656E65536368756C655B2753636875 6C666F726D4B727A275D3B0D0A20200D0A202049662073536368756C666F726D 203D2027475927205468656E200D0A202020205265706F72742E506172616D65 746572732E4974656D735B274A61687267616E677373747566656E275D2E4175 746F53656172636853657474696E67732E53656172636845787072657373696F 6E203A3D202730352C30362C30372C30382C30392C3130270D0A2020456C7365 20200D0A202020205265706F72742E506172616D65746572732E4974656D735B 274A61687267616E677373747566656E275D2E4175746F536561726368536574 74696E67732E53656172636845787072657373696F6E203A3D202730352C3036 2C30372C30382C30392C3130273B0D0A0D0A200D0A200D0A2F2F205265706F72 742E506172616D65746572732E4974656D735B274A61687267616E6773737475 66656E275D2E4175746F53656172636853657474696E67732E53656172636845 787072657373696F6E203A3D2027303427203B20200D0A200D0A2020736C5253 5F464F52515F464731203A3D2054537472696E674C6973742E4372656174653B 0D0A2020736C52535F464F52515F464732203A3D2054537472696E674C697374 2E4372656174653B0D0A20200D0A656E643B0D0A084361726574506F7301024E 0211000001060A54726150726F6772616D094368696C645479706502140B5072 6F6772616D4E616D65060F476C6F62616C4F6E44657374726F790B50726F6772 616D54797065070B747450726F63656475726506536F75726365065770726F63 656475726520476C6F62616C4F6E44657374726F793B0D0A626567696E0D0A20 20736C52535F464F52515F4647312E467265653B0D0A2020736C52535F464F52 515F4647322E467265653B0D0A656E643B0D0A084361726574506F7301020102 01000001060A54726150726F6772616D094368696C645479706502150B50726F 6772616D4E616D65060F476C6F62616C5661727352657365740B50726F677261 6D54797065070B747450726F63656475726506536F757263650C920100007072 6F63656475726520476C6F62616C5661727352657365743B0D0A626567696E0D 0A2020200D0A20204647315F364D203A3D20303B0D0A20204647315F354D203A 3D20303B0D0A20204647325F364D203A3D20303B0D0A20204647325F354D203A 3D20303B0D0A20204647315F364E203A3D20303B0D0A20204647315F354E203A 3D20303B0D0A20204647325F364E203A3D20303B0D0A20204647325F354E203A 3D20303B0D0A20204647315F41203A3D20303B0D0A20204647325F41203A3D20 303B0D0A0D0A202073446566697A697446616563686572464731203A3D202727 3B0D0A20200D0A202069416E7A4647314F686E654E6F7465203A3D20303B0D0A 202069416E7A4647324F686E654E6F7465203A3D20303B0D0A20200D0A202062 466F756E644147484A31464731203A3D2046616C73653B0D0A202062466F756E 644147484A31464732203A3D2046616C73653B200D0A0D0A2020736C52535F46 4F52515F4647312E436C6561723B0D0A2020736C52535F464F52515F4647322E 436C6561723B0D0A0D0A656E643B0D0A084361726574506F7301021802090000 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650614 4C6162656C4865616465724F6E476574546578740B50726F6772616D54797065 070B747450726F63656475726506536F757263650C3C01000070726F63656475 7265204C6162656C4865616465724F6E47657454657874287661722054657874 3A20537472696E67293B0D0A626567696E0D0A0D0A2020202054657874203A3D 20274B6C617373652027202B205265706F72742E44617461506970656C696E65 5B274B6C6173736520283229275D202B2027202D204C65697374756E67656E20 536368756C6A6168722027202B20696E74746F73747228456967656E65536368 756C655B27536368756C6A616872275D29202B20272F27202B20696E74746F73 747228456967656E65536368756C655B27536368756C6A616872275D206D6F64 20313030202B203129202B20272C2027202B20696E74746F7374722844535F53 636875656C6572446174656E5B2741627363686E697474275D29202B20272E20 48616C626A616872273B200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E 616D65060B4C6162656C486561646572094576656E744E616D6506094F6E4765 7454657874074576656E7449440235084361726574506F730102010201000001 060F5472614576656E7448616E646C65720B50726F6772616D4E616D6506104C 6162656C4B4C4F6E476574546578740B50726F6772616D54797065070B747450 726F63656475726506536F757263650C9901000070726F636564757265204C61 62656C4B4C4F6E476574546578742876617220546578743A20537472696E6729 3B0D0A626567696E0D0A0D0A202054657874203A3D205265706F72742E446174 61506970656C696E655B274B4C416E72656465275D202B20272027202B20436F 7079285265706F72742E44617461506970656C696E655B274B4C566F726E616D 65275D2C312C3129202B20272E2027202B205265706F72742E44617461506970 656C696E655B274B4C4E6163686E616D65275D3B0D0A20200D0A202049662052 65706F72742E44617461506970656C696E655B27534B4C4B727A275D203C3E20 2727205468656E2054657874203A3D2054657874202B2027202D2027202B2052 65706F72742E44617461506970656C696E655B27534B4C416E72656465275D20 2B20272027202B20436F7079285265706F72742E44617461506970656C696E65 5B27534B4C566F726E616D65275D2C312C3129202B20272E2027202B20526570 6F72742E44617461506970656C696E655B27534B4C4E6163686E616D65275D3B 2020200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506074C6162 656C4B4C094576656E744E616D6506094F6E47657454657874074576656E7449 440235084361726574506F730102010201000001060F5472614576656E744861 6E646C65720B50726F6772616D4E616D65061344657461696C41667465724765 6E65726174650B50726F6772616D54797065070B747450726F63656475726506 536F757263650C6101000070726F6365647572652044657461696C4166746572 47656E65726174653B0D0A0D0A0D0A626567696E0D0A20202020200D0A202049 662044535F53636875656C6572446174656E5B27537461747573275D203D2032 205468656E0D0A20202020426567696E0D0A20202020202044657461696C2E42 61636B67726F756E64312E42727573682E436F6C6F72203A3D20636C57686974 653B0D0A20202020202044657461696C2E4261636B67726F756E64312E427275 73682E5374796C65203A3D206273436C6561723B0D0A20202020456E640D0A20 20456C73650D0A20202020426567696E0D0A20202020202044657461696C2E42 61636B67726F756E64312E42727573682E436F6C6F72203A3D2069436F6C4162 6761656E6765723B0D0A20202020202044657461696C2E4261636B67726F756E 64312E42727573682E5374796C65203A3D206273536F6C69643B0D0A20202020 456E643B0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461 696C094576656E744E616D65060D416674657247656E6572617465074576656E 7449440219084361726574506F730102010201000001060F5472614576656E74 48616E646C65720B50726F6772616D4E616D65061444657461696C4265666F72 6547656E65726174650B50726F6772616D54797065070B747450726F63656475 726506536F75726365064670726F6365647572652044657461696C4265666F72 6547656E65726174653B0D0A626567696E0D0A0D0A2020476C6F62616C566172 7352657365743B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506 0644657461696C094576656E744E616D65060E4265666F726547656E65726174 65074576656E744944021A084361726574506F730102010201000001060F5472 614576656E7448616E646C65720B50726F6772616D4E616D6506115265706F72 744265666F72655072696E740B50726F6772616D54797065070B747450726F63 656475726506536F75726365143001000070726F636564757265205265706F72 744265666F72655072696E743B0D0A626567696E0D0A0D0A20207B416E7A6569 67652064657220656967656E656E20426572656368756E67656E7D0D0A0D0A20 207B416E7A656967652064657320457267C3A46E7A756E6773756E7465727269 63687465737D0D0A20204C6162656C457267537464312E56697369626C65203A 3D206253686F7745726761656E7A756E6773556E74657272696368743B0D0A20 204C6162656C457267537464322E56697369626C65203A3D206253686F774572 6761656E7A756E6773556E74657272696368743B0D0A20205375625265706F72 74484A314572675374642E56697369626C65203A3D206253686F774572676165 6E7A756E6773556E74657272696368743B0D0A2020202020200D0A656E643B0D 0A0D436F6D706F6E656E744E616D6506065265706F7274094576656E744E616D 65060B4265666F72655072696E74074576656E7449440201084361726574506F 730102010201000001060F5472614576656E7448616E646C65720B50726F6772 616D4E616D65061D53797374656D5661726961626C6553656974656E4F6E4765 74546578740B50726F6772616D54797065070B747450726F6365647572650653 6F75726365067170726F6365647572652053797374656D5661726961626C6553 656974656E4F6E476574546578742876617220546578743A20537472696E6729 3B0D0A626567696E0D0A0D0A202054657874203A3D2020272853656974652027 202B2054657874202B202729273B0D0A0D0A656E643B0D0A0D436F6D706F6E65 6E744E616D65061453797374656D5661726961626C6553656974656E09457665 6E744E616D6506094F6E47657454657874074576656E74494402350843617265 74506F730102010201000001060F5472614576656E7448616E646C65720B5072 6F6772616D4E616D650614444254657874566F726E616D654F6E5072696E740B 50726F6772616D54797065070B747450726F63656475726506536F757263650C 3E01000070726F63656475726520444254657874566F726E616D654F6E507269 6E743B0D0A626567696E0D0A0D0A20204966205265706F72742E446174615069 70656C696E655B27576965646572686F6C756E67275D203D20272B2720546865 6E0D0A20202020426567696E0D0A202020202020444254657874566F726E616D 652E466F6E742E426F6C64203A3D20547275653B0D0A20202020202044425465 7874566F726E616D652E466F6E742E4974616C6963203A3D20547275653B0D0A 20202020456E640D0A2020456C73650D0A20202020426567696E0D0A20202020 2020444254657874566F726E616D652E466F6E742E426F6C64203A3D2046616C 73653B0D0A202020202020444254657874566F726E616D652E466F6E742E4974 616C6963203A3D2046616C73653B0D0A20202020456E643B0D0A0D0A656E643B 0D0A0D436F6D706F6E656E744E616D65060D444254657874566F726E616D6509 4576656E744E616D6506074F6E5072696E74074576656E744944022008436172 6574506F730102010201000001060F5472614576656E7448616E646C65720B50 726F6772616D4E616D6506114442546578744E616D654F6E5072696E740B5072 6F6772616D54797065070B747450726F63656475726506536F757263650C3501 000070726F636564757265204442546578744E616D654F6E5072696E743B0D0A 626567696E0D0A0D0A20204966205265706F72742E44617461506970656C696E 655B27576965646572686F6C756E67275D203D20272B27205468656E0D0A2020 2020426567696E0D0A2020202020204442546578744E616D652E466F6E742E42 6F6C64203A3D20547275653B0D0A2020202020204442546578744E616D652E46 6F6E742E4974616C6963203A3D20547275653B0D0A20202020456E640D0A2020 456C73650D0A20202020426567696E0D0A2020202020204442546578744E616D 652E466F6E742E426F6C64203A3D2046616C73653B0D0A202020202020444254 6578744E616D652E466F6E742E4974616C6963203A3D2046616C73653B0D0A20 202020456E643B20200D0A202020200D0A656E643B0D0A0D436F6D706F6E656E 744E616D65060A4442546578744E616D65094576656E744E616D6506074F6E50 72696E74074576656E7449440220084361726574506F73010241020800000106 0F5472614576656E7448616E646C65720B50726F6772616D4E616D65061D5265 706F72744F6E4175746F5365617263684469616C6F67436C6F73650B50726F67 72616D54797065070B747450726F63656475726506536F7572636514B4020000 70726F636564757265205265706F72744F6E4175746F5365617263684469616C 6F67436C6F73653B0D0A626567696E0D0A0D0A7B426569207A7572C3BC636B6C 696567656E64656E20536368756C6A616872656E206175636820416267C3A46E 67657220626561636874656E7D20200D0A7B202043617365206941626761656E 676572204F66200D0A2020202030203A205265706F72742E506172616D657465 72732E4974656D735B27537461747573275D2E4175746F536561726368536574 74696E67732E53656172636845787072657373696F6E203A3D202732273B0D0A 2020202031203A20426567696E0D0A2020202020202020202049662053747254 6F496E74285265706F72742E506172616D65746572732E4974656D735B275363 68756C6A616872275D2E4175746F53656172636853657474696E67732E536561 72636845787072657373696F6E29203D20456967656E65536368756C655B2753 6368756C6A616872275D205468656E0D0A202020202020202020202020526570 6F72742E506172616D65746572732E4974656D735B27537461747573275D2E41 75746F53656172636853657474696E67732E5365617263684578707265737369 6F6E203A3D202732270D0A20202020202020202020456C73650D0A2020202020 202020202020205265706F72742E506172616D65746572732E4974656D735B27 537461747573275D2E4175746F53656172636853657474696E67732E53656172 636845787072657373696F6E203A3D2027322C382C39273B0D0A202020202020 2020456E643B0D0A2020202032203A205265706F72742E506172616D65746572 732E4974656D735B27537461747573275D2E4175746F53656172636853657474 696E67732E53656172636845787072657373696F6E203A3D2027322C382C3927 3B0D0A2020456E643B0D0A7D0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D6506065265706F7274094576656E744E616D6506174F6E4175746F53656172 63684469616C6F67436C6F7365074576656E744944020B084361726574506F73 010278020E000001060F5472614576656E7448616E646C65720B50726F677261 6D4E616D65061144657461696C4265666F72655072696E740B50726F6772616D 54797065070B747450726F63656475726506536F757263650C4C01000070726F 6365647572652044657461696C4265666F72655072696E743B0D0A626567696E 0D0A0D0A202053685F4E616D652E62727573682E636F6C6F723A3D20636C7768 6974653B200D0A20200D0A202069662044535F53636875656C6572446174656E 5B275665727365747A756E674B727A275D203D20274E27207468656E0D0A2020 2020426567696E0D0A20202020202053685F4E616D652E62727573682E636F6C 6F723A3D2069436F6C446566697A69743B200D0A20202020456E643B20200D0A 202020200D0A202069662044535F53636875656C6572446174656E5B27566572 7365747A756E674B727A275D203D20274E5027207468656E0D0A202020204265 67696E0D0A20202020202053685F4E616D652E62727573682E636F6C6F723A3D 20524742283235312C3231362C3936293B0D0A20202020456E643B202020200D 0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C09 4576656E744E616D65060B4265666F72655072696E74074576656E7449440218 084361726574506F730102010201000000} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList3: TppParameterList object ppParameter12: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Klasse (2)' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'DS_SchuelerDaten' DataType = dtString LookupSettings.NameField = 'Klasse_2' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Klasse_2' LookupSettings.DataPipelineName = 'DS_SchuelerDaten' Value = '' UserName = 'Klasse' end object ppParameter11: TppParameter AutoSearchSettings.FieldAlias = 'Status' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = '2' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = '2' UserName = 'Status' end object ppParameter3: TppParameter AutoSearchSettings.FieldAlias = 'FachKrz' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'D,M,E,E5,F,F6,L,L6' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'D' UserName = 'FaecherFG1' end object ppParameter4: TppParameter AutoSearchSettings.FieldAlias = 'FachKrz' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'D,M,E,E5,F,F6,L,L6' AutoSearchSettings.SearchOperator = soNotInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'D' UserName = 'FaecherNotFG2' end object ppParameter5: TppParameter AutoSearchSettings.FieldAlias = 'Kursart' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'WPI,WP1FS,WP1NT,WP1SW,WP1MU' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'WPI' UserName = 'KursartenFG1' end object ppParameter9: TppParameter AutoSearchSettings.FieldAlias = 'Kursart' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'EES,EGS1' AutoSearchSettings.SearchOperator = soNotInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'EES' UserName = 'KursartenNotFG1' end object ppParameter6: TppParameter AutoSearchSettings.FieldAlias = 'Kursart' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'PUK,PUT,WPII,FS3' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'PUK' UserName = 'KursartenFG2' end object ppParameter2: TppParameter AutoSearchSettings.FieldAlias = 'Kursart' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'EES,EGS1,FOGT,ZUV' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'EES' UserName = 'KursartenFoerderung' end object ppArchivierung: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'Schildvorgabe' DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'Schildvorgabe' UserName = 'Archivierung' end end end