ReportName = Employees Data Sheet - Graphic ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Employees NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Employees Data Sheet - Graphic' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'Employees' object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 107950 mmPrintPosition = 0 object ppDBImage1: TppDBImage UserName = 'DBImage1' MaintainAspectRatio = True Stretch = True DataField = 'Picture' DataPipeline = daADOQueryDataView1.Employees GraphicType = 'Bitmap' DataPipelineName = 'Employees' mmHeight = 104246 mmLeft = 4498 mmTop = 1852 mmWidth = 132557 BandType = 4 end end object ppGroup1: TppGroup BreakName = 'ShortName' DataPipeline = daADOQueryDataView1.Employees OutlineSettings.CreateNode = True NewPage = True ReprintOnSubsequentPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Employees' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 23813 mmPrintPosition = 0 object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Phone:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 4498 mmTop = 17198 mmWidth = 11113 BandType = 3 GroupNo = 0 end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Work Group:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 80169 mmTop = 2117 mmWidth = 20108 BandType = 3 GroupNo = 0 end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Position:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 86784 mmTop = 6615 mmWidth = 13494 BandType = 3 GroupNo = 0 end object ppDBText1: TppDBText UserName = 'DBText1' AutoSize = True DataField = 'ShortName' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 4022 mmLeft = 4498 mmTop = 2117 mmWidth = 17822 BandType = 3 GroupNo = 0 end object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'Address' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 4022 mmLeft = 4498 mmTop = 6615 mmWidth = 12912 BandType = 3 GroupNo = 0 end object ppDBText3: TppDBText UserName = 'DBText3' AutoSize = True DataField = 'City_State_Zip' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 4022 mmLeft = 4498 mmTop = 11113 mmWidth = 18965 BandType = 3 GroupNo = 0 end object ppDBText4: TppDBText UserName = 'DBText4' AutoSize = True DataField = 'Phone' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 4022 mmLeft = 16404 mmTop = 17463 mmWidth = 21844 BandType = 3 GroupNo = 0 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'WorkGroup' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 3969 mmLeft = 101071 mmTop = 2117 mmWidth = 14288 BandType = 3 GroupNo = 0 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True DataField = 'Position' DataPipeline = daADOQueryDataView1.Employees Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Employees' mmHeight = 3969 mmLeft = 101071 mmTop = 6615 mmWidth = 15081 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Employees' Height = 326 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Employees: TppChildDBPipeline AutoCreateFields = False UserName = 'Employees' object ppField1: TppField FieldAlias = 'ShortName' FieldName = 'ShortName' FieldLength = 35 DisplayWidth = 35 Position = 0 TableName = 'Employees' end object ppField2: TppField FieldAlias = 'Phone' FieldName = 'Phone' FieldLength = 20 DisplayWidth = 20 Position = 1 TableName = 'Employees' end object ppField3: TppField FieldAlias = 'Pager' FieldName = 'Pager' FieldLength = 20 DisplayWidth = 20 Position = 2 TableName = 'Employees' end object ppField4: TppField FieldAlias = 'WorkGroup' FieldName = 'WorkGroup' FieldLength = 25 DisplayWidth = 25 Position = 3 TableName = 'Employees' end object ppField5: TppField FieldAlias = 'Address' FieldName = 'Address' FieldLength = 50 DisplayWidth = 50 Position = 4 TableName = 'Employees' end object ppField6: TppField FieldAlias = 'City' FieldName = 'City' FieldLength = 25 DisplayWidth = 25 Position = 5 TableName = 'Employees' end object ppField7: TppField FieldAlias = 'State' FieldName = 'State' FieldLength = 25 DisplayWidth = 25 Position = 6 TableName = 'Employees' end object ppField8: TppField FieldAlias = 'Zip' FieldName = 'Zip' FieldLength = 10 DisplayWidth = 10 Position = 7 TableName = 'Employees' end object ppField9: TppField FieldAlias = 'Position' FieldName = 'Position' FieldLength = 25 DisplayWidth = 25 Position = 8 TableName = 'Employees' end object ppField10: TppField FieldAlias = 'Picture' FieldName = 'Picture' FieldLength = 0 Linkable = False DataType = dtGraphic DisplayWidth = 0 Position = 9 TableName = 'Employees' end object ppField11: TppField FieldAlias = 'Email' FieldName = 'Email' FieldLength = 250 DisplayWidth = 250 Position = 10 TableName = 'Employees' end object ppField12: TppField FieldAlias = 'CelluarPhone' FieldName = 'CelluarPhone' FieldLength = 20 DisplayWidth = 20 Position = 11 TableName = 'Employees' end object ppField13: TppField FieldAlias = 'CityStateZip' FieldName = 'City_State_Zip' FieldLength = 25 Linkable = False DisplayWidth = 25 Position = 12 TableName = 'Employees' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Employees' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Employees.ShortName, Employees.Phone, ' ' Employees.Pager, Employees.WorkGroup, ' ' Employees.Address, Employees.City, ' ' Employees.State, Employees.Zip, ' ' Employees.Position, Employees.Picture, ' ' Employees.Email, Employees.CelluarPhone, ' ' City+'#39', '#39'+State+'#39' '#39'+Zip City_State_Zip' 'FROM Employees Employees' 'ORDER BY Employees.ShortName') SQLType = sqSQL2 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'CityStateZip' DisplayWidth = 25 FieldAlias = 'City' FieldLength = 25 FieldName = 'City' Linkable = False SQLFieldName = 'City_State_Zip' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' CalcType = dacaExpression Expression = 'City+'#39', '#39'+State+'#39' '#39'+Zip' end object daField1: TdaField Alias = 'ShortName' DisplayWidth = 35 FieldAlias = 'ShortName' FieldLength = 35 FieldName = 'ShortName' SQLFieldName = 'ShortName' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField2: TdaField Alias = 'Phone' DisplayWidth = 20 FieldAlias = 'Phone' FieldLength = 20 FieldName = 'Phone' SQLFieldName = 'Phone' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField3: TdaField Alias = 'Pager' DisplayWidth = 20 FieldAlias = 'Pager' FieldLength = 20 FieldName = 'Pager' SQLFieldName = 'Pager' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField4: TdaField Alias = 'WorkGroup' DisplayWidth = 25 FieldAlias = 'WorkGroup' FieldLength = 25 FieldName = 'WorkGroup' SQLFieldName = 'WorkGroup' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField5: TdaField Alias = 'Address' DisplayWidth = 50 FieldAlias = 'Address' FieldLength = 50 FieldName = 'Address' SQLFieldName = 'Address' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField6: TdaField Alias = 'City' DisplayWidth = 25 FieldAlias = 'City' FieldLength = 25 FieldName = 'City' SQLFieldName = 'City' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField7: TdaField Alias = 'State' DisplayWidth = 25 FieldAlias = 'State' FieldLength = 25 FieldName = 'State' SQLFieldName = 'State' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField8: TdaField Alias = 'Zip' DisplayWidth = 10 FieldAlias = 'Zip' FieldLength = 10 FieldName = 'Zip' SQLFieldName = 'Zip' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField9: TdaField Alias = 'Position' DisplayWidth = 25 FieldAlias = 'Position' FieldLength = 25 FieldName = 'Position' SQLFieldName = 'Position' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField10: TdaField Alias = 'Picture' DataType = dtGraphic DisplayWidth = 0 FieldAlias = 'Picture' FieldLength = 0 FieldName = 'Picture' Linkable = False SQLFieldName = 'Picture' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField11: TdaField Alias = 'Email' DisplayWidth = 250 FieldAlias = 'Email' FieldLength = 250 FieldName = 'Email' SQLFieldName = 'Email' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField12: TdaField Alias = 'CelluarPhone' DisplayWidth = 20 FieldAlias = 'CelluarPhone' FieldLength = 20 FieldName = 'CelluarPhone' SQLFieldName = 'CelluarPhone' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daField13: TdaField ChildType = 2 Alias = 'ShortName' DisplayWidth = 35 FieldAlias = 'ShortName' FieldLength = 35 FieldName = 'ShortName' SQLFieldName = 'ShortName' TableAlias = 'Employees' TableName = 'Employees' TableSQLAlias = 'Employees' end object daTable1: TdaTable ChildType = 5 Alias = 'Employees' JoinType = dajtNone SQLAlias = 'Employees' TableAlias = 'Employees' TableName = 'Employees' end end end end end