ReportName = Unit Equipment By Ownership Detail ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Units NoDataBehaviors = [ndBlankReport] PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Unit Equipment By Ownership Detail' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'HP LaserJet 1022' 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 = 'Unit Equipment By Ownership Detail' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Unit Equipment By Ownership Detail.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True CachePages = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True ShowAutoSearchDialog = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = False Left = 218 Top = 155 Version = '10.07' mmColumnWidth = 0 DataPipelineName = 'Units' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 25400 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 1588 mmLeft = 1323 mmTop = 24342 mmWidth = 200555 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Make' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 63765 mmTop = 19579 mmWidth = 10583 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Model' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 100542 mmTop = 19579 mmWidth = 11377 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Owned?' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 130175 mmTop = 19579 mmWidth = 17198 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 20902 mmTop = 19579 mmWidth = 10583 BandType = 0 end object ppLabel1: TppLabel UserName = 'Label1' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit Equipment By Ownership Detail' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 14 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 5800 mmLeft = 1058 mmTop = 529 mmWidth = 200819 BandType = 0 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 14 Font.Style = [] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 5800 mmLeft = 1058 mmTop = 6085 mmWidth = 200819 BandType = 0 end object ppLabel9: TppLabel UserName = 'params' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'params' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 3260 mmLeft = 1058 mmTop = 12171 mmWidth = 200819 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Make' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 63765 mmTop = 1058 mmWidth = 34660 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Model' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 100542 mmTop = 794 mmWidth = 25929 BandType = 4 end object ppVariable1: TppVariable UserName = 'Variable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 0 Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3175 mmLeft = 130175 mmTop = 794 mmWidth = 11906 BandType = 4 end object ppVariable2: TppVariable UserName = 'Variable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 1 DataType = dtDouble Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True Visible = False mmHeight = 3175 mmLeft = 148167 mmTop = 794 mmWidth = 11906 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Name' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 20902 mmTop = 1323 mmWidth = 41540 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5027 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 1323 mmTop = 1323 mmWidth = 31157 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 193411 mmTop = 1323 mmWidth = 8594 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 18521 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 1852 mmLeft = 4233 mmTop = 1058 mmWidth = 124090 BandType = 7 end object ppLabel2: TppLabel UserName = 'Label2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total Units:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 8996 mmTop = 13494 mmWidth = 14393 BandType = 7 end object ppLabel7: TppLabel UserName = 'Label7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Units Leased:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 8996 mmTop = 8731 mmWidth = 17357 BandType = 7 end object ppLabel8: TppLabel UserName = 'Label8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Units Owned:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 8996 mmTop = 4233 mmWidth = 16976 BandType = 7 end object ppVariable3: TppVariable UserName = 'Variable3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 0 DataType = dtDouble Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3260 mmLeft = 26723 mmTop = 4233 mmWidth = 11938 BandType = 7 end object ppVariable4: TppVariable UserName = 'Variable4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 1 DataType = dtDouble Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3260 mmLeft = 26723 mmTop = 8731 mmWidth = 11938 BandType = 7 end object ppVariable5: TppVariable UserName = 'Variable5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 2 DataType = dtDouble Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3260 mmLeft = 26723 mmTop = 13494 mmWidth = 11938 BandType = 7 end object ppVariable6: TppVariable UserName = 'Variable6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 3 DataType = dtDouble DisplayFormat = '0.00 %' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3175 mmLeft = 39952 mmTop = 4233 mmWidth = 11906 BandType = 7 end object ppVariable7: TppVariable UserName = 'Variable7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 4 DataType = dtDouble DisplayFormat = '0.00 %' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3175 mmLeft = 39952 mmTop = 8731 mmWidth = 11906 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'CategoryID' DataPipeline = daADOQueryDataView1.Units OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Units' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 5027 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CategoryID' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [fsBold] SuppressRepeatedValues = True Transparent = True DataPipelineName = 'Units' mmHeight = 3387 mmLeft = 1323 mmTop = 1058 mmWidth = 44715 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 5661726961626C65314F6E43616C630B50726F6772616D54797065070B747450 726F63656475726506536F75726365069170726F636564757265205661726961 626C65314F6E43616C63287661722056616C75653A2056617269616E74293B0D 0A626567696E0D0A696620556E6974735B274F776E65646F724C656173656427 5D3D274F27207468656E0D0A202056616C7565203A3D274F776E6564270D0A65 6C73650D0A202056616C7565203A3D274C6561736564273B0D0A0D0A656E643B 0D0A0D436F6D706F6E656E744E616D6506095661726961626C6531094576656E 744E616D6506064F6E43616C63074576656E74494402210001060F5472614576 656E7448616E646C65720B50726F6772616D4E616D65060F5661726961626C65 324F6E43616C630B50726F6772616D54797065070B747450726F636564757265 06536F7572636506DF70726F636564757265205661726961626C65324F6E4361 6C63287661722056616C75653A2056617269616E74293B0D0A626567696E0D0A 69662020556E6974735B274F776E65646F724C6561736564275D3D274F272074 68656E0D0A20205661726961626C65332E56616C7565203A3D5661726961626C 65332E56616C75652B310D0A656C73650D0A20205661726961626C65342E5661 6C7565203A3D5661726961626C65342E56616C75652B313B0D0A566172696162 6C65352E56616C7565203A3D5661726961626C65352E56616C75652B313B0D0A 0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506095661726961626C65 32094576656E744E616D6506064F6E43616C63074576656E7449440221000106 0F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F5661 726961626C65364F6E43616C630B50726F6772616D54797065070B747450726F 63656475726506536F75726365067370726F636564757265205661726961626C 65364F6E43616C63287661722056616C75653A2056617269616E74293B0D0A62 6567696E0D0A0D0A202056616C7565203A3D285661726961626C65332E56616C 75652F5661726961626C65352E56616C7565292A3130303B0D0A0D0A656E643B 0D0A0D436F6D706F6E656E744E616D6506095661726961626C6536094576656E 744E616D6506064F6E43616C63074576656E74494402210001060F5472614576 656E7448616E646C65720B50726F6772616D4E616D65060F5661726961626C65 374F6E43616C630B50726F6772616D54797065070B747450726F636564757265 06536F75726365067370726F636564757265205661726961626C65374F6E4361 6C63287661722056616C75653A2056617269616E74293B0D0A626567696E0D0A 0D0A202056616C7565203A3D285661726961626C65342E56616C75652F566172 6961626C65352E56616C7565292A3130303B0D0A0D0A656E643B0D0A0D436F6D 706F6E656E744E616D6506095661726961626C6537094576656E744E616D6506 064F6E43616C63074576656E74494402210000} end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Units' Height = 198 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 273 AutoSearchTabOrder = 0 object Units: TppChildDBPipeline AutoCreateFields = False UserName = 'Units' object ppField1: TppField FieldAlias = 'CategoryID' FieldName = 'CategoryID' FieldLength = 25 DisplayWidth = 10 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'OwnedorLeased' FieldName = 'OwnedorLeased' FieldLength = 1 DisplayWidth = 10 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'Make' FieldName = 'Make' FieldLength = 25 DisplayWidth = 10 Position = 2 TableName = 'Units' end object ppField4: TppField FieldAlias = 'Model' FieldName = 'Model' FieldLength = 25 DisplayWidth = 10 Position = 3 TableName = 'Units' end object ppField5: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 10 Position = 4 TableName = 'Units' end object ppField6: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 10 Position = 5 TableName = 'Units' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Units' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Units.CategoryID, Units.OwnedorLeased, ' ' Units.Make, Units.Model, Units.Name, ' ' Units.Unit' 'FROM Units Units' 'WHERE ('#39'c'#39' <> '#39'c'#39' )') SQLType = sqSQL2 object daField1: TdaField Alias = 'CategoryID' DisplayWidth = 10 FieldAlias = 'CategoryID' FieldLength = 25 FieldName = 'CategoryID' SQLFieldName = 'CategoryID' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'OwnedorLeased' DisplayWidth = 10 FieldAlias = 'OwnedorLeased' FieldLength = 1 FieldName = 'OwnedorLeased' SQLFieldName = 'OwnedorLeased' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'Make' DisplayWidth = 10 FieldAlias = 'Make' FieldLength = 25 FieldName = 'Make' SQLFieldName = 'Make' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField4: TdaField Alias = 'Model' DisplayWidth = 10 FieldAlias = 'Model' FieldLength = 25 FieldName = 'Model' SQLFieldName = 'Model' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField5: TdaField Alias = 'Name' DisplayWidth = 10 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField6: TdaField Alias = 'Unit' DisplayWidth = 10 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField7: TdaField ChildType = 2 Alias = 'CategoryID' DisplayWidth = 10 FieldAlias = 'CategoryID' FieldLength = 10 FieldName = 'CategoryID' SQLFieldName = 'CategoryID' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField8: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 10 FieldAlias = 'Name' FieldLength = 10 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daTable1: TdaTable ChildType = 5 Alias = 'Units' JoinType = dajtNone SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' end end end end object ppParameterList1: TppParameterList end end