ReportName = Company Labels
ReportGroup = Misc
object ppReport1: TppReport
  AutoStop = False
  Columns = 2
  ColumnPositions.Strings = (
    '4064'
    '110490')
  DataPipeline = daADOQueryDataView1.Companies
  PrinterSetup.BinName = 'Manual Feed'
  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 Labels'
  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 = False
  TextSearchSettings.DefaultString = '<FindText>'
  TextSearchSettings.Enabled = True
  Left = 218
  Top = 155
  Version = '7.03'
  mmColumnWidth = 101600
  DataPipelineName = 'Companies'
  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 = 'FullName'
      DataPipeline = daADOQueryDataView1.Companies
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 12
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Companies'
      mmHeight = 5027
      mmLeft = 13758
      mmTop = 24077
      mmWidth = 80433
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      DataField = 'AddressLine1'
      DataPipeline = daADOQueryDataView1.Companies
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 12
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Companies'
      mmHeight = 5027
      mmLeft = 13758
      mmTop = 29369
      mmWidth = 80433
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      DataField = 'AddressLine2P'
      DataPipeline = daADOQueryDataView1.Companies
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 12
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Companies'
      mmHeight = 5027
      mmLeft = 13758
      mmTop = 34660
      mmWidth = 80433
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      DataField = 'AddressLine3P'
      DataPipeline = daADOQueryDataView1.Companies
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 12
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Companies'
      mmHeight = 5027
      mmLeft = 13758
      mmTop = 39952
      mmWidth = 80433
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      DataField = 'Attention'
      DataPipeline = daADOQueryDataView1.Companies
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 12
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Companies'
      mmHeight = 5027
      mmLeft = 13758
      mmTop = 18785
      mmWidth = 48683
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      DataField = 'CompanyName'
      DataPipeline = dpCompanyInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'dpCompanyInfo'
      mmHeight = 3440
      mmLeft = 1058
      mmTop = 2117
      mmWidth = 62442
      BandType = 4
    end
    object ppDBText7: TppDBText
      UserName = 'DBText7'
      DataField = 'Address'
      DataPipeline = dpCompanyInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'dpCompanyInfo'
      mmHeight = 3440
      mmLeft = 1058
      mmTop = 5821
      mmWidth = 62442
      BandType = 4
    end
    object ppDBText8: TppDBText
      UserName = 'DBText8'
      DataField = 'CityStateZip'
      DataPipeline = dpCompanyInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'dpCompanyInfo'
      mmHeight = 3440
      mmLeft = 1058
      mmTop = 9525
      mmWidth = 62442
      BandType = 4
    end
  end
  object ppColumnFooterBand1: TppColumnFooterBand
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_Companies'
      Height = 177
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 297
      AutoSearchTabOrder = 0
      object Companies: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'Companies'
        object ppField1: TppField
          FieldAlias = 'FullName'
          FieldName = 'FullName'
          FieldLength = 50
          DisplayWidth = 50
          Position = 0
          TableName = 'CompanyMaster'
        end
        object ppField2: TppField
          FieldAlias = 'AddressLine1'
          FieldName = 'AddressLine1'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 1
          TableName = 'CompanyAddress'
        end
        object ppField3: TppField
          FieldAlias = 'AddressLine2P'
          FieldName = 'AddressLine2P'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 2
          TableName = 'CompanyAddress'
        end
        object ppField4: TppField
          FieldAlias = 'AddressLine3P'
          FieldName = 'AddressLine3P'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 3
          TableName = 'CompanyAddress'
        end
        object ppField5: TppField
          FieldAlias = 'CompanyID'
          FieldName = 'CompanyID'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 4
          TableName = 'CompanyAddress'
        end
        object ppField6: TppField
          FieldAlias = 'Attention'
          FieldName = 'Attention'
          FieldLength = 30
          IsDetail = True
          DisplayWidth = 30
          Position = 5
          TableName = 'CompanyAddress'
        end
        object ppField7: TppField
          FieldAlias = 'Numbered'
          FieldName = 'Numbered'
          FieldLength = 2
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 2
          Position = 6
          TableName = 'CompanyAddress'
        end
      end
      object daSQL1: TdaSQL
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'Companies'
        IsCaseSensitive = True
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT CompanyMaster.FullName, '
          '       CompanyAddress.AddressLine1, '
          '       CompanyAddress.AddressLine2P, '
          '       CompanyAddress.AddressLine3P, '
          '       CompanyAddress.CompanyID, '
          '       CompanyAddress.Attention, '
          '       CompanyAddress.Numbered'
          'FROM CompanyMaster CompanyMaster'
          '     , CompanyAddress CompanyAddress'
          'WHERE '
          '      (CompanyAddress.CompanyID = CompanyMaster.CompanyID)'
          'ORDER BY CompanyMaster.FullName')
        SQLType = sqSQL1
        object daField1: TdaField
          Alias = 'FullName'
          DisplayWidth = 50
          FieldAlias = 'FullName'
          FieldLength = 50
          FieldName = 'FullName'
          SQLFieldName = 'FullName'
          TableAlias = 'CompanyMaster'
          TableName = 'CompanyMaster'
          TableSQLAlias = 'CompanyMaster'
        end
        object daField2: TdaField
          Alias = 'AddressLine1'
          DisplayWidth = 50
          FieldAlias = 'AddressLine1'
          FieldLength = 50
          FieldName = 'AddressLine1'
          IsDetail = True
          SQLFieldName = 'AddressLine1'
          TableAlias = 'CompanyAddress'
          TableName = 'CompanyAddress'
          TableSQLAlias = 'CompanyAddress'
        end
        object daField3: TdaField
          Alias = 'AddressLine2P'
          DisplayWidth = 50
          FieldAlias = 'AddressLine2P'
          FieldLength = 50
          FieldName = 'AddressLine2P'
          IsDetail = True
          SQLFieldName = 'AddressLine2P'
          TableAlias = 'CompanyAddress'
          TableName = 'CompanyAddress'
          TableSQLAlias = 'CompanyAddress'
        end
        object daField4: TdaField
          Alias = 'AddressLine3P'
          DisplayWidth = 50
          FieldAlias = 'AddressLine3P'
          FieldLength = 50
          FieldName = 'AddressLine3P'
          IsDetail = True
          SQLFieldName = 'AddressLine3P'
          TableAlias = 'CompanyAddress'
          TableName = 'CompanyAddress'
          TableSQLAlias = 'CompanyAddress'
        end
        object daField5: TdaField
          Alias = 'CompanyID'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'CompanyID'
          FieldLength = 0
          FieldName = 'CompanyID'
          IsDetail = True
          SQLFieldName = 'CompanyID'
          TableAlias = 'CompanyAddress'
          TableName = 'CompanyAddress'
          TableSQLAlias = 'CompanyAddress'
        end
        object daField6: TdaField
          Alias = 'Attention'
          DisplayWidth = 30
          FieldAlias = 'Attention'
          FieldLength = 30
          FieldName = 'Attention'
          IsDetail = True
          SQLFieldName = 'Attention'
          TableAlias = 'CompanyAddress'
          TableName = 'CompanyAddress'
          TableSQLAlias = 'CompanyAddress'
        end
        object daField7: 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 daField8: TdaField
          ChildType = 2
          Alias = 'FullName'
          DisplayWidth = 50
          FieldAlias = 'FullName'
          FieldLength = 50
          FieldName = 'FullName'
          SQLFieldName = 'FullName'
          TableAlias = 'CompanyMaster'
          TableName = 'CompanyMaster'
          TableSQLAlias = 'CompanyMaster'
        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 daField10: 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 daField9: 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
end