ReportName = Company Listing ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.CompanyMaster PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 4064 PrinterSetup.mmMarginRight = 0 PrinterSetup.mmMarginTop = 12700 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Company Listing' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Company Listing.rtm' 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 = 211836 DataPipelineName = 'CompanyMaster' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 8731 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Company List' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 1323 mmWidth = 32427 BandType = 1 end object ppDBText11: TppDBText UserName = 'DBText11' AutoSize = True DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 175334 mmTop = 1588 mmWidth = 35010 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 9790 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 1058 mmLeft = 1323 mmTop = 8466 mmWidth = 209286 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 3704 mmTop = 2117 mmWidth = 13229 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' Caption = 'Company Name & Address' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 21696 mmTop = 2117 mmWidth = 43656 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' AutoSize = False Caption = 'Phone' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 91811 mmTop = 2117 mmWidth = 37042 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' AutoSize = False Caption = 'Fax' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 134938 mmTop = 2117 mmWidth = 33073 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' Caption = 'Customer' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 177800 mmTop = 2117 mmWidth = 15610 BandType = 0 end object ppLabel11: TppLabel UserName = 'Label11' Caption = 'Vendor' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 197644 mmTop = 2117 mmWidth = 11906 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 19050 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' AutoSize = True DataField = 'Numbered' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 3704 mmTop = 794 mmWidth = 8731 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' AutoSize = True DataField = 'FullName' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 21696 mmTop = 794 mmWidth = 30956 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' AutoSize = True DataField = 'Attention' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 21696 mmTop = 4233 mmWidth = 22754 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' AutoSize = True DataField = 'AddressLine1' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 21696 mmTop = 7673 mmWidth = 16933 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' AutoSize = True DataField = 'AddressLine2P' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 21696 mmTop = 11113 mmWidth = 33602 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True DataField = 'AddressLine3P' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3175 mmLeft = 21696 mmTop = 14552 mmWidth = 32808 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' AutoSize = True DataField = 'Phone' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3260 mmLeft = 91811 mmTop = 794 mmWidth = 17526 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' AutoSize = True DataField = 'Fax' DataPipeline = daADOQueryDataView1.CompanyMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 3260 mmLeft = 134673 mmTop = 794 mmWidth = 17526 BandType = 4 end object myDBCheckBox1: TmyDBCheckBox UserName = 'DBCheckBox1' BooleanFalse = 'N' BooleanTrue = 'Y' DataPipeline = daADOQueryDataView1.CompanyMaster DataField = 'Customer' Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 6350 mmLeft = 181769 mmTop = 794 mmWidth = 6350 BandType = 4 end object myDBCheckBox2: TmyDBCheckBox UserName = 'DBCheckBox2' BooleanFalse = 'N' BooleanTrue = 'Y' DataPipeline = daADOQueryDataView1.CompanyMaster DataField = 'Vendor' Transparent = True DataPipelineName = 'CompanyMaster' mmHeight = 6350 mmLeft = 201084 mmTop = 794 mmWidth = 6350 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 10054 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 2646 mmLeft = 1058 mmTop = 6085 mmWidth = 209286 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4498 mmLeft = 1058 mmTop = 1852 mmWidth = 17198 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4498 mmLeft = 193146 mmTop = 1852 mmWidth = 17198 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True DataField = 'Numbered' DataPipeline = daADOQueryDataView1.CompanyMaster DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True DBCalcType = dcCount LookAhead = True DataPipelineName = 'CompanyMaster' mmHeight = 3725 mmLeft = 1323 mmTop = 1852 mmWidth = 23326 BandType = 7 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_CompanyMaster' Height = 296 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object CompanyMaster: TppChildDBPipeline AutoCreateFields = False UserName = 'CompanyMaster' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 2 Position = 0 TableName = 'CompanyAddress' end object ppField2: TppField FieldAlias = 'FullName' FieldName = 'FullName' FieldLength = 50 DisplayWidth = 50 Position = 1 TableName = 'CompanyMaster' end object ppField3: TppField FieldAlias = 'Attention' FieldName = 'Attention' FieldLength = 30 IsDetail = True DisplayWidth = 30 Position = 2 TableName = 'CompanyAddress' end object ppField4: TppField FieldAlias = 'AddressLine1' FieldName = 'AddressLine1' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 3 TableName = 'CompanyAddress' end object ppField5: TppField FieldAlias = 'AddressLine2P' FieldName = 'AddressLine2P' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 4 TableName = 'CompanyAddress' end object ppField6: TppField FieldAlias = 'AddressLine3P' FieldName = 'AddressLine3P' FieldLength = 50 IsDetail = True DisplayWidth = 50 Position = 5 TableName = 'CompanyAddress' end object ppField7: TppField FieldAlias = 'Phone' FieldName = 'Phone' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 6 TableName = 'CompanyAddress' end object ppField8: TppField FieldAlias = 'Fax' FieldName = 'Fax' FieldLength = 20 IsDetail = True DisplayWidth = 20 Position = 7 TableName = 'CompanyAddress' end object ppField9: TppField FieldAlias = 'Customer' FieldName = 'Customer' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 8 TableName = 'CompanyAddress' end object ppField10: TppField FieldAlias = 'Vendor' FieldName = 'Vendor' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 9 TableName = 'CompanyAddress' end object ppField11: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 1 IsDetail = True DisplayWidth = 1 Position = 10 TableName = 'CompanyAddress' end object ppField12: TppField FieldAlias = 'TypeID' FieldName = 'TypeID' FieldLength = 15 IsDetail = True DisplayWidth = 15 Position = 11 TableName = 'CompanyAddress' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'CompanyMaster' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT CompanyAddress.Numbered, ' ' CompanyMaster.FullName, ' ' CompanyAddress.Attention, ' ' CompanyAddress.AddressLine1, ' ' CompanyAddress.AddressLine2P, ' ' CompanyAddress.AddressLine3P, ' ' CompanyAddress.Phone, CompanyAddress.Fax, ' ' CompanyAddress.Customer, ' ' CompanyAddress.Vendor, ' ' CompanyAddress.Status, ' ' CompanyAddress.TypeID' 'FROM CompanyMaster CompanyMaster' ' , CompanyAddress CompanyAddress' 'WHERE ' ' (CompanyAddress.CompanyID = CompanyMaster.CompanyID)' 'ORDER BY CompanyMaster.FullName, ' ' CompanyAddress.AddressLine2P, ' ' CompanyAddress.AddressLine3P') SQLType = sqSQL1 object daField1: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'Numbered' FieldLength = 2 FieldName = 'Numbered' IsDetail = True SQLFieldName = 'Numbered' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField2: TdaField Alias = 'FullName' DisplayWidth = 50 FieldAlias = 'FullName' FieldLength = 50 FieldName = 'FullName' SQLFieldName = 'FullName' TableAlias = 'CompanyMaster' TableName = 'CompanyMaster' TableSQLAlias = 'CompanyMaster' end object daField3: TdaField Alias = 'Attention' DisplayWidth = 30 FieldAlias = 'Attention' FieldLength = 30 FieldName = 'Attention' IsDetail = True SQLFieldName = 'Attention' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField4: TdaField Alias = 'AddressLine1' DisplayWidth = 50 FieldAlias = 'AddressLine1' FieldLength = 50 FieldName = 'AddressLine1' IsDetail = True SQLFieldName = 'AddressLine1' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField5: TdaField Alias = 'AddressLine2P' DisplayWidth = 50 FieldAlias = 'AddressLine2P' FieldLength = 50 FieldName = 'AddressLine2P' IsDetail = True SQLFieldName = 'AddressLine2P' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField6: TdaField Alias = 'AddressLine3P' DisplayWidth = 50 FieldAlias = 'AddressLine3P' FieldLength = 50 FieldName = 'AddressLine3P' IsDetail = True SQLFieldName = 'AddressLine3P' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField7: TdaField Alias = 'Phone' DisplayWidth = 20 FieldAlias = 'Phone' FieldLength = 20 FieldName = 'Phone' IsDetail = True SQLFieldName = 'Phone' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField8: TdaField Alias = 'Fax' DisplayWidth = 20 FieldAlias = 'Fax' FieldLength = 20 FieldName = 'Fax' IsDetail = True SQLFieldName = 'Fax' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField9: TdaField Alias = 'Customer' DisplayWidth = 1 FieldAlias = 'Customer' FieldLength = 1 FieldName = 'Customer' IsDetail = True SQLFieldName = 'Customer' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField10: TdaField Alias = 'Vendor' DisplayWidth = 1 FieldAlias = 'Vendor' FieldLength = 1 FieldName = 'Vendor' IsDetail = True SQLFieldName = 'Vendor' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField11: TdaField Alias = 'Status' DisplayWidth = 1 FieldAlias = 'Status' FieldLength = 1 FieldName = 'Status' IsDetail = True SQLFieldName = 'Status' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField12: TdaField Alias = 'TypeID' DisplayWidth = 15 FieldAlias = 'TypeID' FieldLength = 15 FieldName = 'TypeID' IsDetail = True SQLFieldName = 'TypeID' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField13: TdaField ChildType = 2 Alias = 'FullName' DisplayWidth = 50 FieldAlias = 'FullName' FieldLength = 50 FieldName = 'FullName' SQLFieldName = 'FullName' TableAlias = 'CompanyMaster' TableName = 'CompanyMaster' TableSQLAlias = 'CompanyMaster' end object daField14: TdaField ChildType = 2 Alias = 'AddressLine2P' DisplayWidth = 50 FieldAlias = 'AddressLine2P' FieldLength = 50 FieldName = 'AddressLine2P' SQLFieldName = 'AddressLine2P' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField15: TdaField ChildType = 2 Alias = 'AddressLine3P' DisplayWidth = 50 FieldAlias = 'AddressLine3P' FieldLength = 50 FieldName = 'AddressLine3P' SQLFieldName = 'AddressLine3P' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daTable1: TdaTable ChildType = 5 Alias = 'CompanyMaster' JoinType = dajtNone SQLAlias = 'CompanyMaster' TableAlias = 'CompanyMaster' TableName = 'CompanyMaster' end object daTable2: TdaTable ChildType = 5 Alias = 'CompanyAddress' SQLAlias = 'CompanyAddress' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' object daTableJoin1: TdaTableJoin ChildType = 6 object daField17: TdaField ChildType = 3 Alias = 'CompanyID' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'CompanyID' FieldLength = 0 FieldName = 'CompanyID' SQLFieldName = 'CompanyID' TableAlias = 'CompanyAddress' TableName = 'CompanyAddress' TableSQLAlias = 'CompanyAddress' end object daField16: TdaField ChildType = 4 Alias = 'CompanyID' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'CompanyID' FieldLength = 0 FieldName = 'CompanyID' SQLFieldName = 'CompanyID' TableAlias = 'CompanyMaster' TableName = 'CompanyMaster' TableSQLAlias = 'CompanyMaster' end end end end end end object ppParameterList1: TppParameterList end end