object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Z_Warnungen_Lehrer PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Lehrer_Warnungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 7000 PrinterSetup.mmMarginLeft = 25000 PrinterSetup.mmMarginRight = 7000 PrinterSetup.mmMarginTop = 7000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\Schild-NRW\Schild-Reports\ASGSG-Reports\ab_2014\Lehrer\Lehrer' + '_Warnungen.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 = False ThumbnailSettings.Visible = False ThumbnailSettings.DeadSpace = 30 PDFSettings.EmbedFontOptions = [] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.EncryptSettings.KeyLength = kl40Bit PDFSettings.FontEncoding = feAnsi PDFSettings.ImageCompressionLevel = 25 PreviewFormSettings.ZoomSetting = zs100Percent PreviewFormSettings.SinglePageOnly = True RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] ShowAutoSearchDialog = True TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'ReportBuilder' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'Z_Warnungen_Lehrer' object ppHeaderBand2: TppHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 15610 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Warnungen je Lehrkraft' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 47361 BandType = 0 LayerName = Foreground end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Klasse' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 20000 mmTop = 7000 mmWidth = 10319 BandType = 0 LayerName = Foreground end object ppLabel2: TppLabel UserName = 'Label2' Caption = 'Fach' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 40000 mmTop = 7000 mmWidth = 7938 BandType = 0 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Note' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 55000 mmTop = 7000 mmWidth = 7408 BandType = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Name, Vorname' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 80000 mmTop = 7000 mmWidth = 26194 BandType = 0 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Warndatum' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 140000 mmTop = 7000 mmWidth = 19050 BandType = 0 LayerName = Foreground end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 158141 mmTop = 0 mmWidth = 16933 BandType = 0 LayerName = Foreground end object ppLine1: TppLine UserName = 'Line1' ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 2000 mmLeft = 0 mmTop = 12758 mmWidth = 178000 BandType = 0 LayerName = Foreground end object ppLabel7: TppLabel UserName = 'Label7' Caption = 'Druck:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4233 mmLeft = 142453 mmTop = 0 mmWidth = 10848 BandType = 0 LayerName = Foreground end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'K'#252'rzel' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4234 mmLeft = 0 mmTop = 6879 mmWidth = 10583 BandType = 0 LayerName = Foreground end end object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 8467 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Kuerzel' DataPipeline = daADOQueryDataView1.Z_Warnungen_Lehrer Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Z_Warnungen_Lehrer' mmHeight = 4498 mmLeft = 0 mmTop = 2000 mmWidth = 17198 BandType = 4 LayerName = Foreground end object ppSubReport1: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 5027 mmLeft = 20000 mmTop = 2000 mmWidth = 150019 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Lehrer_Warnungen.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 7000 PrinterSetup.mmMarginLeft = 25000 PrinterSetup.mmMarginRight = 7000 PrinterSetup.mmMarginTop = 7000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 178000 DataPipelineName = 'Z_Warnungen_Schueler' object ppHeaderBand1: TppHeaderBand Background.Brush.Style = bsClear Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom] Border.Visible = True PrintHeight = phDynamic PrintOnFirstPage = False PrintOnLastPage = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 10319 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'FachKrz' DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 4233 mmLeft = 22490 mmTop = 0 mmWidth = 13758 BandType = 4 LayerName = Foreground1 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'Klasse' DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 4498 mmLeft = 0 mmTop = 0 mmWidth = 17198 BandType = 4 LayerName = Foreground1 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Name' DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 4498 mmLeft = 60000 mmTop = 0 mmWidth = 30956 BandType = 4 LayerName = Foreground1 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'Warndatum' DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 4498 mmLeft = 120000 mmTop = 0 mmWidth = 46038 BandType = 4 LayerName = Foreground1 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'NotenKrz' DataPipeline = daADOQueryDataView2.Z_Warnungen_Schueler Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Z_Warnungen_Schueler' mmHeight = 4233 mmLeft = 35000 mmTop = 0 mmWidth = 15346 BandType = 4 LayerName = Foreground1 end object ppLine2: TppLine UserName = 'Line2' Pen.Style = psDot Weight = 0.750000000000000000 mmHeight = 2000 mmLeft = 0 mmTop = 6996 mmWidth = 158000 BandType = 4 LayerName = Foreground1 end end object raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650610 444254657874364F6E476574546578740B50726F6772616D54797065070B7474 50726F63656475726506536F75726365066F70726F6365647572652044425465 7874364F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A202069662054657874203D2027275468656E20546578 74203A3D20276F686E65205761726E646174756D273B200D0A0D0A656E643B0D 0A0D436F6D706F6E656E744E616D65060744425465787436094576656E744E61 6D6506094F6E47657454657874074576656E7449440235084361726574506F73 01022D0204000001060F5472614576656E7448616E646C65720B50726F677261 6D4E616D650610444254657874344F6E476574546578740B50726F6772616D54 797065070B747450726F63656475726506536F75726365067B70726F63656475 726520444254657874344F6E476574546578742876617220546578743A205374 72696E67293B0D0A626567696E0D0A0D0A202054657874203A3D205465787420 2B20272C20272B2020205A5F5761726E756E67656E5F53636875656C65725B27 566F726E616D65275D3B0D0A0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D65060744425465787434094576656E744E616D6506094F6E47657454657874 074576656E7449440235084361726574506F7301023A0204000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end end end object ppLine3: TppLine UserName = 'Line3' ParentWidth = True Weight = 0.750000000000000000 mmHeight = 500 mmLeft = 0 mmTop = 0 mmWidth = 178000 BandType = 4 LayerName = Foreground end end object ppGroup1: TppGroup BreakName = 'Kuerzel' DataPipeline = daADOQueryDataView1.Z_Warnungen_Lehrer GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Z_Warnungen_Lehrer' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Z_Warnungen_Lehrer' Height = 250 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 317 AutoSearchTabOrder = 0 object Z_Warnungen_Lehrer: TppChildDBPipeline AutoCreateFields = False UserName = 'Z_Warnungen_Lehrer' object ppField1: TppField FieldAlias = 'Kuerzel' FieldName = 'Kuerzel' FieldLength = 10 DisplayWidth = 10 Position = 0 TableName = 'K_Lehrer' end object ppField2: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 DisplayWidth = 30 Position = 1 TableName = 'K_Lehrer' end object ppField3: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 20 DisplayWidth = 20 Position = 2 TableName = 'K_Lehrer' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Z_Warnungen_Lehrer' Distinct = True IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT DISTINCT K_Lehrer.Kuerzel, ' ' K_Lehrer.Nachname, ' ' K_Lehrer.Vorname' 'FROM K_Lehrer K_Lehrer') SQLType = sqSQL2 object daField1: TdaField Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField2: TdaField Alias = 'Nachname' DisplayWidth = 30 FieldAlias = 'Nachname' FieldLength = 30 FieldName = 'Nachname' SQLFieldName = 'Nachname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField3: TdaField Alias = 'Vorname' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daTable1: TdaTable ChildType = 5 Alias = 'K_Lehrer' JoinType = dajtNone SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_Z_Warnungen_Schueler' Height = 278 Left = 440 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 14 TypeColumnWidth = 52 Width = 470 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Z_Warnungen_Lehrer' object Z_Warnungen_Schueler: TppChildDBPipeline AutoCreateFields = False UserName = 'Z_Warnungen_Schueler' MasterDataPipelineName = 'Z_Warnungen_Lehrer' object ppField1: TppField FieldAlias = 'FachLehrer' FieldName = 'FachLehrer' FieldLength = 10 IsDetail = True DisplayWidth = 10 Position = 0 TableName = 'SchuelerLeistungsdaten' end object ppField2: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'Warnung' FieldName = 'Warnung' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 3 TableName = 'SchuelerLeistungsdaten' end object ppField5: TppField FieldAlias = 'Warndatum' FieldName = 'Warndatum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 4 TableName = 'SchuelerLeistungsdaten' end object ppField6: TppField FieldAlias = 'FachKrz' FieldName = 'FachKrz' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 5 TableName = 'EigeneSchule_Faecher' end object ppField7: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 6 TableName = 'SchuelerLernabschnittsdaten' end object ppField8: TppField FieldAlias = 'NotenKrz' FieldName = 'NotenKrz' FieldLength = 2 IsDetail = True DisplayWidth = 2 Position = 7 TableName = 'SchuelerLeistungsdaten' end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'Z_Warnungen_Schueler' IsCaseSensitive = True LinkColor = clNavy LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT SchuelerLeistungsdaten.FachLehrer, ' ' Schueler.Name, Schueler.Vorname, ' ' SchuelerLeistungsdaten.Warnung, ' ' SchuelerLeistungsdaten.Warndatum, ' ' EigeneSchule_Faecher.FachKrz, ' ' SchuelerLernabschnittsdaten.Klasse, ' ' SchuelerLeistungsdaten.NotenKrz' 'FROM (((Schueler Schueler' ' INNER JOIN SchuelerLernabschnittsdaten SchuelerLernabschni' + 'ttsdaten ON ' ' (SchuelerLernabschnittsdaten.Schueler_ID = Schueler.ID) )' ' INNER JOIN SchuelerLeistungsdaten SchuelerLeistungsdaten O' + 'N ' ' (SchuelerLeistungsdaten.Abschnitt_ID = SchuelerLernabschnit' + 'tsdaten.ID) )' ' INNER JOIN EigeneSchule_Faecher EigeneSchule_Faecher ON ' ' (EigeneSchule_Faecher.ID = SchuelerLeistungsdaten.Fach_ID) ' + ')' 'WHERE ( SchuelerLernabschnittsdaten.Jahr = 2023 )' ' AND ( SchuelerLernabschnittsdaten.Abschnitt = 2 )' ' AND ( SchuelerLeistungsdaten.Warnung = '#39'+'#39' )' ' AND ( Schueler.Status = 2 )' 'ORDER BY SchuelerLeistungsdaten.FachLehrer, ' ' Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Value = '2023' object TdaField Alias = 'Jahr' AutoSearch = True DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Jahr' FieldLength = 0 FieldName = 'Jahr' Mandatory = True SQLFieldName = 'Jahr' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object TdaNumericValue Value = 2023.000000000000000000 end end object daCriteria2: TdaCriteria ChildType = 7 Level = 0 Value = '2' object TdaField Alias = 'Abschnitt' AutoSearch = True DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Abschnitt' FieldLength = 0 FieldName = 'Abschnitt' Mandatory = True SQLFieldName = 'Abschnitt' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object TdaNumericValue Value = 2.000000000000000000 end end object daCriteria3: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end object daCriteria4: 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 daField1: TdaField Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField2: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'Warnung' DisplayWidth = 1 FieldAlias = 'Warnung' FieldLength = 1 FieldName = 'Warnung' IsDetail = True SQLFieldName = 'Warnung' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField5: TdaField Alias = 'Warndatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Warndatum' FieldLength = 0 FieldName = 'Warndatum' IsDetail = True SQLFieldName = 'Warndatum' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField6: 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 daField7: TdaField Alias = 'Klasse' DisplayWidth = 15 FieldAlias = 'Klasse' FieldLength = 15 FieldName = 'Klasse' IsDetail = True SQLFieldName = 'Klasse' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end object daField8: TdaField Alias = 'NotenKrz' DisplayWidth = 2 FieldAlias = 'NotenKrz' FieldLength = 2 FieldName = 'NotenKrz' IsDetail = True SQLFieldName = 'NotenKrz' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField9: TdaField ChildType = 2 Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end object daField10: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 15 FieldAlias = 'Klasse' FieldLength = 15 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: 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 daField14: 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 daField13: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable3: TdaTable ChildType = 5 Alias = 'SchuelerLeistungsdaten' SQLAlias = 'SchuelerLeistungsdaten' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' object daTableJoin2: TdaTableJoin ChildType = 6 object daField16: 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 daField15: TdaField ChildType = 4 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'SchuelerLernabschnittsdaten' TableName = 'SchuelerLernabschnittsdaten' TableSQLAlias = 'SchuelerLernabschnittsdaten' end end end object daTable4: TdaTable ChildType = 5 Alias = 'EigeneSchule_Faecher' SQLAlias = 'EigeneSchule_Faecher' TableAlias = 'EigeneSchule_Faecher' TableName = 'EigeneSchule_Faecher' object daTableJoin3: TdaTableJoin ChildType = 6 object daField18: 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 daField17: TdaField ChildType = 4 Alias = 'Fach_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Fach_ID' FieldLength = 0 FieldName = 'Fach_ID' SQLFieldName = 'Fach_ID' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end object TdaSQLLink ChildType = 9 object daField19: TdaField ChildType = 10 Alias = 'Kuerzel' DisplayWidth = 10 FieldAlias = 'Kuerzel' FieldLength = 10 FieldName = 'Kuerzel' SQLFieldName = 'Kuerzel' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField20: TdaField ChildType = 11 Alias = 'FachLehrer' DisplayWidth = 10 FieldAlias = 'FachLehrer' FieldLength = 10 FieldName = 'FachLehrer' IsDetail = True SQLFieldName = 'FachLehrer' TableAlias = 'SchuelerLeistungsdaten' TableName = 'SchuelerLeistungsdaten' TableSQLAlias = 'SchuelerLeistungsdaten' end end end end end object raCodeModule2: TraCodeModule ProgramStream = {00} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList2: TppParameterList object ppArchivierung: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True AutoSearchSettings.SearchExpression = 'Schildvorgabe' DataType = dtString LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 'Schildvorgabe' UserName = 'Archivierung' end end end