object Report: TppReport AutoStop = False Columns = 2 ColumnPositions.Strings = ( '18000' '118000') DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Kopie von 03_Liste_1-4_Abiturfach-Namen_und_Anzahl_SuS_nach_Fach' + '_Kurs_para_Jgg_L_Name_AbiFach.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 10000 PrinterSetup.mmMarginLeft = 18000 PrinterSetup.mmMarginRight = 8000 PrinterSetup.mmMarginTop = 10000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\WBk_Bochum_Sekretariat\Abitur\02_Ue' + 'bersicht Abif'#228'cher\Kopie von 03_Liste_1-4_Abiturfach-Namen_und_A' + 'nzahl_SuS_nach_Fach_Kurs_para_Jgg_L_Name_AbiFach.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 Icon.Data = { 0000010001002020100000000000E80200001600000028000000200000004000 0000010004000000000080020000000000000000000000000000000000000000 000000008000008000000080800080000000800080008080000080808000C0C0 C0000000FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 00000000C00000CC00000000000000000000000C0C000C00C000000000000000 0000000C00CCC00000000000000000000000000C000000000000000000000000 00007777C7770000000000000000000000007BBBCBB7000F0000000000000000 00007BCCBBB700FFF00000000000000000007BBBBBB700FFF000000000000000 00007BBBBBB700FF770000000000000000007333BBB7000F7B00000000000000 000070003BB70007B7700000000000000000999903B700007B70000000000000 0001999990770000B7B700000000000000019999900000000B77000000000000 0001999990000000000010000000000000011999900000000071700000000000 0000111100000000001710000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000000000000000000000000000000000000FFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF7 CFFFFFEBB7FFFFEC3FFFFFEF9FFFFF008FFFFF0087FFFF0083FFFF0083FFFF00 81FFFF00C1FFFF00C0FFFE00E0FFFC00E07FFC03F07FFC03F03FFC03F83FFE07 F83FFF0FFC7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF} LanguageID = 'Default' OpenFile = False OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True 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 = [] TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'ReportBuilder' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 84000 DataPipelineName = 'DS_Schuelerzahlen' object ppHeaderBand2: TppHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 14023 mmPrintPosition = 0 object ppShape5: TppShape UserName = 'Shape5' Brush.Color = clGray ParentWidth = True Pen.Color = clGray mmHeight = 6350 mmLeft = 0 mmTop = 0 mmWidth = 184000 BandType = 0 LayerName = Foreground1 end object ppLabel56: TppLabel UserName = 'LabelHeader' AutoSize = False Border.Weight = 1.250000000000000000 Caption = 'Anzahl Studierende im ersten bis vierten Abiturfach nach Fach un' + 'd Kurs (0XG und 0XK) ' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 5249 mmLeft = 0 mmTop = 529 mmWidth = 182034 BandType = 0 LayerName = Foreground1 end object ppSystemVariable3: TppSystemVariable UserName = 'SystemVariableDruckdatum' AutoSize = False Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3440 mmLeft = 128059 mmTop = 7408 mmWidth = 55033 BandType = 0 LayerName = Foreground1 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'Label5' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 0 mmTop = 7408 mmWidth = 71702 BandType = 0 LayerName = Foreground1 end object ppLine3: TppLine UserName = 'Line3' Pen.Width = 2 ParentWidth = True Weight = 1.250000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 11905 mmWidth = 184000 BandType = 0 LayerName = Foreground1 end end object ppColumnHeaderBand1: TppColumnHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 3704 mmPrintPosition = 0 object ppDBText6: TppDBText UserName = 'DBT_SName' DataField = 'Name' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ParentDataPipeline = False Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3440 mmLeft = 9525 mmTop = 265 mmWidth = 40184 BandType = 4 LayerName = Foreground1 end object ppDBText7: TppDBText UserName = 'DBText7' DataField = 'Klasse' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3440 mmLeft = 66411 mmTop = 265 mmWidth = 16140 BandType = 4 LayerName = Foreground1 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc2' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup3 TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter DBCalcType = dcCount DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3704 mmLeft = 265 mmTop = 265 mmWidth = 7144 BandType = 4 LayerName = Foreground1 end object ppLabel1: TppLabel UserName = 'La_ext' Caption = 'ext ' Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3439 mmLeft = 51329 mmTop = 265 mmWidth = 4498 BandType = 4 LayerName = Foreground1 end end object ppColumnFooterBand1: TppColumnFooterBand AlignToBottom = True Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppSummaryBand1: TppSummaryBand Background.Brush.Style = bsClear NewPage = True PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 15610 mmPrintPosition = 0 object ppCrossTab2: TppCrossTab UserName = 'CrossTabGesamt1' DataPipeline = daADOQueryDataView3.DS_Jgg_06 ParentDataPipeline = False ShiftRelativeTo = ppRichText1 Stretch = True Style = 'Standard' DataPipelineName = 'DS_Jgg_06' mmHeight = 5027 mmLeft = 0 mmTop = 10583 mmWidth = 184000 BandType = 7 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object TppGrandTotal ChildType = 6 object TppTotalCaptionDef ChildType = 4 Alignment = taRightJustify Color = 14737632 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] end object TppTotalDef ChildType = 3 Color = 14737632 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] end end object TppGrandTotal ChildType = 7 object TppTotalCaptionDef ChildType = 4 Color = 14737632 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] end object TppTotalDef ChildType = 3 Color = 14737632 Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] end end object TppColumnDef FieldAlias = 'Kursart' FieldName = 'Kursart' Alignment = taCenter Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] SortType = soDescending object TppSubTotal ChildType = 5 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end end object TppRowDef ChildType = 1 FieldAlias = 'Nachname' FieldName = 'Nachname' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [fsBold] object TppSubTotal ChildType = 5 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] Visible = False end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] Visible = False end end end object TppRowDef ChildType = 1 FieldAlias = 'FachKrz' FieldName = 'FachKrz' Alignment = taCenter Color = clWindow Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [fsBold] object TppSubTotal ChildType = 5 object TppTotalCaptionDef ChildType = 4 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end object TppTotalDef ChildType = 3 Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'Arial' Font.Style = [] end end end object TppValueDef ChildType = 2 FieldAlias = 'AnzahlSchueler' FieldName = 'COUNT_2' Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] object TppValueCaptionDef ChildType = 8 CalcType = dcSum Color = clWhite Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Height = -13 Font.Name = 'DIN Offc' Font.Style = [] end end end object ppRichText1: TppRichText UserName = 'RichText1' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Caption = 'RichText1' RichText = '{\rtf1\ansi\ansicpg1252\deff0\deflang1031{\fonttbl{\f0\fnil\fcha' + 'rset0 Calibri;}{\f1\fnil Calibri;}}'#13#10'\viewkind4\uc1\pard\b\f0\fs' + '22 Gesamt\'#39'fcbersicht der Studierenden im ersten bis vierten Abi' + 'turfach (06G und 06K)\f1\par'#13#10'}'#13#10#0 RemoveEmptyLines = False Stretch = True Transparent = True mmHeight = 7408 mmLeft = 1058 mmTop = 2381 mmWidth = 181769 BandType = 7 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 end end object ppGroup4: TppGroup BreakName = 'ASDJahrgang' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group4' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'DS_Schuelerzahlen' NewFile = False object ppGroupHeaderBand4: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand4: TppGroupFooterBand Background.Brush.Style = bsClear PrintHeight = phDynamic HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup2: TppGroup BreakName = 'FachKrz' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewColumn = True StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'DS_Schuelerzahlen' NewFile = False object ppGroupHeaderBand2: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBTextFach' DataField = 'Bezeichnung' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] ParentDataPipeline = False Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 4662 mmLeft = 265 mmTop = 13 mmWidth = 54933 BandType = 3 GroupNo = 0 LayerName = Foreground1 end object ppDBCalc1: TppDBCalc UserName = 'DBCalcGesamt' DataField = 'Count_2' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen DisplayFormat = '"'#931' Fach: "00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] ParentDataPipeline = False ResetGroup = ppGroup2 TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter LookAhead = True DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3937 mmLeft = 52652 mmTop = 265 mmWidth = 29898 BandType = 3 GroupNo = 0 LayerName = Foreground1 end end object ppGroupFooterBand2: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 4000 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup1: TppGroup BreakName = 'Kursart' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 10000 mmNewPageThreshold = 10000 DataPipelineName = 'DS_Schuelerzahlen' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4500 mmPrintPosition = 0 object ppShape1: TppShape UserName = 'Shape1' Brush.Color = cl3DLight ParentHeight = True Pen.Color = clWindow Pen.Style = psClear mmHeight = 4500 mmLeft = 0 mmTop = 0 mmWidth = 83873 BandType = 3 GroupNo = 1 LayerName = Foreground1 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' DataField = 'Count_2' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen DisplayFormat = '"'#931' Kursart: "00' Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ParentDataPipeline = False ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter LookAhead = True DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3810 mmLeft = 52652 mmTop = 265 mmWidth = 29898 BandType = 3 GroupNo = 1 LayerName = Foreground1 end object ppDBText2: TppDBText UserName = 'DBTextKurs1' DataField = 'Kursart' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ParentDataPipeline = False Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3704 mmLeft = 1060 mmTop = 431 mmWidth = 48683 BandType = 3 GroupNo = 1 LayerName = Foreground1 end end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup3: TppGroup BreakName = 'KurzBez' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group3' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'DS_Schuelerzahlen' NewFile = False object ppGroupHeaderBand3: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppDBText4: TppDBText UserName = 'DBTextKurs' DataField = 'KurzBez' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [fsBold] ParentDataPipeline = False Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3704 mmLeft = 2117 mmTop = 597 mmWidth = 17198 BandType = 3 GroupNo = 2 LayerName = Foreground1 end object ppDBText5: TppDBText UserName = 'DBTextLehrer' DataField = 'Lehrerkrz' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [fsBold] ParentDataPipeline = False TextAlignment = taCentered Transparent = True VerticalAlignment = avCenter DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 3704 mmLeft = 33867 mmTop = 597 mmWidth = 15875 BandType = 3 GroupNo = 2 LayerName = Foreground1 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc1' DataField = 'Count_2' DataPipeline = daADOQueryDataView1.DS_Schuelerzahlen DisplayFormat = '"'#931' Kurs: "00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 8 Font.Style = [] ParentDataPipeline = False ResetGroup = ppGroup3 TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter LookAhead = True DataPipelineName = 'DS_Schuelerzahlen' mmHeight = 4498 mmLeft = 54504 mmTop = 265 mmWidth = 28046 BandType = 3 GroupNo = 2 LayerName = Foreground1 end object ppLine2: TppLine UserName = 'Line2' Pen.Color = clMedGray Pen.Style = psDot ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 1852 mmLeft = 0 mmTop = 3175 mmWidth = 84000 BandType = 3 GroupNo = 2 LayerName = Foreground1 end end object ppGroupFooterBand3: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 1058 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clMedGray Pen.Style = psDot ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 0 mmWidth = 84000 BandType = 5 GroupNo = 3 LayerName = Foreground1 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_TdaADOQueryDataView' Height = 351 Left = 68 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 56 TypeColumnWidth = 52 Width = 328 AutoSearchTabOrder = 0 object DS_Schuelerzahlen: TppChildDBPipeline AutoCreateFields = False UserName = 'DS_Schuelerzahlen' object ppField1: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 3 TableName = 'EigeneSchule_Faecher' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'KursartAllg' FieldName = 'KursartAllg' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'KurzBez' FieldName = 'KurzBez' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 6 TableName = 'Kurse' end object ppField8: TppField FieldAlias = 'LehrerKrz' FieldName = 'LehrerKrz' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 7 TableName = 'Kurse' end object ppField9: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 8 TableName = 'K_Lehrer' end object ppField10: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'Schueler' end object ppField12: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 255 IsDetail = True DisplayWidth = 255 Position = 11 TableName = 'EigeneSchule_Faecher' end object ppField13: TppField FieldAlias = 'AbiFach' FieldName = 'AbiFach' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 12 TableName = 'SchuelerLeistungsdaten' end object ppField14: TppField FieldAlias = 'COUNT_2' FieldName = 'COUNT_2' FieldLength = 50 DataType = dtInteger DisplayWidth = 50 Position = 13 TableName = 'Schueler' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_Schuelerzahlen' IsCaseSensitive = True GroupByFieldsSynced = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.Name, Schueler.Vorname, ' ' Schueler.Klasse, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.KursartAllg, ' ' Kurse.KurzBez, Kurse.LehrerKrz, ' ' K_Lehrer.Nachname, Schueler.ASDJahrgang, ' ' Schueler.Status, ' ' EigeneSchule_Faecher.Bezeichnung, ' ' SchuelerLeistungsdaten.AbiFach, ' ' COUNT(*) AS COUNT_2' 'FROM (((((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID)' ' AND (SchuelerLernabschnittsdaten.Jahr = Schueler.AktSchulj' + 'ahr)' ' AND (SchuelerLernabschnittsdaten.Abschnitt = Schueler.AktA' + 'bschnitt) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN Kurse Kurse ON ' ' (Kurse.ID = SchuelerLeistungsdaten.Kurs_ID) )' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = Kurse.LehrerKrz) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( Schueler.Status IN (2,6) )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' ' AND ( SchuelerLeistungsdaten.Kursart IN ('#39'LK1'#39','#39'LK2'#39','#39'AB3' + #39','#39'AB4'#39') )' ' AND ( Schueler.ASDJahrgang = '#39'06'#39' )' 'GROUP BY Schueler.Name, Schueler.Vorname, ' ' Schueler.Klasse, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.KursartAllg, ' ' Kurse.KurzBez, Kurse.LehrerKrz, ' ' K_Lehrer.Nachname, Schueler.ASDJahrgang, ' ' Schueler.Status, ' ' EigeneSchule_Faecher.Bezeichnung, ' ' SchuelerLeistungsdaten.AbiFach' 'ORDER BY Schueler.ASDJahrgang, ' ' EigeneSchule_Faecher.Bezeichnung, ' ' SchuelerLeistungsdaten.KursartAllg DESC, ' ' SchuelerLeistungsdaten.Kursart, ' ' Kurse.KurzBez, Schueler.Klasse, ' ' Schueler.Name, Schueler.Vorname') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'COUNT_2' DataType = dtInteger DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'COUNT_2' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' CalcType = dacaCount end object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '2,6' object TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object TdaNumericValue Value = 2.000000000000000000 end object TdaNumericValue Value = 6.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotEqual Value = '+' object TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = 'LK1,LK2,AB3,AB4' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Value = '06' object TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'L_Name' object TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' ShowAllValues = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end end object daCriteria6: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'SLAD_AbiFach' object TdaField Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' ShowAllValues = True SQLFieldName = 'AbiFach' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daField1: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: 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 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 = 'KursartAllg' DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' IsDetail = True SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' IsDetail = True SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField8: TdaField Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' IsDetail = True SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField9: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' IsDetail = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField10: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField Alias = 'Bezeichnung' DisplayWidth = 255 FieldAlias = 'Bezeichnung' FieldLength = 255 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField13: TdaField Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' IsDetail = True SQLFieldName = 'AbiFach' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField14: TdaField ChildType = 1 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField15: TdaField ChildType = 1 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField16: TdaField ChildType = 1 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField17: TdaField ChildType = 1 Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField18: TdaField ChildType = 1 Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField19: TdaField ChildType = 1 Alias = 'KursartAllg' DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField20: TdaField ChildType = 1 Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField21: TdaField ChildType = 1 Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField22: TdaField ChildType = 1 Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField23: TdaField ChildType = 1 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField24: TdaField ChildType = 1 Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField25: TdaField ChildType = 1 Alias = 'Bezeichnung' DisplayWidth = 255 FieldAlias = 'Bezeichnung' FieldLength = 255 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField26: TdaField ChildType = 1 Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' SQLFieldName = 'AbiFach' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField27: TdaField ChildType = 2 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField28: TdaField ChildType = 2 Alias = 'Bezeichnung' DisplayWidth = 255 FieldAlias = 'Bezeichnung' FieldLength = 255 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField29: TdaField ChildType = 2 Alias = 'KursartAllg' Ascending = False DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField30: TdaField ChildType = 2 Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField31: TdaField ChildType = 2 Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField32: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField33: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField34: 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 daField36: 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 daField35: 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 object daTableJoin2: TdaTableJoin ChildType = 6 object daField38: TdaField ChildType = 3 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField37: TdaField ChildType = 4 Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daTableJoin3: TdaTableJoin ChildType = 6 object daField40: TdaField ChildType = 3 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField39: TdaField ChildType = 4 Alias = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin4: TdaTableJoin ChildType = 6 object daField42: 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 daField41: 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 = 'Kurse' SQLAlias = 'Kurse' TableAlias = 'Kurse' TableName = 'Kurse' object daTableJoin5: TdaTableJoin ChildType = 6 object daField44: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField43: TdaField ChildType = 4 Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object daTable5: TdaTable ChildType = 5 Alias = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin6: TdaTableJoin ChildType = 6 object daField46: 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 daField45: TdaField ChildType = 4 Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable6: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin7: TdaTableJoin ChildType = 6 object daField48: 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 daField47: 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 end end object daADOQueryDataView3: TdaADOQueryDataView UserName = 'Query_DS_Jgg_06' Height = 293 Left = 471 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 82 TypeColumnWidth = 52 Width = 274 AutoSearchTabOrder = 0 object DS_Jgg_06: TppChildDBPipeline AutoCreateFields = False UserName = 'DS_Jgg_06' object ppField1: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 3 TableName = 'EigeneSchule_Faecher' end object ppField5: TppField FieldAlias = 'Kursart' FieldName = 'Kursart' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'KursartAllg' FieldName = 'KursartAllg' FieldLength = 5 IsDetail = True DisplayWidth = 5 Position = 5 TableName = 'SchuelerLeistungsdaten' end object ppField7: TppField FieldAlias = 'KurzBez' FieldName = 'KurzBez' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 6 TableName = 'Kurse' end object ppField8: TppField FieldAlias = 'LehrerKrz' FieldName = 'LehrerKrz' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 7 TableName = 'Kurse' end object ppField9: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 8 TableName = 'K_Lehrer' end object ppField10: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'COUNT_2' FieldName = 'COUNT_2' FieldLength = 50 DataType = dtInteger DisplayWidth = 50 Position = 10 TableName = 'Schueler' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'DS_Jgg_06' IsCaseSensitive = True GroupByFieldsSynced = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.Name, Schueler.Vorname, ' ' Schueler.Klasse, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.KursartAllg, ' ' Kurse.KurzBez, Kurse.LehrerKrz, ' ' K_Lehrer.Nachname, Schueler.ASDJahrgang, ' ' COUNT(*) AS COUNT_2' 'FROM (((((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID)' ' AND (SchuelerLernabschnittsdaten.Jahr = Schueler.AktSchulj' + 'ahr)' ' AND (SchuelerLernabschnittsdaten.Abschnitt = Schueler.AktA' + 'bschnitt) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN Kurse Kurse ON ' ' (Kurse.ID = SchuelerLeistungsdaten.Kurs_ID) )' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = Kurse.LehrerKrz) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( Schueler.Status IN (2,6) )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' ' AND ( SchuelerLeistungsdaten.Kursart IN ('#39'LK1'#39','#39'LK2'#39','#39'AB3' + #39','#39'AB4'#39') )' ' AND ( Schueler.ASDJahrgang = '#39'06'#39' )' 'GROUP BY Schueler.Name, Schueler.Vorname, ' ' Schueler.Klasse, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.Kursart, ' ' SchuelerLeistungsdaten.KursartAllg, ' ' Kurse.KurzBez, Kurse.LehrerKrz, ' ' K_Lehrer.Nachname, Schueler.ASDJahrgang' 'ORDER BY Schueler.ASDJahrgang, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLeistungsdaten.KursartAllg DESC, ' ' SchuelerLeistungsdaten.Kursart, ' ' Kurse.KurzBez, Schueler.Klasse, ' ' Schueler.Name, Schueler.Vorname') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'COUNT_2' DataType = dtInteger DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'COUNT_2' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' CalcType = dacaCount end object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '2,6' object TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object TdaNumericValue Value = 2.000000000000000000 end object TdaNumericValue Value = 6.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotEqual Value = '+' object TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = 'LK1,LK2,AB3,AB4' object TdaField Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Value = '06' object TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'L_Name' object TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' ShowAllValues = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end end object daField1: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: 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 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 = 'KursartAllg' DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' IsDetail = True SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField7: TdaField Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' IsDetail = True SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField8: TdaField Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' IsDetail = True SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField9: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' IsDetail = True SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField10: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField ChildType = 1 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField ChildType = 1 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField ChildType = 1 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField ChildType = 1 Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField15: TdaField ChildType = 1 Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField16: TdaField ChildType = 1 Alias = 'KursartAllg' DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField17: TdaField ChildType = 1 Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField18: TdaField ChildType = 1 Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField19: TdaField ChildType = 1 Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField20: TdaField ChildType = 1 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField21: TdaField ChildType = 2 Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField22: TdaField ChildType = 2 Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' SQLFieldName = 'FachKrz' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField23: TdaField ChildType = 2 Alias = 'KursartAllg' Ascending = False DisplayWidth = 5 FieldAlias = 'KursartAllg' FieldLength = 5 FieldName = 'KursartAllg' SQLFieldName = 'KursartAllg' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField24: TdaField ChildType = 2 Alias = 'Kursart' DisplayWidth = 5 FieldAlias = 'Kursart' FieldLength = 5 FieldName = 'Kursart' SQLFieldName = 'Kursart' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField25: TdaField ChildType = 2 Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' 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 object daTableJoin2: TdaTableJoin ChildType = 6 object daField32: TdaField ChildType = 3 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField31: TdaField ChildType = 4 Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daTableJoin3: TdaTableJoin ChildType = 6 object daField34: TdaField ChildType = 3 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField33: TdaField ChildType = 4 Alias = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin4: TdaTableJoin ChildType = 6 object daField36: 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 daField35: 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 = 'Kurse' SQLAlias = 'Kurse' TableAlias = 'Kurse' TableName = 'Kurse' object daTableJoin5: TdaTableJoin ChildType = 6 object daField38: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField37: TdaField ChildType = 4 Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object daTable5: TdaTable ChildType = 5 Alias = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin6: TdaTableJoin ChildType = 6 object daField40: 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 daField39: TdaField ChildType = 4 Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable6: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin7: TdaTableJoin ChildType = 6 object daField42: 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 daField41: 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 end end end object raCodeModule2: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365064B70726F6365647572652056 61726961626C65733B0D0A7661720D0A2020736C4A6168726761656E6765203A 2054537472696E674C6973743B0D0A0D0A626567696E0D0A0D0A656E643B0D0A 084361726574506F730102000200000001060A54726150726F6772616D094368 696C645479706502130B50726F6772616D4E616D65060E476C6F62616C4F6E43 72656174650B50726F6772616D54797065070B747450726F6365647572650653 6F75726365064F70726F63656475726520476C6F62616C4F6E4372656174653B 0D0A626567696E0D0A2020736C4A6168726761656E6765203A3D205453547269 6E674C6973742E4372656174653B0D0A656E643B0D0A084361726574506F7301 02000200000001060A54726150726F6772616D094368696C645479706502140B 50726F6772616D4E616D65060F476C6F62616C4F6E44657374726F790B50726F 6772616D54797065070B747450726F63656475726506536F75726365063F7072 6F63656475726520476C6F62616C4F6E44657374726F793B0D0A626567696E0D 0A2020736C4A6168726761656E67652E467265653B0D0A656E643B0D0A084361 726574506F730102000200000001060F5472614576656E7448616E646C65720B 50726F6772616D4E616D65062153797374656D5661726961626C65447275636B 646174756D4F6E476574546578740B50726F6772616D54797065070B74745072 6F63656475726506536F75726365066E70726F6365647572652053797374656D 5661726961626C65447275636B646174756D4F6E476574546578742876617220 546578743A20537472696E67293B0D0A626567696E0D0A0D0A20205465787420 3A3D20275374616E643A2027202B20546578743B0D0A0D0A656E643B0D0A0D43 6F6D706F6E656E744E616D65061853797374656D5661726961626C6544727563 6B646174756D094576656E744E616D6506094F6E47657454657874074576656E 7449440235084361726574506F730102030203000001060F5472614576656E74 48616E646C65720B50726F6772616D4E616D6506154442546578744C65687265 724F6E476574546578740B50726F6772616D54797065070B747450726F636564 75726506536F75726365065C70726F636564757265204442546578744C656872 65724F6E476574546578742876617220546578743A20537472696E67293B0D0A 626567696E0D0A0D0A202054657874203A3D2054657874202B202720273B0D0A 0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060C4442546578744C65 68726572094576656E744E616D6506094F6E47657454657874074576656E7449 440235084361726574506F730102030203000001060F5472614576656E744861 6E646C65720B50726F6772616D4E616D65060F4C6162656C354F6E4765745465 78740B50726F6772616D54797065070B747450726F63656475726506536F7572 63650CC701000070726F636564757265204C6162656C354F6E47657454657874 2876617220546578743A20537472696E67293B0D0A7661720D0A2020736A2C20 686A202C206C7374722C2073656D3A737472696E673B0D0A626567696E0D0A20 200D0A2020736A203A3D20456967656E65536368756C655B27536368756C6A61 6872275D3B0D0A2020686A203A3D20456967656E65536368756C655B27536368 756C6A61687241627363686E697474275D3B0D0A2020696620686A203D202731 27207468656E2073656D3A3D202757696E74657273656D657374657220272065 6C73652073656D3A3D2027536F6D6D657273656D657374657220273B0D0A2020 6C5374723A3D496E74546F5374722828737472746F696E7428736A29202B2031 29206D6F6420313030293B0D0A20206966204C656E677468286C53747229203C 2032207468656E206C5374723A3D273027202B206C5374723B0D0A2020696620 686A203D20273227207468656E20746578743A3D2073656D202B202732302720 2B206C7374723B0D0A2020696620686A203D20273127207468656E2074657874 203A3D2073656D202B20636F707928736A2C312C3429202B20272F27202B206C 5374723B0D0A656E643B0D0A0D0A0D436F6D706F6E656E744E616D6506064C61 62656C35094576656E744E616D6506094F6E47657454657874074576656E7449 440235084361726574506F730102030205000001060F5472614576656E744861 6E646C65720B50726F6772616D4E616D6506124442545F534E616D654F6E4765 74546578740B50726F6772616D54797065070B747450726F6365647572650653 6F75726365067D70726F636564757265204442545F534E616D654F6E47657454 6578742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D 0A20200D0A202054657874203A3D2074657874202B20272C2027202B2044535F 53636875656C65727A61686C656E5B27566F726E616D65275D3B0D0A0D0A656E 643B0D0A0D436F6D706F6E656E744E616D6506094442545F534E616D65094576 656E744E616D6506094F6E47657454657874074576656E744944023508436172 6574506F730102360205000001060F5472614576656E7448616E646C65720B50 726F6772616D4E616D6506144442546578744B757273314F6E47657454657874 0B50726F6772616D54797065070B747450726F63656475726506536F75726365 0C2E01000070726F636564757265204442546578744B757273314F6E47657454 6578742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D 0A69662074657874203D20274C4B3127207468656E20746578743A3D2027312E 204162697475726661636820284C6B292720656C73650D0A6966207465787420 3D20274C4B3227207468656E20746578743A3D2027322E204162697475726661 636820284C6B292720656C73650D0A69662074657874203D2027414233272074 68656E20746578743A3D2027332E20416269747572666163682028476B292720 656C73650D0A69662074657874203D202741423427207468656E20746578743A 3D2027342E20416269747572666163682028476B292720656C73650D0A746578 743A3D20746578743B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D 65060B4442546578744B75727331094576656E744E616D6506094F6E47657454 657874074576656E7449440235084361726574506F730102010209000001060F 5472614576656E7448616E646C65720B50726F6772616D4E616D65060E444254 657874374F6E5072696E740B50726F6772616D54797065070B747450726F6365 6475726506536F75726365068770726F63656475726520444254657874374F6E 5072696E743B0D0A626567696E0D0A696620646274657874372E74657874203D 20274162695F576827207468656E20646274657874372E666F6E742E636F6C6F 723A3D20636C72656420656C736520646274657874372E666F6E742E636F6C6F 723A3D20636C626C61636B3B0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D65060744425465787437094576656E744E616D6506074F6E5072696E740745 76656E7449440220084361726574506F7301025E0203000001060F5472614576 656E7448616E646C65720B50726F6772616D4E616D6506144C6162656C486561 6465724F6E476574546578740B50726F6772616D54797065070B747450726F63 656475726506536F757263650C1B01000070726F636564757265204C6162656C 4865616465724F6E476574546578742876617220546578743A20537472696E67 293B0D0A766172204A67673A20737472696E673B0D0A626567696E0D0A0D0A69 662044535F53636875656C65727A61686C656E5B274153444A61687267616E67 275D203D2027303527207468656E204A67673A3D20272830354720756E642030 354B29270D0A656C7365204A67673A3D20272830364720756E642030364B2927 3B0D0A20200D0A202054657874203A3D2027416E7A61686C2053747564696572 656E646520696D2065727374656E20626973207669657274656E204162697475 7266616368206E616368204661636820756E64204B7572732027202B204A6767 3B200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060B4C616265 6C486561646572094576656E744E616D6506094F6E4765745465787407457665 6E7449440235084361726574506F7301025B0208000001060F5472614576656E 7448616E646C65720B50726F6772616D4E616D6506105269636854657874314F 6E5072696E740B50726F6772616D54797065070B747450726F63656475726506 536F75726365066070726F636564757265205269636854657874314F6E507269 6E743B0D0A626567696E0D0A5269636854657874312E76697369626C653A3D20 44535F4A67675F30365B274153444A61687267616E67275D203D20273036273B 0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506095269636854657874 31094576656E744E616D6506074F6E5072696E74074576656E74494402200843 61726574506F7301022D0203000001060F5472614576656E7448616E646C6572 0B50726F6772616D4E616D65061F43726F7373546162476573616D74314F6E47 657443617074696F6E546578740B50726F6772616D54797065070B747450726F 63656475726506536F757263650C3802000070726F6365647572652043726F73 73546162476573616D74314F6E47657443617074696F6E546578742861456C65 6D656E743A20547070456C656D656E743B2061436F6C756D6E3A20496E746567 65723B2061526F773A20496E74656765723B20636F6E73742061446973706C61 79466F726D61743A20537472696E673B206156616C75653A2056617269616E74 3B207661722061546578743A20537472696E67293B0D0A626567696E0D0A0D0A 20204966206154657874203D2027466163684B727A27205468656E2061546578 743A3D202746616368273B0D0A20204966206154657874203D20274B75727361 7274416C6C6727205468656E2061546578743A3D20274B757273617274273B0D 0A20206966206174657874203D20274B75727361727427207468656E20617465 78743A3D202741626974757266616368273B0D0A20206966206174657874203D 20274E6163686E616D6527207468656E2061746578743A3D2027466163686C65 687265722F696E273B0D0A20200D0A20206966206174657874203D2027414233 27207468656E2061746578743A3D2027332E2028476B29273B0D0A2020696620 6174657874203D202741423427207468656E2061746578743A3D2027342E2028 476B29273B200D0A20206966206174657874203D20274C4B3127207468656E20 61746578743A3D2027312E20284C6B29273B200D0A2020696620617465787420 3D20274C4B3227207468656E2061746578743A3D2027322E20284C6B29273B20 0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060F43726F737354 6162476573616D7431094576656E744E616D6506104F6E47657443617074696F 6E54657874074576656E7449440238084361726574506F7301021B0208000001 060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060D4C 615F6578744F6E5072696E740B50726F6772616D54797065070B747450726F63 656475726506536F75726365065D70726F636564757265204C615F6578744F6E 5072696E743B0D0A626567696E0D0A20204C615F6578742E76697369626C653A 3D2044535F53636875656C65727A61686C656E5B27537461747573275D203D20 363B200D0A656E643B0D0A0D436F6D706F6E656E744E616D6506064C615F6578 74094576656E744E616D6506074F6E5072696E74074576656E74494402200843 61726574506F730102340203000001060F5472614576656E7448616E646C6572 0B50726F6772616D4E616D650613444254657874466163684F6E476574546578 740B50726F6772616D54797065070B747450726F63656475726506536F757263 65069570726F63656475726520444254657874466163684F6E47657454657874 2876617220546578743A20537472696E67293B0D0A626567696E0D0A0D0A2020 546578743A3D205265706C6163655465787428546578742C2747657363686963 68746520756E6420536F7A69616C77697373656E736368616674272C27476573 636869636874652F535727293B200D0A0D0A656E643B0D0A0D436F6D706F6E65 6E744E616D65060A44425465787446616368094576656E744E616D6506094F6E 47657454657874074576656E7449440235084361726574506F73010250020400 0000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end object ppParameterList2: TppParameterList object ppParameter2: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Nachname' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'DS_Schuelerzahlen' DataType = dtString LookupSettings.NameField = 'Nachname' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Nachname' LookupSettings.DataPipelineName = 'DS_Schuelerzahlen' Value = '' UserName = 'L_Name' end object ppParameter3: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'AbiFach' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'DS_Schuelerzahlen' DataType = dtString LookupSettings.NameField = 'AbiFach' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'AbiFach' LookupSettings.DataPipelineName = 'DS_Schuelerzahlen' Value = '' UserName = 'SLAD_AbiFach' end end end