object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView2.SuS PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = '01_Klassenliste_nur_SuS_mit_gewaehlter_Vermerkart_und_Text.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 5000 PrinterSetup.mmMarginLeft = 20000 PrinterSetup.mmMarginRight = 5000 PrinterSetup.mmMarginTop = 5000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\ASGSG-Reports\ab_2014\Listen\01_Kla' + 'ssenliste_nur_SuS_mit_gewaehlter_Vermerkart_und_Text.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 EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = 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 = False OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True ThumbnailSettings.Enabled = True ThumbnailSettings.Visible = True ThumbnailSettings.DeadSpace = 30 PDFSettings.Author = 'Schild-NRW' 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 = -15 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 = 180000 DataPipelineName = 'SuS' object ppDetailBand1: TppDetailBand Background1.Brush.Color = clSilver Background2.Brush.Style = bsClear ColumnBalancing = True mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Bezeichnung' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 0 mmTop = 0 mmWidth = 55563 BandType = 4 LayerName = Foreground end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'Datum' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 58208 mmTop = 0 mmWidth = 9790 BandType = 4 LayerName = Foreground end end object ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 3969 mmPrintPosition = 0 object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' VarType = vtDocumentName Font.Charset = DEFAULT_CHARSET Font.Color = 9868950 Font.Name = 'Arial' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 265 mmTop = 0 mmWidth = 183092 BandType = 8 LayerName = Foreground end end object ppGroup2: TppGroup BreakName = 'Bezeichnung' DataPipeline = daADOQueryDataView2.SuS GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS' NewFile = False object ppGroupHeaderBand2: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 13758 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBT_Klasse' AutoSize = True DataField = 'Klasse' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold] Transparent = True DataPipelineName = 'SuS' mmHeight = 4763 mmLeft = 265 mmTop = 0 mmWidth = 12700 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'Nachname' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'SuS' mmHeight = 4763 mmLeft = 163777 mmTop = 0 mmWidth = 19579 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppShape1: TppShape UserName = 'Shape1' Brush.Color = 9868950 ParentWidth = True Pen.Style = psClear mmHeight = 6085 mmLeft = 0 mmTop = 7673 mmWidth = 185000 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Name ' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 7938 mmTop = 8467 mmWidth = 10848 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Vorname ' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 59796 mmTop = 8467 mmWidth = 16404 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Text' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 105040 mmTop = 8467 mmWidth = 7408 BandType = 3 GroupNo = 0 LayerName = Foreground end end object ppGroupFooterBand2: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object ppGroup1: TppGroup BreakName = 'Klasse' DataPipeline = daADOQueryDataView2.SuS GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False PreventOrphans = True OutlineSettings.CreateNode = True NewPage = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS' 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 ppGroup3: TppGroup BreakName = 'ID' DataPipeline = daADOQueryDataView2.SuS GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group3' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'SuS' NewFile = False object ppGroupHeaderBand3: TppGroupHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DataField = 'Name' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True VerticalAlignment = avCenter DBCalcType = dcCount DataPipelineName = 'SuS' mmHeight = 4498 mmLeft = 265 mmTop = 1057 mmWidth = 5292 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppDBText3: TppDBText UserName = 'Name' DataField = 'Name' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True VerticalAlignment = avCenter DataPipelineName = 'SuS' mmHeight = 3969 mmLeft = 7938 mmTop = 1324 mmWidth = 47361 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppDBText6: TppDBText UserName = 'Vorname' DataField = 'Vorname' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True VerticalAlignment = avCenter DataPipelineName = 'SuS' mmHeight = 3969 mmLeft = 59796 mmTop = 1058 mmWidth = 45773 BandType = 3 GroupNo = 1 LayerName = Foreground end object ppDBText7: TppDBText UserName = 'Vorname1' DataField = 'Bemerkung' DataPipeline = daADOQueryDataView2.SuS Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 9 Font.Style = [] Transparent = True VerticalAlignment = avCenter DataPipelineName = 'SuS' mmHeight = 3969 mmLeft = 105034 mmTop = 1323 mmWidth = 72496 BandType = 3 GroupNo = 2 LayerName = Foreground end end object ppGroupFooterBand3: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 1588 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Pen.Color = 9868950 Pen.Style = psDot ParentWidth = True Position = lpBottom Weight = 0.750000000000000000 mmHeight = 1588 mmLeft = 0 mmTop = 0 mmWidth = 185000 BandType = 5 GroupNo = 1 LayerName = Foreground end end end object daDataModule1: TdaDataModule object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_SuS' Height = 418 Left = 102 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 47 TypeColumnWidth = 52 Width = 380 AutoSearchTabOrder = 0 object SuS: TppChildDBPipeline AutoCreateFields = False UserName = 'SuS' object ppField1: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 3 TableName = 'Schueler' end object ppField5: TppField FieldAlias = 'Nachname' FieldName = 'Nachname' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 4 TableName = 'K_Lehrer' end object ppField6: TppField FieldAlias = 'Vorname (2)' FieldName = 'Vorname_2' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 5 TableName = 'K_Lehrer' end object ppField7: TppField FieldAlias = 'Geschlecht' FieldName = 'Geschlecht' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 6 TableName = 'K_Lehrer' end object ppField8: TppField FieldAlias = 'Schuljahr' FieldName = 'Schuljahr' FieldLength = 0 IsDetail = True DataType = dtInteger DisplayWidth = 10 Position = 7 TableName = 'EigeneSchule' end object ppField9: TppField FieldAlias = 'SchuljahrAbschnitt' FieldName = 'SchuljahrAbschnitt' FieldLength = 0 IsDetail = True DataType = dtLongint DisplayWidth = 10 Position = 8 TableName = 'EigeneSchule' end object ppField10: TppField FieldAlias = 'Geschlecht (2)' FieldName = 'Geschlecht_2' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'Geburtsdatum' FieldName = 'Geburtsdatum' FieldLength = 0 DataType = dtDateTime DisplayWidth = 18 Position = 10 TableName = 'Schueler' end object ppField12: TppField FieldAlias = 'Geburtsort' FieldName = 'Geburtsort' FieldLength = 70 DisplayWidth = 70 Position = 11 TableName = 'Schueler' end object ppField13: TppField FieldAlias = 'OrtAbk' FieldName = 'OrtAbk' FieldLength = 50 DisplayWidth = 50 Position = 12 TableName = 'Schueler' end object ppField14: TppField FieldAlias = 'Datum' FieldName = 'Datum' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 18 Position = 13 TableName = 'SchuelerVermerke' end object ppField15: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 0 IsDetail = True Linkable = False DataType = dtMemo DisplayWidth = 10 Position = 14 TableName = 'SchuelerVermerke' end object ppField16: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 15 TableName = 'K_VermerkArt' end object ppField17: TppField FieldAlias = 'Sichtbar' FieldName = 'Sichtbar' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 16 TableName = 'K_VermerkArt' end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'SuS' IsCaseSensitive = True LinkColor = clNavy LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.ID, Schueler.Klasse, ' ' Schueler.Name, Schueler.Vorname, ' ' K_Lehrer.Nachname, ' ' K_Lehrer.Vorname AS Vorname_2, ' ' K_Lehrer.Geschlecht, ' ' EigeneSchule.Schuljahr, ' ' EigeneSchule.SchuljahrAbschnitt, ' ' Schueler.Geschlecht AS Geschlecht_2, ' ' Schueler.Geburtsdatum, ' ' Schueler.Geburtsort, Schueler.OrtAbk, ' ' SchuelerVermerke.Datum, ' ' SchuelerVermerke.Bemerkung, ' ' K_VermerkArt.Bezeichnung, ' ' K_VermerkArt.Sichtbar' 'FROM ((((Schueler Schueler' ' INNER JOIN EigeneSchule EigeneSchule ON ' ' (EigeneSchule.Schuljahr = Schueler.AktSchuljahr)' ' AND (EigeneSchule.SchuljahrAbschnitt = Schueler.AktAbschni' + 'tt) )' ' INNER JOIN K_Lehrer K_Lehrer ON ' ' (K_Lehrer.Kuerzel = Schueler.Lehrer) )' ' INNER JOIN SchuelerVermerke SchuelerVermerke ON ' ' (SchuelerVermerke.Schueler_ID = Schueler.ID) )' ' INNER JOIN K_VermerkArt K_VermerkArt ON ' ' (K_VermerkArt.ID = SchuelerVermerke.VermerkArt_ID) )' 'WHERE ( Schueler.Status = 2 )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' ' AND ( K_VermerkArt.Sichtbar = '#39'+'#39' )' 'ORDER BY K_VermerkArt.Bezeichnung, ' ' Schueler.Klasse, Schueler.Name, ' ' Schueler.Vorname') SQLType = sqSQL2 object daCriteria1: 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 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 ParamName = 'Klassenwahl' object TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' ShowAllValues = True SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'Vermerkart' object TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' ShowAllValues = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end end object daCriteria5: TdaCriteria ChildType = 7 Level = 0 Value = '+' object TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' SQLFieldName = 'Sichtbar' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end end object daField1: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField5: 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 daField6: TdaField Alias = 'Vorname (2)' DisplayWidth = 20 FieldAlias = 'Vorname' FieldLength = 20 FieldName = 'Vorname' IsDetail = True SQLFieldName = 'Vorname_2' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField7: TdaField Alias = 'Geschlecht' DisplayWidth = 1 FieldAlias = 'Geschlecht' FieldLength = 1 FieldName = 'Geschlecht' IsDetail = True SQLFieldName = 'Geschlecht' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' TableSQLAlias = 'K_Lehrer' end object daField8: TdaField Alias = 'Schuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schuljahr' FieldLength = 0 FieldName = 'Schuljahr' IsDetail = True SQLFieldName = 'Schuljahr' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField9: TdaField Alias = 'SchuljahrAbschnitt' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'SchuljahrAbschnitt' FieldLength = 0 FieldName = 'SchuljahrAbschnitt' IsDetail = True SQLFieldName = 'SchuljahrAbschnitt' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField10: TdaField Alias = 'Geschlecht (2)' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'Geschlecht' FieldLength = 0 FieldName = 'Geschlecht' SQLFieldName = 'Geschlecht_2' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField Alias = 'Geburtsdatum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Geburtsdatum' FieldLength = 0 FieldName = 'Geburtsdatum' SQLFieldName = 'Geburtsdatum' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField Alias = 'Geburtsort' DisplayWidth = 70 FieldAlias = 'Geburtsort' FieldLength = 70 FieldName = 'Geburtsort' SQLFieldName = 'Geburtsort' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField Alias = 'OrtAbk' DisplayWidth = 50 FieldAlias = 'OrtAbk' FieldLength = 50 FieldName = 'OrtAbk' SQLFieldName = 'OrtAbk' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField Alias = 'Datum' DataType = dtDateTime DisplayWidth = 18 FieldAlias = 'Datum' FieldLength = 0 FieldName = 'Datum' IsDetail = True SQLFieldName = 'Datum' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField15: TdaField Alias = 'Bemerkung' DataType = dtMemo DisplayWidth = 10 FieldAlias = 'Bemerkung' FieldLength = 0 FieldName = 'Bemerkung' IsDetail = True Linkable = False SQLFieldName = 'Bemerkung' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField16: TdaField Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField17: TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' IsDetail = True SQLFieldName = 'Sichtbar' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField18: TdaField ChildType = 2 Alias = 'Bezeichnung' DisplayWidth = 30 FieldAlias = 'Bezeichnung' FieldLength = 30 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField19: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField20: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField21: 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 = 'EigeneSchule' SQLAlias = 'EigeneSchule' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' object daTableJoin1: TdaTableJoin ChildType = 6 object daField23: TdaField ChildType = 3 Alias = 'Schuljahr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schuljahr' FieldLength = 0 FieldName = 'Schuljahr' SQLFieldName = 'Schuljahr' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField22: 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 daTableJoin2: TdaTableJoin ChildType = 6 object daField25: TdaField ChildType = 3 Alias = 'SchuljahrAbschnitt' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'SchuljahrAbschnitt' FieldLength = 0 FieldName = 'SchuljahrAbschnitt' SQLFieldName = 'SchuljahrAbschnitt' TableAlias = 'EigeneSchule' TableName = 'EigeneSchule' TableSQLAlias = 'EigeneSchule' end object daField24: 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 = 'K_Lehrer' SQLAlias = 'K_Lehrer' TableAlias = 'K_Lehrer' TableName = 'K_Lehrer' object daTableJoin3: TdaTableJoin ChildType = 6 object daField27: 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 daField26: TdaField ChildType = 4 Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end object daTable4: TdaTable ChildType = 5 Alias = 'SchuelerVermerke' SQLAlias = 'SchuelerVermerke' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' object daTableJoin4: TdaTableJoin ChildType = 6 object daField29: TdaField ChildType = 3 Alias = 'Schueler_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Schueler_ID' FieldLength = 0 FieldName = 'Schueler_ID' SQLFieldName = 'Schueler_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end object daField28: 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 daTable5: TdaTable ChildType = 5 Alias = 'K_VermerkArt' SQLAlias = 'K_VermerkArt' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' object daTableJoin5: TdaTableJoin ChildType = 6 object daField31: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_VermerkArt' TableName = 'K_VermerkArt' TableSQLAlias = 'K_VermerkArt' end object daField30: TdaField ChildType = 4 Alias = 'VermerkArt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'VermerkArt_ID' FieldLength = 0 FieldName = 'VermerkArt_ID' SQLFieldName = 'VermerkArt_ID' TableAlias = 'SchuelerVermerke' TableName = 'SchuelerVermerke' TableSQLAlias = 'SchuelerVermerke' end end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365064970726F6365647572652056 61726961626C65733B0D0A7661720D0A20735F6765732C20735F6D2C20735F77 3A20696E74656765723B200D0A0D0A626567696E0D0A0D0A656E643B0D0A0843 61726574506F730102010201000001060F5472614576656E7448616E646C6572 0B50726F6772616D4E616D6506134442545F4B6C617373654F6E476574546578 740B50726F6772616D54797065070B747450726F63656475726506536F757263 6514A300000070726F636564757265204442545F4B6C617373654F6E47657454 6578742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D 0A202054657874203A3D202027536368C3BC6C657220646572204B6C61737365 2027202B2074657874202B2027206D697420646572205665726D65726B617274 202227202B205375535B2742657A656963686E756E67275D202B202722273B0D 0A0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060A4442545F4B6C61 737365094576656E744E616D6506094F6E47657454657874074576656E744944 0235084361726574506F7301025D0204000001060F5472614576656E7448616E 646C65720B50726F6772616D4E616D650610444254657874324F6E4765745465 78740B50726F6772616D54797065070B747450726F63656475726506536F7572 6365065C70726F63656475726520444254657874324F6E476574546578742876 617220546578743A20537472696E67293B0D0A626567696E0D0A0D0A74657874 3A3D20274C656974756E673A2027202B20746578743B0D0A0D0A656E643B0D0A 0D436F6D706F6E656E744E616D65060744425465787432094576656E744E616D 6506094F6E47657454657874074576656E7449440235084361726574506F7301 02010201000001060F5472614576656E7448616E646C65720B50726F6772616D 4E616D65061853797374656D5661726961626C65314F6E476574546578740B50 726F6772616D54797065070B747450726F63656475726506536F757263650666 70726F6365647572652053797374656D5661726961626C65314F6E4765745465 78742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D0A 202054657874203A3D20275265706F72743A2027202B20746578743B0D0A0D0A 656E643B0D0A0D436F6D706F6E656E744E616D65060F53797374656D56617269 61626C6531094576656E744E616D6506094F6E47657454657874074576656E74 49440235084361726574506F730102030203000001060F5472614576656E7448 616E646C65720B50726F6772616D4E616D650610444243616C63314F6E476574 546578740B50726F6772616D54797065070B747450726F63656475726506536F 75726365065B70726F63656475726520444243616C63314F6E47657454657874 2876617220546578743A20537472696E67293B0D0A626567696E0D0A0D0A7465 78743A3D20696E74746F73747228735F676573293B0D0A20200D0A656E643B0D 0A0D436F6D706F6E656E744E616D650607444243616C6331094576656E744E61 6D6506094F6E47657454657874074576656E7449440235084361726574506F73 0102010201000001060F5472614576656E7448616E646C65720B50726F677261 6D4E616D65061647726F7570334265666F726547726F7570427265616B0B5072 6F6772616D54797065070B747450726F63656475726506536F75726365064970 726F6365647572652047726F7570334265666F726547726F7570427265616B3B 0D0A626567696E0D0A0D0A735F6765733A3D735F676573202B20313B0D0A2020 0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060647726F7570330945 76656E744E616D6506104265666F726547726F7570427265616B074576656E74 4944021C084361726574506F730102010204000001060F5472614576656E7448 616E646C65720B50726F6772616D4E616D65061547726F757031416674657247 726F7570427265616B0B50726F6772616D54797065070B747450726F63656475 726506536F75726365063B70726F6365647572652047726F7570314166746572 47726F7570427265616B3B0D0A626567696E0D0A735F6765733A3D20303B0D0A 656E643B0D0A0D436F6D706F6E656E744E616D65060647726F75703109457665 6E744E616D65060F416674657247726F7570427265616B074576656E74494402 1B084361726574506F730102050204000000} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList1: TppParameterList object ppArchivierung: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True DataType = dtString LookupList.Strings = ( 'immer' 'nie' 'Schildvorgabe') LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = '' UserName = 'Archivierung' end object ppParameter1: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Klasse' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'SuS' DataType = dtString LookupSettings.NameField = 'Klasse' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Klasse' LookupSettings.DataPipelineName = 'SuS' Value = '' UserName = 'Klassenwahl' end object ppParameter2: TppParameter AutoSearchSettings.Enabled = True AutoSearchSettings.FieldAlias = 'Bezeichnung' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'SuS' DataType = dtString LookupSettings.NameField = 'Bezeichnung' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Bezeichnung' LookupSettings.DataPipelineName = 'SuS' Value = '' UserName = 'Vermerkart' end end end