ReportName = Units Barcode Labels ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False Columns = 2 ColumnPositions.Strings = ( '4064' '110490') DataPipeline = daADOQueryDataView1.Units NoDataBehaviors = [ndBlankReport] PassSetting = psTwoPass PrinterSetup.BinName = 'Manual Feed' PrinterSetup.DocumentName = 'Units Barcode Labels' 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 = 'Units Barcode Labels' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Units Barcode Labels.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True CachePages = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 101600 DataPipelineName = 'Units' object ppColumnHeaderBand1: TppColumnHeaderBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 50800 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Name' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Units' mmHeight = 5027 mmLeft = 4498 mmTop = 3969 mmWidth = 89694 BandType = 4 end object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Serial #:' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 5027 mmLeft = 4498 mmTop = 9790 mmWidth = 16669 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'SerialNumber' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 12 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Units' mmHeight = 4763 mmLeft = 22490 mmTop = 9790 mmWidth = 72761 BandType = 4 end object ppDBBarCode1: TppDBBarCode UserName = 'DBBarCode1' BarCodeType = bcCode39 BarColor = clWindowText DataField = 'Unit' DataPipeline = daADOQueryDataView1.Units Alignment = taCenter AutoSize = False Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Name = 'Courier New' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 31221 mmLeft = 7938 mmTop = 16933 mmWidth = 84138 BandType = 4 mmBarWidth = 254 mmWideBarRatio = 76200 end end object ppColumnFooterBand1: TppColumnFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object raCodeModule1: TraCodeModule ProgramStream = { 01060D54726156617250726F6772616D094368696C645479706502110B50726F 6772616D4E616D6506095661726961626C65730B50726F6772616D5479706507 0B747450726F63656475726506536F75726365066470726F6365647572652056 61726961626C65733B0D0A7661720D0A20202046536B69703A20496E74656765 723B0D0A20202046546F74616C42616E6473506572436F6C756D6E3A20496E74 656765723B2020200D0A626567696E0D0A0D0A656E643B0D0A0001060A547261 50726F6772616D094368696C645479706502130B50726F6772616D4E616D6506 0E476C6F62616C4F6E4372656174650B50726F6772616D54797065070B747450 726F63656475726506536F75726365066670726F63656475726520476C6F6261 6C4F6E4372656174653B0D0A626567696E0D0A202046536B6970203A3D205265 706F72742E506172616D65746572735B277070536B6970275D3B0D0A2020496E 697469616C697A655265706F72743B0D0A656E643B0D0A0001060A5472615072 6F6772616D094368696C645479706502150B50726F6772616D4E616D65061049 6E697469616C697A655265706F72740B50726F6772616D54797065070B747450 726F63656475726506536F7572636506E570726F63656475726520496E697469 616C697A655265706F72743B0D0A626567696E0D0A0946546F74616C42616E64 73506572436F6C756D6E203A3D20303B0D0A20095265706F72742E4465746169 6C42616E642E42616E64735065725265636F7264203A3D2046536B69703B0D0A 0D0A09444254657874312E56697369626C65203A3D46616C73653B0D0A094442 54657874322E56697369626C65203A3D46616C73653B0D0A094C6162656C312E 56697369626C65203A3D46616C73653B0D0A094442426172436F6465312E5669 7369626C65203A3D46616C73653B0D0A656E643B0D0A0001060F547261457665 6E7448616E646C65720B50726F6772616D4E616D6506165265706F72744F6E53 746172744669727374506173730B50726F6772616D54797065070B747450726F 63656475726506536F75726365064570726F636564757265205265706F72744F 6E53746172744669727374506173733B0D0A626567696E0D0A2020496E697469 616C697A655265706F72743B0D0A656E643B0D0A0D436F6D706F6E656E744E61 6D6506065265706F7274094576656E744E616D6506104F6E5374617274466972 737450617373074576656E74494402140001060F5472614576656E7448616E64 6C65720B50726F6772616D4E616D6506175265706F72744F6E53746172745365 636F6E64506173730B50726F6772616D54797065070B747450726F6365647572 6506536F75726365064670726F636564757265205265706F72744F6E53746172 745365636F6E64506173733B0D0A626567696E0D0A2020496E697469616C697A 655265706F72743B0D0A656E643B0D0A0D436F6D706F6E656E744E616D650606 5265706F7274094576656E744E616D6506114F6E53746172745365636F6E6450 617373074576656E74494402160001060F5472614576656E7448616E646C6572 0B50726F6772616D4E616D6506115265706F72744F6E456E64436F6C756D6E0B 50726F6772616D54797065070B747450726F63656475726506536F7572636506 8770726F636564757265205265706F72744F6E456E64436F6C756D6E3B0D0A62 6567696E0D0A20206966202846546F74616C42616E6473506572436F6C756D6E 203D203029207468656E0D0A2020202046546F74616C42616E6473506572436F 6C756D6E203A3D205265706F72742E44657461696C42616E642E436F756E743B 0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506065265706F72740945 76656E744E616D65060B4F6E456E64436F6C756D6E074576656E744944020F00 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650611 44657461696C4265666F72655072696E740B50726F6772616D54797065070B74 7450726F63656475726506536F757263650C4701000070726F63656475726520 44657461696C4265666F72655072696E743B0D0A626567696E0D0A2020696620 282828285265706F72742E43757272656E74436F6C756D6E202D203129202A20 46546F74616C42616E6473506572436F6C756D6E29202B205265706F72742E44 657461696C42616E642E436F756E7429203D202846536B6970202D2031292920 7468656E0D0A20202020626567696E0D0A2020202020205265706F72742E4465 7461696C42616E642E42616E64735065725265636F7264203A3D20313B0D0A0D 0A09444254657874312E56697369626C65203A3D547275653B0D0A0944425465 7874322E56697369626C65203A3D547275653B0D0A094C6162656C312E566973 69626C65203A3D547275653B0D0A094442426172436F6465312E56697369626C 65203A3D547275653B0D0A0D0A20202020656E643B0D0A656E643B0D0A0D436F 6D706F6E656E744E616D65060644657461696C094576656E744E616D65060B42 65666F72655072696E74074576656E74494402180001060F5472614576656E74 48616E646C65720B50726F6772616D4E616D6506115265706F72744265666F72 655072696E740B50726F6772616D54797065070B747450726F63656475726506 536F75726365064070726F636564757265205265706F72744265666F72655072 696E743B0D0A626567696E0D0A2020496E697469616C697A655265706F72743B 0D0A656E643B0D0A0D436F6D706F6E656E744E616D6506065265706F72740945 76656E744E616D65060B4265666F72655072696E74074576656E744944020100 00} end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Units' Height = 288 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 330 AutoSearchTabOrder = 0 object Units: TppChildDBPipeline AutoCreateFields = False UserName = 'Units' object ppField1: TppField FieldAlias = 'CategoryID' FieldName = 'CategoryID' FieldLength = 25 DisplayWidth = 25 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'Make' FieldName = 'Make' FieldLength = 25 DisplayWidth = 25 Position = 2 TableName = 'Units' end object ppField4: TppField FieldAlias = 'Model' FieldName = 'Model' FieldLength = 25 DisplayWidth = 25 Position = 3 TableName = 'Units' end object ppField5: TppField FieldAlias = 'Type' FieldName = 'Type' FieldLength = 25 DisplayWidth = 25 Position = 4 TableName = 'Units' end object ppField6: TppField FieldAlias = 'SerialNumber' FieldName = 'SerialNumber' FieldLength = 20 DisplayWidth = 20 Position = 5 TableName = 'Units' end object ppField7: TppField FieldAlias = 'Location' FieldName = 'Location' FieldLength = 25 DisplayWidth = 25 Position = 6 TableName = 'Units' end object ppField8: TppField FieldAlias = 'AttachedTo' FieldName = 'AttachedTo' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 7 TableName = 'Units' end object ppField9: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 80 Position = 8 TableName = 'Units' end object ppField10: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 9 TableName = 'Units' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Units' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Units.CategoryID, Units.Unit, Units.Make, ' ' Units.Model, Units.Type, ' ' Units.SerialNumber, Units.Location, ' ' Units.AttachedTo, Units.Name, Units.Site' 'FROM Units Units' 'ORDER BY Units.Name, Units.Unit') SQLType = sqSQL2 object daField1: TdaField Alias = 'CategoryID' DisplayWidth = 25 FieldAlias = 'CategoryID' FieldLength = 25 FieldName = 'CategoryID' SQLFieldName = 'CategoryID' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'Unit' DisplayWidth = 25 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'Make' DisplayWidth = 25 FieldAlias = 'Make' FieldLength = 25 FieldName = 'Make' SQLFieldName = 'Make' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField4: TdaField Alias = 'Model' DisplayWidth = 25 FieldAlias = 'Model' FieldLength = 25 FieldName = 'Model' SQLFieldName = 'Model' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField5: TdaField Alias = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' SQLFieldName = 'Type' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField6: TdaField Alias = 'SerialNumber' DisplayWidth = 20 FieldAlias = 'SerialNumber' FieldLength = 20 FieldName = 'SerialNumber' SQLFieldName = 'SerialNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField7: TdaField Alias = 'Location' DisplayWidth = 25 FieldAlias = 'Location' FieldLength = 25 FieldName = 'Location' SQLFieldName = 'Location' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField8: TdaField Alias = 'AttachedTo' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'AttachedTo' FieldLength = 0 FieldName = 'AttachedTo' SQLFieldName = 'AttachedTo' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField9: TdaField Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField10: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField11: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField12: TdaField ChildType = 2 Alias = 'Unit' DisplayWidth = 25 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' 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 object ppSkip: TppParameter DataType = dtInteger Value = 1 end end end