ReportName = Demo Company Labels
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  Columns = 3
  ColumnPositions.Strings = (
    '4826'
    '74676'
    '144526')
  DataPipeline = daADOQueryDataView1.CompanyMaster
  NoDataBehaviors = [ndBlankReport]
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Manual Feed'
  PrinterSetup.DocumentName = 'Report'
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'Default'
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 4826
  PrinterSetup.mmMarginRight = 0
  PrinterSetup.mmMarginTop = 12700
  PrinterSetup.mmPaperHeight = 279401
  PrinterSetup.mmPaperWidth = 215900
  PrinterSetup.PaperSize = 1
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = dpReports
  Template.DatabaseSettings.Name = 'Demo Company Labels'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  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
  TextSearchSettings.DefaultString = '<FindText>'
  TextSearchSettings.Enabled = False
  Left = 218
  Top = 155
  Version = '10.03'
  mmColumnWidth = 66802
  DataPipelineName = 'CompanyMaster'
  object ppColumnHeaderBand1: TppColumnHeaderBand
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 25400
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FullName'
      DataPipeline = daADOQueryDataView1.CompanyMaster
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'CompanyMaster'
      mmHeight = 4487
      mmLeft = 2117
      mmTop = 4233
      mmWidth = 61648
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      AutoSize = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'AddressLine1'
      DataPipeline = daADOQueryDataView1.CompanyMaster
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'CompanyMaster'
      mmHeight = 4487
      mmLeft = 2117
      mmTop = 8467
      mmWidth = 15917
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'AddressLine2P'
      DataPipeline = daADOQueryDataView1.CompanyMaster
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'CompanyMaster'
      mmHeight = 4487
      mmLeft = 2117
      mmTop = 12700
      mmWidth = 61648
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'AddressLine3P'
      DataPipeline = daADOQueryDataView1.CompanyMaster
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Arial'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'CompanyMaster'
      mmHeight = 4784
      mmLeft = 2117
      mmTop = 16933
      mmWidth = 61648
      BandType = 4
    end
  end
  object ppColumnFooterBand1: TppColumnFooterBand
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_CompanyMaster'
      Height = 160
      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 = 'FullName'
          FieldName = 'FullName'
          FieldLength = 50
          DisplayWidth = 50
          Position = 0
          SelectOrder = 0
          TableName = 'CompanyMaster'
        end
        object ppField2: TppField
          FieldAlias = 'AddressLine1'
          FieldName = 'AddressLine1'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 1
          SelectOrder = 1
          TableName = 'CompanyAddress'
        end
        object ppField3: TppField
          FieldAlias = 'AddressLine2P'
          FieldName = 'AddressLine2P'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 2
          SelectOrder = 2
          TableName = 'CompanyAddress'
        end
        object ppField4: TppField
          FieldAlias = 'AddressLine3P'
          FieldName = 'AddressLine3P'
          FieldLength = 50
          IsDetail = True
          DisplayWidth = 50
          Position = 3
          SelectOrder = 3
          TableName = 'CompanyAddress'
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'CompanyMaster'
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT CompanyMaster.FullName, '
          '       CompanyAddress.AddressLine1, '
          '       CompanyAddress.AddressLine2P, '
          '       CompanyAddress.AddressLine3P'
          'FROM CompanyMaster CompanyMaster'
          '      INNER JOIN CompanyAddress CompanyAddress ON '
          '     (CompanyAddress.CompanyID = CompanyMaster.CompanyID)'
          'ORDER BY CompanyMaster.FullName')
        SQLType = sqSQL2
        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
          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 daField7: 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 daField6: 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