object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.FSP PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Schuelerliste_Jg_Klasse_Foerderschwerpunkt_Filter_Schwerpunkt.rt' + 'm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 15000 PrinterSetup.mmMarginLeft = 20000 PrinterSetup.mmMarginRight = 20000 PrinterSetup.mmMarginTop = 15000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 SaveAsTemplate = True Template.FileName = 'C:\SchILD-NRW\SchILD-Reports\000_Neu\Foerderschwerpunkt\Schueler' + 'liste_Jg_Klasse_Foerderschwerpunkt_Filter_Schwerpunkt.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 = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True ThumbnailSettings.Enabled = False ThumbnailSettings.Visible = False 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 = 165000 DataPipelineName = 'FSP' object ppTitleBand1: TppTitleBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 14552 mmPrintPosition = 0 object ppSubReport1: TppSubReport UserName = 'SubReport1' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True TraverseAllData = False DataPipelineName = 'FSP' mmHeight = 5027 mmLeft = 0 mmTop = 0 mmWidth = 170000 BandType = 1 LayerName = Foreground1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView1.FSP PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Schuelerliste_Jg_Klasse_Foerderschwerpunkt_Filter_Schwerpunkt.rt' + 'm' PrinterSetup.PaperName = 'A4 210 x 297 mm' PrinterSetup.PrinterName = 'Screen' PrinterSetup.SaveDeviceSettings = False PrinterSetup.mmMarginBottom = 15000 PrinterSetup.mmMarginLeft = 20000 PrinterSetup.mmMarginRight = 20000 PrinterSetup.mmMarginTop = 15000 PrinterSetup.mmPaperHeight = 297000 PrinterSetup.mmPaperWidth = 210000 PrinterSetup.PaperSize = 9 Template.Format = ftASCII Units = utMillimeters Version = '15.05' mmColumnWidth = 0 DataPipelineName = 'FSP' object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppSummaryBand1: TppSummaryBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule2: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F75726365069670726F63656475726520446574 61696C4265666F72655072696E743B0D0A626567696E0D0A2020696620706F73 284653505B2742657A656963686E756E67275D202B20272C20272C7761686C6C 6973746529203C2031207468656E207761686C6C697374653A3D207761686C6C 69737465202B204653505B2742657A656963686E756E67275D202B20272C2027 3B0D0A656E643B0D0A0D436F6D706F6E656E744E616D65060644657461696C09 4576656E744E616D65060B4265666F72655072696E74074576656E7449440218 084361726574506F7301026A0203000001060F5472614576656E7448616E646C 65720B50726F6772616D4E616D65061253756D6D6172794265666F7265507269 6E740B50726F6772616D54797065070B747450726F63656475726506536F7572 6365068170726F6365647572652053756D6D6172794265666F72655072696E74 3B0D0A626567696E0D0A20207761686C6C697374653A3D20636F707928776168 6C6C697374652C312C6C656E677468287761686C6C6973746529202D2032293B 0D0A20202F2F73686F776D657373616765287761686C6C69737465293B0D0A65 6E643B0D0A0D436F6D706F6E656E744E616D65060753756D6D61727909457665 6E744E616D65060B4265666F72655072696E74074576656E7449440218084361 726574506F730102050204000000} end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end end end object ppLabel4: TppLabel UserName = 'Listenbezeichnung' AutoSize = False Border.BorderPositions = [bpTop, bpBottom] Border.Color = 10516052 Border.Visible = True Border.Weight = 2.000000000000000000 Caption = 'Sch'#252'lerliste F'#246'rderschwerpunkte' Color = 16051687 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 16 Font.Style = [fsBold] mmHeight = 7938 mmLeft = 0 mmTop = 0 mmWidth = 170127 BandType = 1 LayerName = Foreground1 end object ppDBText2: TppDBText UserName = 'dbSchuljahrAbschnitt' AutoSize = True DataField = 'SchuljahrUndAbschnittText' DataPipeline = dmPipelines.EigeneSchule Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Calibri' Font.Size = 9 Font.Style = [fsBold] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'EigeneSchule' mmHeight = 3704 mmLeft = 132292 mmTop = 2646 mmWidth = 35190 BandType = 1 LayerName = Foreground1 end object ppLabel2: TppLabel UserName = 'La_wahlliste' Caption = 'La_wahlliste' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3704 mmLeft = 75935 mmTop = 9260 mmWidth = 18521 BandType = 1 LayerName = Foreground1 end end object ppHeaderBand1: TppHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6615 mmPrintPosition = 0 object ppShape2: TppShape UserName = 'HintergrundUnsichtbar1' Brush.Color = 10516052 ParentHeight = True ParentWidth = True Pen.Color = 10516052 Pen.Style = psClear mmHeight = 6615 mmLeft = 0 mmTop = 0 mmWidth = 170000 BandType = 0 LayerName = Foreground1 end object ppLabel8: TppLabel UserName = 'Label8' Anchors = [atLeft, atRight] AutoSize = False Caption = 'F'#246'rderschwerpkt. 2' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 129381 mmTop = 794 mmWidth = 34131 BandType = 0 LayerName = Foreground1 end object ppLabel9: TppLabel UserName = 'Label9' Anchors = [atLeft, atRight] AutoSize = False Caption = 'F'#246'rderschwerpkt. 1' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 93134 mmTop = 794 mmWidth = 34131 BandType = 0 LayerName = Foreground1 end object ppLabel10: TppLabel UserName = 'NameVorname1' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Name, Vorname' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 41275 mmTop = 795 mmWidth = 51065 BandType = 0 LayerName = Foreground1 end object ppLabel12: TppLabel UserName = 'Label12' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Jg.' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 5292 mmLeft = 26194 mmTop = 794 mmWidth = 12965 BandType = 0 LayerName = Foreground1 end object ppLabel13: TppLabel UserName = 'Nr1' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Nr.' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taRightJustified Transparent = True mmHeight = 5292 mmLeft = 1058 mmTop = 795 mmWidth = 7938 BandType = 0 LayerName = Foreground1 end object ppLine12: TppLine UserName = 'Line12' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 6615 mmLeft = 10054 mmTop = 0 mmWidth = 1058 BandType = 0 LayerName = Foreground1 end object ppLine13: TppLine UserName = 'Line13' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 6615 mmLeft = 24871 mmTop = 0 mmWidth = 1058 BandType = 0 LayerName = Foreground1 end object ppLine14: TppLine UserName = 'Line14' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 6615 mmLeft = 39952 mmTop = 0 mmWidth = 1058 BandType = 0 LayerName = Foreground1 end object ppLine15: TppLine UserName = 'Line15' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 6615 mmLeft = 91281 mmTop = 0 mmWidth = 1058 BandType = 0 LayerName = Foreground1 end object ppLabel1: TppLabel UserName = 'Label1' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Klasse' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True mmHeight = 5292 mmLeft = 11113 mmTop = 794 mmWidth = 12965 BandType = 0 LayerName = Foreground1 end end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Color = 16051687 Border.BorderPositions = [bpLeft, bpRight, bpBottom] Border.Color = 10516052 Border.Visible = True Border.Weight = 0.750000000000000000 PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 5292 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'LaufenderZaehler' Anchors = [atLeft, atRight] DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'FSP' mmHeight = 5200 mmLeft = 1322 mmTop = 0 mmWidth = 6879 BandType = 4 LayerName = Foreground1 end object ppLine5: TppLine UserName = 'TrennlinieD1' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 10000 mmTop = 0 mmWidth = 1000 BandType = 4 LayerName = Foreground1 end object ppLine10: TppLine UserName = 'TrennlinieD2' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 40000 mmTop = 0 mmWidth = 1000 BandType = 4 LayerName = Foreground1 end object ppLine4: TppLine UserName = 'TrennlinieD3' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 91281 mmTop = 0 mmWidth = 1058 BandType = 4 LayerName = Foreground1 end object ppLine7: TppLine UserName = 'TrennlinieD4' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 127794 mmTop = 0 mmWidth = 1058 BandType = 4 LayerName = Foreground1 end object ppDBText1: TppDBText UserName = 'dbFoerderschwerpunkt1' DataField = 'Bezeichnung' DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'FSP' mmHeight = 5292 mmLeft = 93134 mmTop = 0 mmWidth = 34131 BandType = 4 LayerName = Foreground1 end object ppDBText3: TppDBText UserName = 'dbFoerderschwerpunkt2' DataField = 'Bezeichnung' DataPipeline = daADOQueryDataView2.FSP2 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'FSP2' mmHeight = 5292 mmLeft = 129646 mmTop = 0 mmWidth = 31221 BandType = 4 LayerName = Foreground1 end object ppLine11: TppLine UserName = 'Line11' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 5292 mmLeft = 24871 mmTop = 0 mmWidth = 1000 BandType = 4 LayerName = Foreground1 end object ppDBText6: TppDBText UserName = 'DBT_NameVorname' DataField = 'Name' DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] Transparent = True DataPipelineName = 'FSP' mmHeight = 4498 mmLeft = 41540 mmTop = 0 mmWidth = 48948 BandType = 4 LayerName = Foreground1 end object ppDBText5: TppDBText UserName = 'dbKlasse1' DataField = 'ASDJahrgang' DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'FSP' mmHeight = 5292 mmLeft = 26194 mmTop = 0 mmWidth = 12965 BandType = 4 LayerName = Foreground1 end object ppDBText4: TppDBText UserName = 'dbKlasse' DataField = 'Klasse' DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = 10516052 Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] TextAlignment = taCentered Transparent = True DataPipelineName = 'FSP' mmHeight = 5292 mmLeft = 11113 mmTop = 0 mmWidth = 12965 BandType = 4 LayerName = Foreground1 end object ppDBCalc2: TppDBCalc UserName = 'LaufenderZaehler1' Anchors = [atLeft, atRight] DataPipeline = daADOQueryDataView1.FSP Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'FSP' mmHeight = 5292 mmLeft = 162453 mmTop = 0 mmWidth = 6350 BandType = 4 LayerName = Foreground1 end end object ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4763 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'AbgrenzungslinieFuss' Pen.Color = 4993567 ParentWidth = True Weight = 0.750000000000000000 mmHeight = 2000 mmLeft = 0 mmTop = 0 mmWidth = 170000 BandType = 8 LayerName = Foreground1 end object ppSystemVariable2: TppSystemVariable UserName = 'Dokumentenname' VarType = vtDocumentName Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3704 mmLeft = 58797 mmTop = 1000 mmWidth = 52917 BandType = 8 LayerName = Foreground1 end object ppSystemVariable3: TppSystemVariable UserName = 'Seitenzahl' VarType = vtPageSetDesc Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 150000 mmTop = 1000 mmWidth = 20000 BandType = 8 LayerName = Foreground1 end object ppSystemVariable1: TppSystemVariable UserName = 'Datum' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 0 mmTop = 1000 mmWidth = 14288 BandType = 8 LayerName = Foreground1 end end object ppGroup1: TppGroup BreakName = 'Klasse' DataPipeline = daADOQueryDataView1.FSP GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True ReprintOnSubsequentPage = False StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'FSP' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 1852 mmPrintPosition = 0 object ppShape1: TppShape UserName = 'Shape1' Brush.Color = 10516052 ParentHeight = True ParentWidth = True Pen.Color = 10516052 mmHeight = 1852 mmLeft = 0 mmTop = 0 mmWidth = 170000 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 daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_FSP' Height = 373 Left = 113 NameColumnWidth = 105 SizeColumnWidth = 78 SortMode = 0 Top = 183 TypeColumnWidth = 52 Width = 392 AutoSearchTabOrder = 0 object FSP: TppChildDBPipeline AutoCreateFields = False UserName = 'FSP' object ppField1: TppField FieldAlias = 'ASDJahrgang' FieldName = 'ASDJahrgang' FieldLength = 2 DisplayWidth = 2 Position = 0 TableName = 'Schueler' end object ppField2: TppField FieldAlias = 'ASDSchulform' FieldName = 'ASDSchulform' FieldLength = 3 DisplayWidth = 3 Position = 1 TableName = 'Schueler' end object ppField3: TppField FieldAlias = 'Foerderschwerpunkt_ID' FieldName = 'Foerderschwerpunkt_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'Schueler' end object ppField4: TppField FieldAlias = 'Foerderschwerpunkt2_ID' FieldName = 'Foerderschwerpunkt2_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 3 TableName = 'Schueler' end object ppField5: TppField FieldAlias = 'Geloescht' FieldName = 'Geloescht' FieldLength = 1 DisplayWidth = 1 Position = 4 TableName = 'Schueler' end object ppField6: TppField FieldAlias = 'Geschlecht' FieldName = 'Geschlecht' FieldLength = 0 DataType = dtLongint DisplayWidth = 10 Position = 5 TableName = 'Schueler' end object ppField7: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 6 TableName = 'Schueler' end object ppField8: TppField FieldAlias = 'Klasse' FieldName = 'Klasse' FieldLength = 6 DisplayWidth = 6 Position = 7 TableName = 'Schueler' end object ppField9: TppField FieldAlias = 'Lehrer' FieldName = 'Lehrer' FieldLength = 10 DisplayWidth = 10 Position = 8 TableName = 'Schueler' end object ppField10: TppField FieldAlias = 'Markiert' FieldName = 'Markiert' FieldLength = 21 DisplayWidth = 21 Position = 9 TableName = 'Schueler' end object ppField11: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 10 TableName = 'Schueler' end object ppField12: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 11 TableName = 'Schueler' end object ppField13: TppField FieldAlias = 'Vorname' FieldName = 'Vorname' FieldLength = 30 DisplayWidth = 30 Position = 12 TableName = 'Schueler' end object ppField14: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 13 TableName = 'K_Foerderschwerpunkt' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'FSP' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Schueler.ASDJahrgang, ' ' Schueler.ASDSchulform, ' ' Schueler.Foerderschwerpunkt_ID, ' ' Schueler.Foerderschwerpunkt2_ID, ' ' Schueler.Geloescht, Schueler.Geschlecht, ' ' Schueler.ID, Schueler.Klasse, ' ' Schueler.Lehrer, Schueler.Markiert, ' ' Schueler.Name, Schueler.Status, ' ' Schueler.Vorname, ' ' K_Foerderschwerpunkt.Bezeichnung' 'FROM (Schueler Schueler' ' INNER JOIN K_Foerderschwerpunkt K_Foerderschwerpunkt ON ' ' (K_Foerderschwerpunkt.ID = Schueler.Foerderschwerpunkt_ID) ' + ')' 'WHERE ( Schueler.Status = 2 )' ' AND ( Schueler.Geloescht <> '#39'+'#39' )' ' AND ( K_Foerderschwerpunkt.Bezeichnung IS NOT NULL )' 'ORDER BY Schueler.Klasse') 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 = 'FSP1' object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' ShowAllValues = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end end object daCriteria4: TdaCriteria ChildType = 7 Level = 0 Operator = dacoNotBlank object TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end end object daField1: TdaField Alias = 'ASDJahrgang' DisplayWidth = 2 FieldAlias = 'ASDJahrgang' FieldLength = 2 FieldName = 'ASDJahrgang' SQLFieldName = 'ASDJahrgang' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField Alias = 'ASDSchulform' DisplayWidth = 3 FieldAlias = 'ASDSchulform' FieldLength = 3 FieldName = 'ASDSchulform' SQLFieldName = 'ASDSchulform' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField3: TdaField Alias = 'Foerderschwerpunkt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Foerderschwerpunkt_ID' FieldLength = 0 FieldName = 'Foerderschwerpunkt_ID' SQLFieldName = 'Foerderschwerpunkt_ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField4: TdaField Alias = 'Foerderschwerpunkt2_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Foerderschwerpunkt2_ID' FieldLength = 0 FieldName = 'Foerderschwerpunkt2_ID' SQLFieldName = 'Foerderschwerpunkt2_ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField5: TdaField Alias = 'Geloescht' DisplayWidth = 1 FieldAlias = 'Geloescht' FieldLength = 1 FieldName = 'Geloescht' SQLFieldName = 'Geloescht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField6: TdaField Alias = 'Geschlecht' DataType = dtLongint DisplayWidth = 10 FieldAlias = 'Geschlecht' FieldLength = 0 FieldName = 'Geschlecht' SQLFieldName = 'Geschlecht' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField7: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField8: TdaField Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField9: TdaField Alias = 'Lehrer' DisplayWidth = 10 FieldAlias = 'Lehrer' FieldLength = 10 FieldName = 'Lehrer' SQLFieldName = 'Lehrer' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField10: TdaField Alias = 'Markiert' DisplayWidth = 21 FieldAlias = 'Markiert' FieldLength = 21 FieldName = 'Markiert' SQLFieldName = 'Markiert' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField11: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField12: TdaField Alias = 'Status' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Status' FieldLength = 0 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField13: TdaField Alias = 'Vorname' DisplayWidth = 30 FieldAlias = 'Vorname' FieldLength = 30 FieldName = 'Vorname' SQLFieldName = 'Vorname' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField14: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' IsDetail = True SQLFieldName = 'Bezeichnung' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField15: TdaField ChildType = 2 Alias = 'Klasse' DisplayWidth = 6 FieldAlias = 'Klasse' FieldLength = 6 FieldName = 'Klasse' SQLFieldName = 'Klasse' 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 = 'K_Foerderschwerpunkt' SQLAlias = 'K_Foerderschwerpunkt' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' object daTableJoin1: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField16: TdaField ChildType = 4 Alias = 'Foerderschwerpunkt_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Foerderschwerpunkt_ID' FieldLength = 0 FieldName = 'Foerderschwerpunkt_ID' SQLFieldName = 'Foerderschwerpunkt_ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end end end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_FSP2' Height = 262 Left = 593 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 234 TypeColumnWidth = 52 Width = 332 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_FSP' object FSP2: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'FSP2' MasterDataPipelineName = 'FSP' object ppField1: TppField FieldAlias = 'Aenderbar' FieldName = 'Aenderbar' FieldLength = 1 DisplayWidth = 1 Position = 0 TableName = 'K_Foerderschwerpunkt' end object ppField2: TppField FieldAlias = 'Bezeichnung' FieldName = 'Bezeichnung' FieldLength = 50 DisplayWidth = 50 Position = 1 TableName = 'K_Foerderschwerpunkt' end object ppField3: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'K_Foerderschwerpunkt' end object ppField4: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 3 TableName = 'K_Foerderschwerpunkt' end object ppField5: TppField FieldAlias = 'Sichtbar' FieldName = 'Sichtbar' FieldLength = 1 DisplayWidth = 1 Position = 4 TableName = 'K_Foerderschwerpunkt' end object ppField6: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 TableName = 'K_Foerderschwerpunkt' end object ppField7: TppField FieldAlias = 'StatistikKrz' FieldName = 'StatistikKrz' FieldLength = 2 DisplayWidth = 2 Position = 6 TableName = 'K_Foerderschwerpunkt' end object TppMasterFieldLink MasterFieldName = 'Klasse' GuidCollationType = gcMSAccess DetailFieldName = 'Klasse' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'Foerderschwerpunkt2_ID' GuidCollationType = gcMSAccess DetailFieldName = 'ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'FSP2' IsCaseSensitive = True LinkColor = clNavy LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT K_Foerderschwerpunkt.Aenderbar, ' ' K_Foerderschwerpunkt.Bezeichnung, ' ' K_Foerderschwerpunkt.ID, ' ' K_Foerderschwerpunkt.SchulnrEigner, ' ' K_Foerderschwerpunkt.Sichtbar, ' ' K_Foerderschwerpunkt.Sortierung, ' ' K_Foerderschwerpunkt.StatistikKrz' 'FROM K_Foerderschwerpunkt K_Foerderschwerpunkt') SQLType = sqSQL2 object daField1: TdaField Alias = 'Aenderbar' DisplayWidth = 1 FieldAlias = 'Aenderbar' FieldLength = 1 FieldName = 'Aenderbar' SQLFieldName = 'Aenderbar' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField2: TdaField Alias = 'Bezeichnung' DisplayWidth = 50 FieldAlias = 'Bezeichnung' FieldLength = 50 FieldName = 'Bezeichnung' SQLFieldName = 'Bezeichnung' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField3: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField4: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField5: TdaField Alias = 'Sichtbar' DisplayWidth = 1 FieldAlias = 'Sichtbar' FieldLength = 1 FieldName = 'Sichtbar' SQLFieldName = 'Sichtbar' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField6: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daField7: TdaField Alias = 'StatistikKrz' DisplayWidth = 2 FieldAlias = 'StatistikKrz' FieldLength = 2 FieldName = 'StatistikKrz' SQLFieldName = 'StatistikKrz' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end object daTable1: TdaTable ChildType = 5 Alias = 'K_Foerderschwerpunkt' JoinType = dajtNone SQLAlias = 'K_Foerderschwerpunkt' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' end object daSQLLink1: TdaSQLLink ChildType = 9 object daField1: TdaField ChildType = 10 Alias = 'Foerderschwerpunkt2_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Foerderschwerpunkt2_ID' FieldLength = 0 FieldName = 'Foerderschwerpunkt2_ID' SQLFieldName = 'Foerderschwerpunkt2_ID' TableAlias = 'Schueler' TableName = 'Schueler' TableSQLAlias = 'Schueler' end object daField2: TdaField ChildType = 11 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'K_Foerderschwerpunkt' TableName = 'K_Foerderschwerpunkt' TableSQLAlias = 'K_Foerderschwerpunkt' end end end end end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365066470726F6365647572652056 61726961626C65733B0D0A7661720D0A20206F726967696E616C536F72746965 72756E67203A20537472696E673B0D0A20207761686C6C697374653A20737472 696E673B20200D0A0D0A626567696E0D0A0D0A656E643B0D0A08436172657450 6F730102150203000001060F5472614576656E7448616E646C65720B50726F67 72616D4E616D6506115265706F72744265666F72655072696E740B50726F6772 616D54797065070B747450726F63656475726506536F75726365066D70726F63 6564757265205265706F72744265666F72655072696E743B0D0A0D0A62656769 6E0D0A202F2F205365747A6546696C746572285265706F72742E446174617069 70656C696E652C27466F657264657273636877657270756E6B743C3E22222729 3B0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506065265706F727409 4576656E744E616D65060B4265666F72655072696E74074576656E7449440201 084361726574506F730102040204000001060F5472614576656E7448616E646C 65720B50726F6772616D4E616D6506184442545F4E616D65566F726E616D654F 6E476574546578740B50726F6772616D54797065070B747450726F6365647572 6506536F75726365067170726F636564757265204442545F4E616D65566F726E 616D654F6E476574546578742876617220546578743A20537472696E67293B0D 0A626567696E0D0A0D0A202054657874203A3D2074657874202B20272C202720 2B204653505B27566F726E616D65275D3B0D0A0D0A656E643B0D0A0D436F6D70 6F6E656E744E616D65060F4442545F4E616D65566F726E616D65094576656E74 4E616D6506094F6E47657454657874074576656E744944023508436172657450 6F730102280204000001060F5472614576656E7448616E646C65720B50726F67 72616D4E616D65060F64624B6C617373654F6E5072696E740B50726F6772616D 54797065070B747450726F63656475726506536F75726365065B70726F636564 7572652064624B6C617373654F6E5072696E743B0D0A626567696E0D0A202064 624B6C617373652E76697369626C653A3D204C617566656E6465725A6165686C 65722E76616C7565203D20313B0D0A656E643B0D0A0D436F6D706F6E656E744E 616D65060864624B6C61737365094576656E744E616D6506074F6E5072696E74 074576656E7449440220084361726574506F730102010201000001060F547261 4576656E7448616E646C65720B50726F6772616D4E616D65061A4C697374656E 62657A656963686E756E674F6E476574546578740B50726F6772616D54797065 070B747450726F63656475726506536F75726365066370726F63656475726520 4C697374656E62657A656963686E756E674F6E47657454657874287661722054 6578743A20537472696E67293B0D0A626567696E0D0A0D0A202054657874203A 3D202720202027202B20746578743B0D0A0D0A656E643B0D0A0D436F6D706F6E 656E744E616D6506114C697374656E62657A656963686E756E67094576656E74 4E616D6506094F6E47657454657874074576656E744944023508436172657450 6F730102180204000001060F5472614576656E7448616E646C65720B50726F67 72616D4E616D6506154C615F7761686C6C697374654F6E476574546578740B50 726F6772616D54797065070B747450726F63656475726506536F7572636514BA 00000070726F636564757265204C615F7761686C6C697374654F6E4765745465 78742876617220546578743A20537472696E67293B0D0A626567696E0D0A0D0A 696620706F7328272C272C7761686C6C6973746529203E2030200D0A7468656E 20746578743A3D2027476577C3A4686C7465204653503A2027202B207761686C 6C69737465200D0A656C736520746578743A3D2027476577C3A4686C74657220 4653503A2027202B207761686C6C697374653B0D0A0D0A656E643B0D0A0D436F 6D706F6E656E744E616D65060C4C615F7761686C6C69737465094576656E744E 616D6506094F6E47657454657874074576656E7449440235084361726574506F 730102010206000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end object ppParameterList2: 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 = 'Bezeichnung' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'FSP' DataType = dtString LookupSettings.NameField = 'Bezeichnung' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Bezeichnung' LookupSettings.DataPipelineName = 'FSP' Value = '' UserName = 'FSP1' end end end