object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Kurs_Tabelle PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = #220'bersicht_Kursweise_Sch'#252'ler_mit_Nachpr'#252'fungen_nach Kursen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 15000 PrinterSetup.mmMarginLeft = 6000 PrinterSetup.mmMarginRight = 6000 PrinterSetup.mmMarginTop = 15000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\Abitur_eigene_Reports\1.-3. Fach\Na' + 'chpr'#252'fungen\'#220'bersicht_Kursweise_Sch'#252'ler_mit_Nachpr'#252'fungen_nach K' + 'ursen.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 = [efUseSubset] 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.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 = 0 DataPipelineName = 'Kurs_Tabelle' object ppHeaderBand1: TppHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 27517 mmPrintPosition = 0 object rbTableGrid1: TrbTableGrid UserName = 'TableGrid1' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] ShowCoordinates = False ShiftWithParent = False mmHeight = 7673 mmLeft = 265 mmTop = 16404 mmWidth = 197380 BandType = 0 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 CellsData = ( 1 9 94 108 74 93 66 83 81 0 145 24 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67372036) end object ppLabel2: TppLabel UserName = 'Label2' Caption = #220'bersicht Sch'#252'ler mit Nachpr'#252'fungen' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5080 mmLeft = 60061 mmTop = 3440 mmWidth = 76271 BandType = 0 LayerName = Foreground end object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Name' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 6615 mmTop = 17463 mmWidth = 11377 BandType = 0 LayerName = Foreground end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Vorname' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 30163 mmTop = 17463 mmWidth = 17992 BandType = 0 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Pr'#252'fer' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 79375 mmTop = 17463 mmWidth = 12435 BandType = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Kurs' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 58473 mmTop = 17463 mmWidth = 9525 BandType = 0 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Reihenf.' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5080 mmLeft = 118269 mmTop = 17463 mmWidth = 16722 BandType = 0 LayerName = Foreground end object ppLabel7: TppLabel UserName = 'Label7' Caption = 'Datum' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5080 mmLeft = 141288 mmTop = 17463 mmWidth = 13123 BandType = 0 LayerName = Foreground end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'Pr'#252'fungsbeginn' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 160602 mmTop = 17463 mmWidth = 34660 BandType = 0 LayerName = Foreground end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Abifach' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 5080 mmLeft = 99219 mmTop = 17463 mmWidth = 15381 BandType = 0 LayerName = Foreground end end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object rbTableGrid2: TrbTableGrid UserName = 'TableGrid2' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] ParentHeight = True ShowCoordinates = False ShiftWithParent = False mmHeight = 6879 mmLeft = 265 mmTop = 0 mmWidth = 197380 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 CellsData = ( 1 8 96 107 74 93 66 84 80 144 27 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67109892 536871184 67372036) end object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Name' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4763 mmLeft = 1323 mmTop = 1058 mmWidth = 24077 BandType = 4 LayerName = Foreground end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'Vorname' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4763 mmLeft = 26723 mmTop = 1058 mmWidth = 26988 BandType = 4 LayerName = Foreground end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'KurzBez' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4868 mmLeft = 54769 mmTop = 1058 mmWidth = 17198 BandType = 4 LayerName = Foreground end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'LehrerKrz' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4868 mmLeft = 76994 mmTop = 1058 mmWidth = 17198 BandType = 4 LayerName = Foreground end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'MdlPruefFolge' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4763 mmLeft = 118004 mmTop = 1058 mmWidth = 17198 BandType = 4 LayerName = Foreground end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'AbiFach' DataPipeline = daADOQueryDataView1.Kurs_Tabelle Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'Kurs_Tabelle' mmHeight = 4868 mmLeft = 99219 mmTop = 1058 mmWidth = 15346 BandType = 4 LayerName = Foreground end end object ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroup1: TppGroup BreakName = 'KurzBez' DataPipeline = daADOQueryDataView1.Kurs_Tabelle GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Kurs_Tabelle' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 2910 mmPrintPosition = 0 end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 2117 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Kurs_Tabelle' Height = 195 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 275 AutoSearchTabOrder = 0 object Kurs_Tabelle: TppChildDBPipeline AutoCreateFields = False UserName = 'Kurs_Tabelle' object ppField1: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'LehrerKrz' FieldName = 'LehrerKrz' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 2 TableName = 'Kurse' end object ppField4: TppField FieldAlias = 'KurzBez' FieldName = 'KurzBez' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 3 TableName = 'Kurse' end object ppField5: TppField FieldAlias = 'Kurs_ID' FieldName = 'Kurs_ID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 5 TableName = 'Schueler' end object ppField7: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'Kurse' end object ppField8: TppField FieldAlias = 'AbiFach' FieldName = 'AbiFach' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 7 TableName = 'SchuelerAbiFaecher' end object ppField9: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 8 TableName = 'SchuelerAbiFaecher' end object ppField10: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 80 IsDetail = True DisplayWidth = 80 Position = 9 TableName = 'EigeneSchule_Faecher' end object ppField11: TppField FieldAlias = 'AbiPruefErgebnis' FieldName = 'AbiPruefErgebnis' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'SchuelerAbiFaecher' end object ppField12: TppField FieldAlias = 'MdlPruefFolge' FieldName = 'MdlPruefFolge' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 11 TableName = 'SchuelerAbiFaecher' end object ppField13: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 12 TableName = 'Schueler' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Kurs_Tabelle' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.Vorname, Schueler.Name, ' ' Kurse.LehrerKrz, Kurse.KurzBez, ' ' SchuelerLeistungsdaten.Kurs_ID, ' ' Schueler.Klasse, Kurse.ASDJahrgang, ' ' SchuelerAbiFaecher.AbiFach, ' ' SchuelerAbiFaecher.FachKrz, ' ' EigeneSchule_Faecher.Bezeichnung, ' ' SchuelerAbiFaecher.AbiPruefErgebnis, ' ' SchuelerAbiFaecher.MdlPruefFolge, ' ' Schueler.ID' 'FROM (((((Kurse Kurse' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Kurs_ID = Kurse.ID) )' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.ID = SchuelerLeistungsdaten.Ab' + 'schnitt_ID) )' ' INNER JOIN Schueler Schueler ON ' ' (Schueler.ID = SchuelerLernabschnittsdaten.Schueler_ID)' ' AND (Schueler.AktSchuljahr = Kurse.Jahr)' ' AND (Schueler.AktAbschnitt = Kurse.Abschnitt) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = Kurse.Fach_ID) )' ' INNER JOIN SchuelerAbiFaecher SchuelerAbiFaecher ON ' ' (SchuelerAbiFaecher.Schueler_ID = Schueler.ID)' ' AND (SchuelerAbiFaecher.AbiFach = SchuelerLeistungsdaten.A' + 'biFach) )' 'WHERE ( Schueler.Status = 2 ) AND NOT ' ' ( Schueler.Geloescht = '#39'+'#39' )' ' AND ( SchuelerAbiFaecher.AbiFach IN ('#39'1'#39','#39'2'#39','#39'3'#39') )' ' AND ((( SchuelerAbiFaecher.MdlPflichtPruefung = '#39'+'#39' )' ' OR ( SchuelerAbiFaecher.MdlFreiwPruefung = '#39'+'#39' )' ' OR ( SchuelerAbiFaecher.MdlBestPruefung = '#39'+'#39' )' ' ))' 'ORDER BY Kurse.ID, Kurse.KurzBez, Schueler.Name, ' ' Schueler.Vorname, ' ' SchuelerAbiFaecher.MdlPruefFolge') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 object TdaField Alias = 'KurzBez' AutoSearch = True DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Value = '2' 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 end object daCriteria3: TdaCriteria ChildType = 7 CriteriaType = dacrNOT Level = 0 end object daCriteria4: 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 daCriteria5: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList Value = '1,2,3' object TdaField Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' SQLFieldName = 'AbiFach' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end end object daCriteria6: TdaCriteria ChildType = 7 CriteriaType = dacrBegin Level = 0 end object daCriteria7: TdaCriteria ChildType = 7 CriteriaType = dacrBegin Level = 0 end object daCriteria8: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'MdlPflichtPruefung' DisplayWidth = 1 FieldAlias = 'MdlPflichtPruefung' FieldLength = 1 FieldName = 'MdlPflichtPruefung' SQLFieldName = 'MdlPflichtPruefung' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end end object daCriteria9: TdaCriteria ChildType = 7 CriteriaType = dacrOR Level = 0 end object daCriteria10: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'MdlFreiwPruefung' DisplayWidth = 1 FieldAlias = 'MdlFreiwPruefung' FieldLength = 1 FieldName = 'MdlFreiwPruefung' SQLFieldName = 'MdlFreiwPruefung' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end end object daCriteria11: TdaCriteria ChildType = 7 CriteriaType = dacrOR Level = 0 end object daCriteria12: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'MdlBestPruefung' DisplayWidth = 1 FieldAlias = 'MdlBestPruefung' FieldLength = 1 FieldName = 'MdlBestPruefung' SQLFieldName = 'MdlBestPruefung' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end end object daCriteria13: TdaCriteria ChildType = 7 CriteriaType = dacrEnd Level = 0 end object daCriteria14: TdaCriteria ChildType = 7 CriteriaType = dacrEnd Level = 0 end object daField1: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' IsDetail = True SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'LehrerKrz' DisplayWidth = 10 FieldAlias = 'LehrerKrz' FieldLength = 10 FieldName = 'LehrerKrz' IsDetail = True SQLFieldName = 'LehrerKrz' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField4: TdaField Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' IsDetail = True SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField5: TdaField Alias = 'Kurs_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Kurs_ID' FieldLength = 0 FieldName = 'Kurs_ID' IsDetail = True SQLFieldName = 'Kurs_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: TdaField Alias = 'Klasse' DisplayWidth = 15 FieldAlias = 'Klasse' FieldLength = 15 FieldName = 'Klasse' IsDetail = True SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField7: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField8: TdaField Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' IsDetail = True SQLFieldName = 'AbiFach' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField9: TdaField Alias = 'FachKrz' DisplayWidth = 20 FieldAlias = 'FachKrz' FieldLength = 20 FieldName = 'FachKrz' IsDetail = True SQLFieldName = 'FachKrz' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField10: TdaField Alias = 'Bezeichnung' DisplayWidth = 80 FieldAlias = 'Bezeichnung' FieldLength = 80 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' TableSQLAlias = 'EigeneSchule_Faecher' end object daField11: TdaField Alias = 'AbiPruefErgebnis' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AbiPruefErgebnis' FieldLength = 0 FieldName = 'AbiPruefErgebnis' IsDetail = True SQLFieldName = 'AbiPruefErgebnis' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField12: TdaField Alias = 'MdlPruefFolge' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'MdlPruefFolge' FieldLength = 0 FieldName = 'MdlPruefFolge' IsDetail = True SQLFieldName = 'MdlPruefFolge' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField13: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' IsDetail = True SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField ChildType = 2 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField15: TdaField ChildType = 2 Alias = 'KurzBez' DisplayWidth = 20 FieldAlias = 'KurzBez' FieldLength = 20 FieldName = 'KurzBez' SQLFieldName = 'KurzBez' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end object daField16: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField17: TdaField ChildType = 2 Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField18: TdaField ChildType = 2 Alias = 'MdlPruefFolge' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'MdlPruefFolge' FieldLength = 0 FieldName = 'MdlPruefFolge' SQLFieldName = 'MdlPruefFolge' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daTable1: TdaTable ChildType = 5 Alias = 'Kurse' SQLAlias = 'Kurse' TableAlias = 'Kurse' TableName = 'Kurse' object daTableJoin1: TdaTableJoin ChildType = 6 object daField20: 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 daField19: 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 daTable2: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField22: TdaField ChildType = 3 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 object daField21: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLernabschnittsdaten' SQLAlias = 'SchuelerLernabschnittsdaten' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' object daTableJoin3: TdaTableJoin ChildType = 6 object daField24: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField23: TdaField ChildType = 4 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 end end object daTable4: TdaTable ChildType = 5 Alias = 'Schueler' SQLAlias = 'Schueler' TableAlias = 'Schueler' TableName = 'Schueler' object daTableJoin4: TdaTableJoin ChildType = 6 object daField26: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField25: TdaField ChildType = 4 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 end object daTableJoin5: TdaTableJoin ChildType = 6 object daField28: TdaField ChildType = 3 Alias = 'AktSchuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktSchuljahr' FieldLength = 0 FieldName = 'AktSchuljahr' SQLFieldName = 'AktSchuljahr' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField27: TdaField ChildType = 4 Alias = 'Jahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' SQLFieldName = 'Jahr' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end object daTableJoin6: TdaTableJoin ChildType = 6 object daField30: TdaField ChildType = 3 Alias = 'AktAbschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'AktAbschnitt' FieldLength = 0 FieldName = 'AktAbschnitt' SQLFieldName = 'AktAbschnitt' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField29: TdaField ChildType = 4 Alias = 'Abschnitt' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' SQLFieldName = 'Abschnitt' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable5: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin7: TdaTableJoin ChildType = 6 object daField32: 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 daField31: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'Kurse' TableName = 'Kurse' TableSQLAlias = 'Kurse' end end end object daTable6: TdaTable ChildType = 5 Alias = 'SchuelerAbiFaecher' SQLAlias = 'SchuelerAbiFaecher' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' object daTableJoin8: TdaTableJoin ChildType = 6 object daField34: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField33: 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 daTableJoin9: TdaTableJoin ChildType = 6 object daField36: TdaField ChildType = 3 Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' SQLFieldName = 'AbiFach' TableAlias = 'SchuelerAbiFaecher' TableName = 'SchuelerAbiFaecher' TableSQLAlias = 'SchuelerAbiFaecher' end object daField35: TdaField ChildType = 4 Alias = 'AbiFach' DisplayWidth = 1 FieldAlias = 'AbiFach' FieldLength = 1 FieldName = 'AbiFach' SQLFieldName = 'AbiFach' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end end end end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList1: TppParameterList object ppArchivierung: TppParameter AutoSearchSettings.FieldAlias = 'LehrerKrz' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchExpression = 'Schildvorgabe' AutoSearchSettings.SearchOperator = soInList DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'Schildvorgabe' UserName = 'Archivierung' end end end