ReportName = Rolodex Listing ReportGroup = Misc object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Rolodex 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 = 'Rolodex Listing' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Rolodex 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 = 0 DataPipelineName = 'Rolodex' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 11906 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Rolodex Listing' 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 = 529 mmWidth = 36872 BandType = 1 end object ppDBText7: TppDBText UserName = 'DBText7' 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 = 166603 mmTop = 529 mmWidth = 35010 BandType = 1 end object ppLabel7: TppLabel UserName = 'Params' Caption = 'Params' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4233 mmLeft = 1323 mmTop = 7408 mmWidth = 73819 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 10848 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 3969 mmLeft = 1058 mmTop = 8731 mmWidth = 201084 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Caption = 'Name & Address' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 1323 mmTop = 3175 mmWidth = 79375 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' Caption = 'Contact' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4530 mmLeft = 84402 mmTop = 3175 mmWidth = 12573 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' Caption = 'Phone' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4530 mmLeft = 133615 mmTop = 2910 mmWidth = 10372 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Caption = 'Fax' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4530 mmLeft = 169598 mmTop = 3440 mmWidth = 6477 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 13229 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Name' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 1323 mmTop = 529 mmWidth = 77258 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'Address' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 1323 mmTop = 3969 mmWidth = 77258 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'Contact' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 84402 mmTop = 529 mmWidth = 42598 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Phone' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 133615 mmTop = 529 mmWidth = 30956 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'Fax' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 169598 mmTop = 529 mmWidth = 30427 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'City_State_ZipCode' DataPipeline = daADOQueryDataView1.Rolodex Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Rolodex' mmHeight = 3175 mmLeft = 1323 mmTop = 7408 mmWidth = 77258 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 3704 mmLeft = 1323 mmTop = 6085 mmWidth = 200025 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 = 1323 mmTop = 1058 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 = 183357 mmTop = 1058 mmWidth = 17198 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 7673 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True DataField = 'Name' DataPipeline = daADOQueryDataView1.Rolodex DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'Rolodex' mmHeight = 4572 mmLeft = 2117 mmTop = 1852 mmWidth = 21378 BandType = 7 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Rolodex' Height = 177 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Rolodex: TppChildDBPipeline AutoCreateFields = False UserName = 'Rolodex' object ppField1: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 50 DisplayWidth = 50 Position = 0 TableName = 'Rolodex' end object ppField2: TppField FieldAlias = 'Contact' FieldName = 'Contact' FieldLength = 30 DisplayWidth = 30 Position = 1 TableName = 'Rolodex' end object ppField3: TppField FieldAlias = 'Address' FieldName = 'Address' FieldLength = 50 DisplayWidth = 50 Position = 2 TableName = 'Rolodex' end object ppField4: TppField FieldAlias = 'Phone' FieldName = 'Phone' FieldLength = 20 DisplayWidth = 20 Position = 3 TableName = 'Rolodex' end object ppField5: TppField FieldAlias = 'Fax' FieldName = 'Fax' FieldLength = 20 DisplayWidth = 20 Position = 4 TableName = 'Rolodex' end object ppField6: TppField FieldAlias = 'CityStateZip' FieldName = 'City_State_ZipCode' FieldLength = 25 Linkable = False DisplayWidth = 25 Position = 5 TableName = 'Rolodex' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Rolodex' IsCaseSensitive = True LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Rolodex.Name, Rolodex.Contact, ' ' Rolodex.Address, Rolodex.Phone, ' ' Rolodex.Fax, ' ' City+'#39', '#39'+State+'#39' '#39'+ZipCode City_State_ZipCode' 'FROM Rolodex Rolodex' 'ORDER BY Rolodex.Name') SQLType = sqSQL1 object daCalculation1: TdaCalculation ChildType = 8 Alias = 'CityStateZip' DisplayWidth = 25 FieldAlias = 'City' FieldLength = 25 FieldName = 'City' Linkable = False SQLFieldName = 'City_State_ZipCode' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' CalcType = dacaExpression Expression = 'City+'#39', '#39'+State+'#39' '#39'+ZipCode' end object daField1: TdaField Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daField2: TdaField Alias = 'Contact' DisplayWidth = 30 FieldAlias = 'Contact' FieldLength = 30 FieldName = 'Contact' SQLFieldName = 'Contact' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daField3: TdaField Alias = 'Address' DisplayWidth = 50 FieldAlias = 'Address' FieldLength = 50 FieldName = 'Address' SQLFieldName = 'Address' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daField4: TdaField Alias = 'Phone' DisplayWidth = 20 FieldAlias = 'Phone' FieldLength = 20 FieldName = 'Phone' SQLFieldName = 'Phone' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daField5: TdaField Alias = 'Fax' DisplayWidth = 20 FieldAlias = 'Fax' FieldLength = 20 FieldName = 'Fax' SQLFieldName = 'Fax' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daField6: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 50 FieldAlias = 'Name' FieldLength = 50 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Rolodex' TableName = 'Rolodex' TableSQLAlias = 'Rolodex' end object daTable1: TdaTable ChildType = 5 Alias = 'Rolodex' JoinType = dajtNone SQLAlias = 'Rolodex' TableAlias = 'Rolodex' TableName = 'Rolodex' end end end end object ppParameterList1: TppParameterList end end