object Report: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.PersGr PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'SAST_Medien3_Mail_Verteiler_Logineo.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' 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 = 'F:\SchILD-NRW\SchILD-Reports\Wbk_Bochum_Reports_SPR\0_Special\Sc' + 'hueler\Individ_Schueler_Liste_Personengruppen\SAST_Medien3_Mail_' + 'Verteiler_Logineo.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 = [efUseSubset] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.EncryptSettings.KeyLength = kl40Bit PDFSettings.FontEncoding = feUnicode PDFSettings.ImageCompressionLevel = 1 PreviewFormSettings.ZoomSetting = zs100Percent PreviewFormSettings.SinglePageOnly = True RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -15 RTFSettings.DefaultFont.Name = 'Calibri' RTFSettings.DefaultFont.Style = [] TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'Schild-NRW' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 128 Top = 8 Version = '15.05' mmColumnWidth = 165000 DataPipelineName = 'PersGr' object ppHeaderBand1: TppHeaderBand Background.Brush.Style = bsClear PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 22225 mmPrintPosition = 0 object ppLabel3: TppLabel UserName = 'dbListenbezeichnung' AutoSize = False Border.BorderPositions = [bpLeft, bpTop, bpRight, bpBottom] Border.Color = 10516052 Border.Visible = True Border.Weight = 2.000000000000000000 Caption = ' E-Mailverteiler' Color = 16051687 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 16 Font.Style = [fsBold] VerticalAlignment = avCenter mmHeight = 8731 mmLeft = 0 mmTop = 0 mmWidth = 170127 BandType = 0 LayerName = Foreground end object ppShape1: TppShape UserName = 'HintergrundUnsichtbar' Brush.Color = 10516052 ParentWidth = True mmHeight = 13229 mmLeft = 0 mmTop = 8996 mmWidth = 170000 BandType = 0 LayerName = Foreground end object ppLine6: TppLine UserName = 'TrennlinieK1' Pen.Color = 4993567 Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 13229 mmLeft = 9888 mmTop = 8996 mmWidth = 2480 BandType = 0 LayerName = Foreground end object ppLine3: TppLine UserName = 'TrennlinieK2' Pen.Color = 4993567 Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 13229 mmLeft = 70047 mmTop = 8996 mmWidth = 265 BandType = 0 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'NameVorname2' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Adresse' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 11113 mmTop = 16274 mmWidth = 41804 BandType = 0 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Nr' 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 = 11113 mmWidth = 7938 BandType = 0 LayerName = Foreground end object ppLabel1: TppLabel UserName = 'NameVorname' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Verteiler' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 11113 mmTop = 11113 mmWidth = 41804 BandType = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'NameVorname1' Anchors = [atLeft, atRight] AutoSize = False Caption = 'Mitglieder' Font.Charset = DEFAULT_CHARSET Font.Color = clWhite Font.Name = 'Calibri' Font.Size = 11 Font.Style = [fsBold] Transparent = True mmHeight = 5292 mmLeft = 71438 mmTop = 11113 mmWidth = 57944 BandType = 0 LayerName = Foreground 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 = 15081 mmPrintPosition = 0 object ppLine5: TppLine UserName = 'TrennlinieD2' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 15081 mmLeft = 10000 mmTop = 0 mmWidth = 2480 BandType = 4 LayerName = Foreground end object ppRegion1: TppRegion UserName = 'r' KeepTogether = True Brush.Style = bsClear Caption = 'r' ParentWidth = True Pen.Color = clWhite Pen.Style = psClear Pen.Width = 0 Stretch = True Transparent = True mmHeight = 15153 mmLeft = 0 mmTop = 0 mmWidth = 170000 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppDBCalc1: TppDBCalc UserName = 'LaufenderZaehler' Anchors = [atLeft, atRight] DataPipeline = daADOQueryDataView1.PersGr Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] SuppressRepeatedValues = True TextAlignment = taCentered Transparent = True DBCalcType = dcCount DataPipelineName = 'PersGr' mmHeight = 5200 mmLeft = 1000 mmTop = 0 mmWidth = 8000 BandType = 4 LayerName = Foreground end object ppSubReport1: TppSubReport UserName = 'Unterbericht' ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True ParentWidth = False TraverseAllData = False DataPipelineName = 'PersGr_Personen' mmHeight = 12267 mmLeft = 71438 mmTop = 265 mmWidth = 97896 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 object ppChildReport1: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.PersGr_Personen PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'SAST_Medien3_Mail_Verteiler_Logineo.rtm' PrinterSetup.PaperName = 'A4' PrinterSetup.PrinterName = 'Default' 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 = 'PersGr_Personen' object ppDetailBand2: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppLabel2: TppLabel UserName = 'Label1' Caption = 'Label1' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] Transparent = True mmHeight = 4763 mmLeft = 0 mmTop = 793 mmWidth = 55033 BandType = 4 LayerName = Foreground1 end end object raCodeModule2: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 4C6162656C314F6E476574546578740B50726F6772616D54797065070B747450 726F63656475726506536F75726365069170726F636564757265204C6162656C 314F6E476574546578742876617220546578743A20537472696E67293B0D0A62 6567696E0D0A0D0A2054657874203A3D205065727347725F506572736F6E656E 5B27506572736F6E566F726E616D65275D202B20272027202B20506572734772 5F506572736F6E656E5B27506572736F6E4E616D65275D3B0D0A0D0A656E643B 0D0A0D436F6D706F6E656E744E616D6506064C6162656C31094576656E744E61 6D6506094F6E47657454657874074576656E7449440235084361726574506F73 0102500204000000} end object ppDesignLayers2: TppDesignLayers object ppDesignLayer2: TppDesignLayer UserName = 'Foreground1' LayerType = ltBanded Index = 0 end end end end object ppDBMemo1: TppDBMemo UserName = 'dbNameVorname' CharWrap = False DataField = 'Gruppenname' DataPipeline = daADOQueryDataView1.PersGr Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] RemoveEmptyLines = False Stretch = True Transparent = True DataPipelineName = 'PersGr' mmHeight = 5200 mmLeft = 11000 mmTop = 0 mmWidth = 58000 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 mmLeading = 0 end object ppDBMemo2: TppDBMemo UserName = 'dbNameVorname1' CharWrap = False DataField = 'Zusatzinfo' DataPipeline = daADOQueryDataView1.PersGr Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 11 Font.Style = [] RemoveEmptyLines = False Stretch = True Transparent = True DataPipelineName = 'PersGr' mmHeight = 5292 mmLeft = 11113 mmTop = 7408 mmWidth = 57944 BandType = 4 LayerName = Foreground mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 mmMinHeight = 0 mmLeading = 0 end end object ppLine4: TppLine UserName = 'TrennlinieD1' Pen.Color = 4993567 ParentHeight = True Position = lpLeft StretchWithParent = True Weight = 0.750000000000000000 mmHeight = 15081 mmLeft = 70000 mmTop = 0 mmWidth = 241 BandType = 4 LayerName = Foreground 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 = Foreground end object ppSystemVariable1: TppSystemVariable UserName = 'Datum' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Calibri' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 0 mmTop = 1000 mmWidth = 14288 BandType = 8 LayerName = Foreground 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 = 46302 mmTop = 1000 mmWidth = 78052 BandType = 8 LayerName = Foreground 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 = 3705 mmLeft = 150000 mmTop = 1000 mmWidth = 20000 BandType = 8 LayerName = Foreground end end object raCodeModule1: TraCodeModule ProgramStream = {00} end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_PersGr' Height = 250 Left = 322 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 182 TypeColumnWidth = 52 Width = 372 AutoSearchTabOrder = 0 object PersGr: TppChildDBPipeline AutoCreateFields = False UserName = 'PersGr' object ppField1: TppField FieldAlias = 'GruppenArt' FieldName = 'GruppenArt' FieldLength = 20 DisplayWidth = 20 Position = 0 TableName = 'Personengruppen' end object ppField2: TppField FieldAlias = 'Gruppenname' FieldName = 'Gruppenname' FieldLength = 100 DisplayWidth = 100 Position = 1 TableName = 'Personengruppen' end object ppField3: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'Personengruppen' end object ppField4: TppField FieldAlias = 'SammelEMail' FieldName = 'SammelEMail' FieldLength = 100 DisplayWidth = 100 Position = 3 TableName = 'Personengruppen' end object ppField5: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 TableName = 'Personengruppen' end object ppField6: TppField FieldAlias = 'XMLExport' FieldName = 'XMLExport' FieldLength = 1 DisplayWidth = 1 Position = 5 TableName = 'Personengruppen' end object ppField7: TppField FieldAlias = 'Zusatzinfo' FieldName = 'Zusatzinfo' FieldLength = 100 DisplayWidth = 100 Position = 6 TableName = 'Personengruppen' end end object daSQL1: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'PersGr' IsCaseSensitive = True LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Personengruppen.GruppenArt, ' ' Personengruppen.Gruppenname, ' ' Personengruppen.ID, ' ' Personengruppen.SammelEMail, ' ' Personengruppen.SchulnrEigner, ' ' Personengruppen.XMLExport, ' ' Personengruppen.Zusatzinfo' 'FROM Personengruppen Personengruppen' 'ORDER BY Personengruppen.Gruppenname') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoInList ParamName = 'GrName' object TdaField Alias = 'Gruppenname' DisplayWidth = 100 FieldAlias = 'Gruppenname' FieldLength = 100 FieldName = 'Gruppenname' ShowAllValues = True SQLFieldName = 'Gruppenname' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end end object daField1: TdaField Alias = 'GruppenArt' DisplayWidth = 20 FieldAlias = 'GruppenArt' FieldLength = 20 FieldName = 'GruppenArt' SQLFieldName = 'GruppenArt' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField2: TdaField Alias = 'Gruppenname' DisplayWidth = 100 FieldAlias = 'Gruppenname' FieldLength = 100 FieldName = 'Gruppenname' SQLFieldName = 'Gruppenname' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField3: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField4: TdaField Alias = 'SammelEMail' DisplayWidth = 100 FieldAlias = 'SammelEMail' FieldLength = 100 FieldName = 'SammelEMail' SQLFieldName = 'SammelEMail' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField5: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField6: TdaField Alias = 'XMLExport' DisplayWidth = 1 FieldAlias = 'XMLExport' FieldLength = 1 FieldName = 'XMLExport' SQLFieldName = 'XMLExport' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField7: TdaField Alias = 'Zusatzinfo' DisplayWidth = 100 FieldAlias = 'Zusatzinfo' FieldLength = 100 FieldName = 'Zusatzinfo' SQLFieldName = 'Zusatzinfo' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField8: TdaField ChildType = 2 Alias = 'Gruppenname' DisplayWidth = 100 FieldAlias = 'Gruppenname' FieldLength = 100 FieldName = 'Gruppenname' SQLFieldName = 'Gruppenname' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daTable1: TdaTable ChildType = 5 Alias = 'Personengruppen' JoinType = dajtNone SQLAlias = 'Personengruppen' TableAlias = 'Personengruppen' TableName = 'Personengruppen' end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_PersGr_Personen' Height = 447 Left = 830 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 97 TypeColumnWidth = 52 Width = 399 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_PersGr' object PersGr_Personen: TppChildDBPipeline AutoCreateFields = False SkipWhenNoRecords = False UserName = 'PersGr_Personen' MasterDataPipelineName = 'PersGr' object ppField1: TppField FieldAlias = 'Bemerkung' FieldName = 'Bemerkung' FieldLength = 100 DisplayWidth = 100 Position = 0 TableName = 'Personengruppen_Personen' end object ppField2: TppField FieldAlias = 'Gruppe_ID' FieldName = 'Gruppe_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 TableName = 'Personengruppen_Personen' end object ppField3: TppField FieldAlias = 'ID' FieldName = 'ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 2 TableName = 'Personengruppen_Personen' end object ppField4: TppField FieldAlias = 'Person_ID' FieldName = 'Person_ID' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 3 TableName = 'Personengruppen_Personen' end object ppField5: TppField FieldAlias = 'PersonAkadGrad' FieldName = 'PersonAkadGrad' FieldLength = 15 DisplayWidth = 15 Position = 4 TableName = 'Personengruppen_Personen' end object ppField6: TppField FieldAlias = 'PersonAnrede' FieldName = 'PersonAnrede' FieldLength = 10 DisplayWidth = 10 Position = 5 TableName = 'Personengruppen_Personen' end object ppField7: TppField FieldAlias = 'PersonArt' FieldName = 'PersonArt' FieldLength = 1 DisplayWidth = 1 Position = 6 TableName = 'Personengruppen_Personen' end object ppField8: TppField FieldAlias = 'PersonEMail' FieldName = 'PersonEMail' FieldLength = 100 DisplayWidth = 100 Position = 7 TableName = 'Personengruppen_Personen' end object ppField9: TppField FieldAlias = 'PersonMobil' FieldName = 'PersonMobil' FieldLength = 20 DisplayWidth = 20 Position = 8 TableName = 'Personengruppen_Personen' end object ppField10: TppField FieldAlias = 'PersonName' FieldName = 'PersonName' FieldLength = 50 DisplayWidth = 50 Position = 9 TableName = 'Personengruppen_Personen' end object ppField11: TppField FieldAlias = 'PersonNr' FieldName = 'PersonNr' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 10 TableName = 'Personengruppen_Personen' end object ppField12: TppField FieldAlias = 'PersonOrt' FieldName = 'PersonOrt' FieldLength = 50 DisplayWidth = 50 Position = 11 TableName = 'Personengruppen_Personen' end object ppField13: TppField FieldAlias = 'PersonPLZ' FieldName = 'PersonPLZ' FieldLength = 10 DisplayWidth = 10 Position = 12 TableName = 'Personengruppen_Personen' end object ppField14: TppField FieldAlias = 'PersonStrasse' FieldName = 'PersonStrasse' FieldLength = 50 DisplayWidth = 50 Position = 13 TableName = 'Personengruppen_Personen' end object ppField15: TppField FieldAlias = 'PersonTelefon' FieldName = 'PersonTelefon' FieldLength = 20 DisplayWidth = 20 Position = 14 TableName = 'Personengruppen_Personen' end object ppField16: TppField FieldAlias = 'PersonVorname' FieldName = 'PersonVorname' FieldLength = 30 DisplayWidth = 30 Position = 15 TableName = 'Personengruppen_Personen' end object ppField17: TppField FieldAlias = 'SchulnrEigner' FieldName = 'SchulnrEigner' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 16 TableName = 'Personengruppen_Personen' end object ppField18: TppField FieldAlias = 'Sortierung' FieldName = 'Sortierung' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 17 TableName = 'Personengruppen_Personen' end object ppField19: TppField FieldAlias = 'ZusatzInfo' FieldName = 'ZusatzInfo' FieldLength = 100 DisplayWidth = 100 Position = 18 TableName = 'Personengruppen_Personen' end object TppMasterFieldLink MasterFieldName = 'Gruppenname' GuidCollationType = gcMSAccess DetailFieldName = 'Gruppenname' DetailSortOrder = soAscending IsCaseSensitive = True end object TppMasterFieldLink MasterFieldName = 'ID' GuidCollationType = gcMSAccess DetailFieldName = 'Gruppe_ID' DetailSortOrder = soAscending IsCaseSensitive = True end end object daSQL2: TdaSQL GuidCollationType = gcMSAccess DatabaseName = 'ADOConnection' DatabaseType = dtMSAccess DataPipelineName = 'PersGr_Personen' IsCaseSensitive = True LinkColor = clNavy LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SkipWhenNoRecords = False SQLText.Strings = ( 'SELECT Personengruppen_Personen.Bemerkung, ' ' Personengruppen_Personen.Gruppe_ID, ' ' Personengruppen_Personen.ID, ' ' Personengruppen_Personen.Person_ID, ' ' Personengruppen_Personen.PersonAkadGrad, ' ' Personengruppen_Personen.PersonAnrede, ' ' Personengruppen_Personen.PersonArt, ' ' Personengruppen_Personen.PersonEMail, ' ' Personengruppen_Personen.PersonMobil, ' ' Personengruppen_Personen.PersonName, ' ' Personengruppen_Personen.PersonNr, ' ' Personengruppen_Personen.PersonOrt, ' ' Personengruppen_Personen.PersonPLZ, ' ' Personengruppen_Personen.PersonStrasse, ' ' Personengruppen_Personen.PersonTelefon, ' ' Personengruppen_Personen.PersonVorname, ' ' Personengruppen_Personen.SchulnrEigner, ' ' Personengruppen_Personen.Sortierung, ' ' Personengruppen_Personen.ZusatzInfo' 'FROM ' ' Personengruppen_Personen Personengruppen_Personen' 'ORDER BY Personengruppen_Personen.PersonName, ' ' Personengruppen_Personen.PersonVorname') SQLType = sqSQL2 object daField1: TdaField Alias = 'Bemerkung' DisplayWidth = 100 FieldAlias = 'Bemerkung' FieldLength = 100 FieldName = 'Bemerkung' SQLFieldName = 'Bemerkung' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField2: TdaField Alias = 'Gruppe_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Gruppe_ID' FieldLength = 0 FieldName = 'Gruppe_ID' SQLFieldName = 'Gruppe_ID' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField3: TdaField Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField4: TdaField Alias = 'Person_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Person_ID' FieldLength = 0 FieldName = 'Person_ID' SQLFieldName = 'Person_ID' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField5: TdaField Alias = 'PersonAkadGrad' DisplayWidth = 15 FieldAlias = 'PersonAkadGrad' FieldLength = 15 FieldName = 'PersonAkadGrad' SQLFieldName = 'PersonAkadGrad' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField6: TdaField Alias = 'PersonAnrede' DisplayWidth = 10 FieldAlias = 'PersonAnrede' FieldLength = 10 FieldName = 'PersonAnrede' SQLFieldName = 'PersonAnrede' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField7: TdaField Alias = 'PersonArt' DisplayWidth = 1 FieldAlias = 'PersonArt' FieldLength = 1 FieldName = 'PersonArt' SQLFieldName = 'PersonArt' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField8: TdaField Alias = 'PersonEMail' DisplayWidth = 100 FieldAlias = 'PersonEMail' FieldLength = 100 FieldName = 'PersonEMail' SQLFieldName = 'PersonEMail' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField9: TdaField Alias = 'PersonMobil' DisplayWidth = 20 FieldAlias = 'PersonMobil' FieldLength = 20 FieldName = 'PersonMobil' SQLFieldName = 'PersonMobil' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField10: TdaField Alias = 'PersonName' DisplayWidth = 50 FieldAlias = 'PersonName' FieldLength = 50 FieldName = 'PersonName' SQLFieldName = 'PersonName' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField11: TdaField Alias = 'PersonNr' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'PersonNr' FieldLength = 0 FieldName = 'PersonNr' SQLFieldName = 'PersonNr' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField12: TdaField Alias = 'PersonOrt' DisplayWidth = 50 FieldAlias = 'PersonOrt' FieldLength = 50 FieldName = 'PersonOrt' SQLFieldName = 'PersonOrt' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField13: TdaField Alias = 'PersonPLZ' DisplayWidth = 10 FieldAlias = 'PersonPLZ' FieldLength = 10 FieldName = 'PersonPLZ' SQLFieldName = 'PersonPLZ' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField14: TdaField Alias = 'PersonStrasse' DisplayWidth = 50 FieldAlias = 'PersonStrasse' FieldLength = 50 FieldName = 'PersonStrasse' SQLFieldName = 'PersonStrasse' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField15: TdaField Alias = 'PersonTelefon' DisplayWidth = 20 FieldAlias = 'PersonTelefon' FieldLength = 20 FieldName = 'PersonTelefon' SQLFieldName = 'PersonTelefon' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField16: TdaField Alias = 'PersonVorname' DisplayWidth = 30 FieldAlias = 'PersonVorname' FieldLength = 30 FieldName = 'PersonVorname' SQLFieldName = 'PersonVorname' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField17: TdaField Alias = 'SchulnrEigner' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'SchulnrEigner' FieldLength = 0 FieldName = 'SchulnrEigner' SQLFieldName = 'SchulnrEigner' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField18: TdaField Alias = 'Sortierung' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Sortierung' FieldLength = 0 FieldName = 'Sortierung' SQLFieldName = 'Sortierung' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField19: TdaField Alias = 'ZusatzInfo' DisplayWidth = 100 FieldAlias = 'ZusatzInfo' FieldLength = 100 FieldName = 'ZusatzInfo' SQLFieldName = 'ZusatzInfo' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField20: TdaField ChildType = 2 Alias = 'PersonName' DisplayWidth = 50 FieldAlias = 'PersonName' FieldLength = 50 FieldName = 'PersonName' SQLFieldName = 'PersonName' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daField21: TdaField ChildType = 2 Alias = 'PersonVorname' DisplayWidth = 30 FieldAlias = 'PersonVorname' FieldLength = 30 FieldName = 'PersonVorname' SQLFieldName = 'PersonVorname' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end object daTable1: TdaTable ChildType = 5 Alias = 'Personengruppen_Personen' JoinType = dajtNone SQLAlias = 'Personengruppen_Personen' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' end object TdaSQLLink ChildType = 9 object daField22: TdaField ChildType = 10 Alias = 'ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'ID' FieldLength = 0 FieldName = 'ID' SQLFieldName = 'ID' TableAlias = 'Personengruppen' TableName = 'Personengruppen' TableSQLAlias = 'Personengruppen' end object daField23: TdaField ChildType = 11 Alias = 'Gruppe_ID' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'Gruppe_ID' FieldLength = 0 FieldName = 'Gruppe_ID' SQLFieldName = 'Gruppe_ID' TableAlias = 'Personengruppen_Personen' TableName = 'Personengruppen_Personen' TableSQLAlias = 'Personengruppen_Personen' end end end end 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 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 = 'Gruppenname' AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = False AutoSearchSettings.SearchOperator = soInList AutoSearchSettings.ShowAllValues = True AutoSearchSettings.DataPipelineName = 'PersGr' DataType = dtString LookupSettings.NameField = 'Gruppenname' LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName LookupSettings.ValueField = 'Gruppenname' LookupSettings.DataPipelineName = 'PersGr' Value = '' UserName = 'GrName' end end end