ReportName = Unit Costs With Parts & Tools
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADOQueryDataView1.WoMaster
  NoDataBehaviors = [ndBlankReport]
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Unit Costs With Parts & Tools'
  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 Costs With Parts & Tools'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  Template.FileName = 'Unit Costs With Parts & Tools.rtm'
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  AllowPrintToArchive = True
  AllowPrintToFile = 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.07'
  mmColumnWidth = 0
  DataPipelineName = 'WoMaster'
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 26194
    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 = 1323
      mmLeft = 1323
      mmTop = 24871
      mmWidth = 200555
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Unit Name'
      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 = 20108
      mmWidth = 18256
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Labor'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4763
      mmLeft = 60854
      mmTop = 19579
      mmWidth = 17992
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Parts'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4530
      mmLeft = 90752
      mmTop = 19579
      mmWidth = 8467
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Tools'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4530
      mmLeft = 110596
      mmTop = 19579
      mmWidth = 8890
      BandType = 0
    end
    object ppLabel6: TppLabel
      UserName = 'Label6'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Total'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4530
      mmLeft = 161661
      mmTop = 19579
      mmWidth = 8467
      BandType = 0
    end
    object ppLabel7: TppLabel
      UserName = 'Label7'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Other'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4530
      mmLeft = 136790
      mmTop = 19844
      mmWidth = 9313
      BandType = 0
    end
    object ppLabel1: TppLabel
      UserName = 'Label1'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Unit Cost With Parts & Tools'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 14
      Font.Style = []
      TextAlignment = taCentered
      Transparent = True
      mmHeight = 5800
      mmLeft = 1852
      mmTop = 265
      mmWidth = 199496
      BandType = 0
    end
    object ppDBText7: TppDBText
      UserName = 'DBText7'
      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 = 5821
      mmLeft = 1852
      mmTop = 5821
      mmWidth = 199496
      BandType = 0
    end
    object ppLabel8: 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 = 1852
      mmTop = 12171
      mmWidth = 199496
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 4763
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = 13434828
      Border.Style = psSolid
      Border.Visible = False
      Color = clInfoBk
      DataField = 'Name'
      DataPipeline = daADOQueryDataView1.WoMaster
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3260
      mmLeft = 1323
      mmTop = 529
      mmWidth = 57150
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_LaborCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3175
      mmLeft = 60325
      mmTop = 529
      mmWidth = 17992
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoParts_SubTotal'
      DataPipeline = daADOQueryDataView2.WoParts
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoParts'
      mmHeight = 3175
      mmLeft = 82021
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      BlankWhenZero = True
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoParts_SubTotal'
      DataPipeline = daADOQueryDataView3.WoTools
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      Visible = False
      DataPipelineName = 'WoTools'
      mmHeight = 3175
      mmLeft = 177536
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_TotalCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3175
      mmLeft = 152929
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_OtherCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3260
      mmLeft = 128852
      mmTop = 529
      mmWidth = 17198
      BandType = 4
    end
    object ppVariable2: TppVariable
      UserName = 'Variable2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      BlankWhenZero = False
      CalcOrder = 0
      DataType = dtCurrency
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3175
      mmLeft = 103717
      mmTop = 794
      mmWidth = 15610
      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 = 30734
      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 = 7144
    mmPrintPosition = 0
    object ppLine3: TppLine
      UserName = 'Line3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Weight = 0.750000000000000000
      mmHeight = 794
      mmLeft = 61383
      mmTop = 1058
      mmWidth = 111919
      BandType = 7
    end
    object ppDBCalc1: TppDBCalc
      UserName = 'DBCalc1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_TotalCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3260
      mmLeft = 152929
      mmTop = 2117
      mmWidth = 17198
      BandType = 7
    end
    object ppDBCalc2: TppDBCalc
      UserName = 'DBCalc2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoParts_SubTotal'
      DataPipeline = daADOQueryDataView3.WoTools
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoTools'
      mmHeight = 3175
      mmLeft = 102394
      mmTop = 2117
      mmWidth = 17198
      BandType = 7
    end
    object ppDBCalc3: TppDBCalc
      UserName = 'DBCalc3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_OtherCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3175
      mmLeft = 128852
      mmTop = 2117
      mmWidth = 17198
      BandType = 7
    end
    object ppDBCalc4: TppDBCalc
      UserName = 'DBCalc4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoParts_SubTotal'
      DataPipeline = daADOQueryDataView2.WoParts
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      ParentDataPipeline = False
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoParts'
      mmHeight = 3175
      mmLeft = 82021
      mmTop = 2117
      mmWidth = 17198
      BandType = 7
    end
    object ppDBCalc5: TppDBCalc
      UserName = 'DBCalc5'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'SUM_WoMaster_LaborCost'
      DataPipeline = daADOQueryDataView1.WoMaster
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      DataPipelineName = 'WoMaster'
      mmHeight = 3175
      mmLeft = 61119
      mmTop = 2117
      mmWidth = 17198
      BandType = 7
    end
    object ppVariable1: TppVariable
      UserName = 'Variable1'
      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 = []
      Transparent = True
      Visible = False
      mmHeight = 3175
      mmLeft = 175948
      mmTop = 1852
      mmWidth = 11906
      BandType = 7
    end
  end
  object raCodeModule1: TraCodeModule
    ProgramStream = {
      01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65061D
      5265706F72744265666F72654F70656E44617461506970656C696E65730B5072
      6F6772616D54797065070B747450726F63656475726506536F75726365069370
      726F636564757265205265706F72744265666F72654F70656E44617461506970
      656C696E65733B0D0A626567696E0D0A2020576F50617274732E4164644C696E
      6B28576F4D61737465722C2027556E6974272C2027556E697427293B0D0A2020
      576F546F6F6C732E4164644C696E6B28576F4D61737465722C2027556E697427
      2C2027556E697427293B0D0A656E643B0D0A0D436F6D706F6E656E744E616D65
      06065265706F7274094576656E744E616D6506174265666F72654F70656E4461
      7461506970656C696E6573074576656E7449440386000001060F547261457665
      6E7448616E646C65720B50726F6772616D4E616D65060F5661726961626C6531
      4F6E43616C630B50726F6772616D54797065070B747450726F63656475726506
      536F75726365067170726F636564757265205661726961626C65314F6E43616C
      63287661722056616C75653A2056617269616E74293B0D0A626567696E0D0A20
      696620576F546F6F6C735B27537562546F74616C275D3E30207468656E0D0A20
      2056616C7565203A3D56616C75652B313B0D0A656E643B0D0A0D436F6D706F6E
      656E744E616D6506095661726961626C6531094576656E744E616D6506064F6E
      43616C63074576656E74494402210001060F5472614576656E7448616E646C65
      720B50726F6772616D4E616D65060F5661726961626C65324F6E43616C630B50
      726F6772616D54797065070B747450726F63656475726506536F757263650661
      70726F636564757265205661726961626C65324F6E43616C6328766172205661
      6C75653A2056617269616E74293B0D0A626567696E0D0A0D0A202056616C7565
      203A3D576F546F6F6C735B27537562546F74616C275D3B0D0A0D0A656E643B0D
      0A0D436F6D706F6E656E744E616D6506095661726961626C6532094576656E74
      4E616D6506064F6E43616C63074576656E74494402210000}
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_WoMaster'
      Height = 234
      Left = 31
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 11
      TypeColumnWidth = 52
      Width = 246
      AutoSearchTabOrder = 0
      object WoMaster: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'WoMaster'
        object ppField1: TppField
          FieldAlias = 'Unit'
          FieldName = 'Unit'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 0
          TableName = 'WoMaster'
        end
        object ppField2: TppField
          FieldAlias = 'Name'
          FieldName = 'Name'
          FieldLength = 80
          IsDetail = True
          DisplayWidth = 10
          Position = 1
          TableName = 'Units'
        end
        object ppField3: TppField
          FieldAlias = 'LaborCost'
          FieldName = 'SUM_WoMaster_LaborCost'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 2
          TableName = 'WoMaster'
        end
        object ppField4: TppField
          FieldAlias = 'PartsCost'
          FieldName = 'SUM_WoMaster_PartsCost'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 3
          TableName = 'WoMaster'
        end
        object ppField5: TppField
          FieldAlias = 'OtherCost'
          FieldName = 'SUM_WoMaster_OtherCost'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 4
          TableName = 'WoMaster'
        end
        object ppField6: TppField
          FieldAlias = 'TotalCost'
          FieldName = 'SUM_WoMaster_TotalCost'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 5
          TableName = 'WoMaster'
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'WoMaster'
        GroupByFieldsSynced = True
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT WoMaster.Unit, Units.Name, '
          '       SUM(WoMaster.LaborCost) SUM_WoMaster_LaborCost, '
          '       SUM(WoMaster.PartsCost) SUM_WoMaster_PartsCost, '
          '       SUM(WoMaster.OtherCost) SUM_WoMaster_OtherCost, '
          '       SUM(WoMaster.TotalCost) SUM_WoMaster_TotalCost'
          'FROM WoMaster WoMaster INNER JOIN Units Units ON '
          '     (Units.RecordNumber = WoMaster.Unit)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND ('
          '      ( WoMaster.TotalCost > 0 ))'
          'GROUP BY WoMaster.Unit, Units.Name')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'LaborCost'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'LaborCost'
          FieldLength = 2
          FieldName = 'LaborCost'
          Linkable = False
          SQLFieldName = 'SUM_WoMaster_LaborCost'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
          CalcType = dacaSum
        end
        object daCalculation2: TdaCalculation
          ChildType = 8
          Alias = 'PartsCost'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'PartsCost'
          FieldLength = 2
          FieldName = 'PartsCost'
          Linkable = False
          SQLFieldName = 'SUM_WoMaster_PartsCost'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
          CalcType = dacaSum
        end
        object daCalculation3: TdaCalculation
          ChildType = 8
          Alias = 'OtherCost'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'OtherCost'
          FieldLength = 2
          FieldName = 'OtherCost'
          Linkable = False
          SQLFieldName = 'SUM_WoMaster_OtherCost'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
          CalcType = dacaSum
        end
        object daCalculation4: TdaCalculation
          ChildType = 8
          Alias = 'TotalCost'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'TotalCost'
          FieldLength = 2
          FieldName = 'TotalCost'
          Linkable = False
          SQLFieldName = 'SUM_WoMaster_TotalCost'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
          CalcType = dacaSum
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoGreaterThan
          Value = '0'
          object TdaField
            Alias = 'TotalCost'
            DataType = dtDouble
            DisplayWidth = 10
            FieldAlias = 'TotalCost'
            FieldLength = 10
            FieldName = 'TotalCost'
            Mandatory = True
            SQLFieldName = 'TotalCost'
            TableAlias = 'WoMaster'
            TableName = 'WoMaster'
            TableSQLAlias = 'WoMaster'
          end
          object TdaNumericValue
          end
        end
        object daField1: TdaField
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 0
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField2: TdaField
          Alias = 'Name'
          DisplayWidth = 10
          FieldAlias = 'Name'
          FieldLength = 80
          FieldName = 'Name'
          IsDetail = True
          SQLFieldName = 'Name'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField3: TdaField
          ChildType = 1
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField4: TdaField
          ChildType = 1
          Alias = 'Name'
          DisplayWidth = 10
          FieldAlias = 'Name'
          FieldLength = 10
          FieldName = 'Name'
          SQLFieldName = 'Name'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField5: TdaField
          ChildType = 2
          Alias = 'Name'
          DisplayWidth = 10
          FieldAlias = 'Name'
          FieldLength = 10
          FieldName = 'Name'
          SQLFieldName = 'Name'
          TableAlias = 'Units'
          TableName = 'Units'
          TableSQLAlias = 'Units'
        end
        object daField6: TdaField
          ChildType = 2
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'WoMaster'
          JoinType = dajtNone
          SQLAlias = 'WoMaster'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'Units'
          SQLAlias = 'Units'
          TableAlias = 'Units'
          TableName = 'Units'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField8: TdaField
              ChildType = 3
              Alias = 'RecordNumber'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'RecordNumber'
              FieldLength = 10
              FieldName = 'RecordNumber'
              SQLFieldName = 'RecordNumber'
              TableAlias = 'Units'
              TableName = 'Units'
              TableSQLAlias = 'Units'
            end
            object daField7: TdaField
              ChildType = 4
              Alias = 'Unit'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'Unit'
              FieldLength = 10
              FieldName = 'Unit'
              SQLFieldName = 'Unit'
              TableAlias = 'WoMaster'
              TableName = 'WoMaster'
              TableSQLAlias = 'WoMaster'
            end
          end
        end
      end
    end
    object daADOQueryDataView2: TdaADOQueryDataView
      UserName = 'Query_WoParts'
      Height = 237
      Left = 324
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 12
      TypeColumnWidth = 52
      Width = 250
      AutoSearchTabOrder = 0
      object WoParts: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'WoParts'
        object ppField1: TppField
          FieldAlias = 'Unit'
          FieldName = 'Unit'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 10
          Position = 0
          TableName = 'WoMaster'
        end
        object ppField2: TppField
          FieldAlias = 'UnitName'
          FieldName = 'UnitName'
          FieldLength = 80
          IsDetail = True
          DisplayWidth = 10
          Position = 1
          TableName = 'WoMaster'
        end
        object ppField3: TppField
          FieldAlias = 'SubTotal'
          FieldName = 'SUM_WoParts_SubTotal'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 2
          TableName = 'WoParts'
        end
      end
      object daSQL2: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'WoParts'
        GroupByFieldsSynced = True
        LinkColor = clNavy
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT WoMaster.Unit, WoMaster.UnitName, '
          '       SUM(WoParts.SubTotal) SUM_WoParts_SubTotal'
          'FROM WoParts WoParts'
          '      INNER JOIN WoMaster WoMaster ON '
          '     (WoMaster.Numbered = WoParts.WorkOrder)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND ('
          '      ( WoParts.Description NOT LIKE '#39'Exp%'#39' ))'
          'GROUP BY WoMaster.UnitName, WoMaster.Unit')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'SubTotal'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'SubTotal'
          FieldLength = 2
          FieldName = 'SubTotal'
          Linkable = False
          SQLFieldName = 'SUM_WoParts_SubTotal'
          TableAlias = 'WoParts'
          TableName = 'WoParts'
          TableSQLAlias = 'WoParts'
          CalcType = dacaSum
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoNotLike
          Value = 'Exp%'
          object TdaField
            Alias = 'Description'
            DisplayWidth = 10
            FieldAlias = 'Description'
            FieldLength = 10
            FieldName = 'Description'
            Mandatory = True
            SQLFieldName = 'Description'
            TableAlias = 'WoParts'
            TableName = 'WoParts'
            TableSQLAlias = 'WoParts'
          end
        end
        object daField1: TdaField
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 0
          FieldName = 'Unit'
          IsDetail = True
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField2: TdaField
          Alias = 'UnitName'
          DisplayWidth = 10
          FieldAlias = 'UnitName'
          FieldLength = 80
          FieldName = 'UnitName'
          IsDetail = True
          SQLFieldName = 'UnitName'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField3: TdaField
          ChildType = 1
          Alias = 'UnitName'
          DisplayWidth = 10
          FieldAlias = 'UnitName'
          FieldLength = 10
          FieldName = 'UnitName'
          SQLFieldName = 'UnitName'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField4: TdaField
          ChildType = 1
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField5: TdaField
          ChildType = 2
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'WoParts'
          JoinType = dajtNone
          SQLAlias = 'WoParts'
          TableAlias = 'WoParts'
          TableName = 'WoParts'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'WoMaster'
          SQLAlias = 'WoMaster'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField7: TdaField
              ChildType = 3
              Alias = 'Numbered'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'Numbered'
              FieldLength = 10
              FieldName = 'Numbered'
              SQLFieldName = 'Numbered'
              TableAlias = 'WoMaster'
              TableName = 'WoMaster'
              TableSQLAlias = 'WoMaster'
            end
            object daField6: TdaField
              ChildType = 4
              Alias = 'WorkOrder'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'WorkOrder'
              FieldLength = 10
              FieldName = 'WorkOrder'
              SQLFieldName = 'WorkOrder'
              TableAlias = 'WoParts'
              TableName = 'WoParts'
              TableSQLAlias = 'WoParts'
            end
          end
        end
      end
    end
    object daADOQueryDataView3: TdaADOQueryDataView
      UserName = 'Query_WoTools'
      Height = 234
      Left = 608
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 12
      TypeColumnWidth = 52
      Width = 242
      AutoSearchTabOrder = 0
      object WoTools: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'WoTools'
        object ppField1: TppField
          FieldAlias = 'Unit'
          FieldName = 'Unit'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 10
          Position = 0
          TableName = 'WoMaster'
        end
        object ppField2: TppField
          FieldAlias = 'UnitName'
          FieldName = 'UnitName'
          FieldLength = 80
          DisplayWidth = 10
          Position = 1
          TableName = 'WoMaster'
        end
        object ppField3: TppField
          FieldAlias = 'SubTotal'
          FieldName = 'SUM_WoParts_SubTotal'
          FieldLength = 2
          Linkable = False
          DataType = dtDouble
          DisplayWidth = 10
          Position = 2
          TableName = 'WoParts'
        end
      end
      object daSQL3: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'WoTools'
        GroupByFieldsSynced = True
        LinkColor = clGreen
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT WoMaster.Unit, WoMaster.UnitName, '
          '       SUM(WoParts.SubTotal) SUM_WoParts_SubTotal'
          'FROM WoMaster WoMaster'
          '      INNER JOIN WoParts WoParts ON '
          '     (WoParts.WorkOrder = WoMaster.Numbered)'
          'WHERE ('#39'c'#39' <> '#39'c'#39' ) AND ('
          '      ( WoParts.Description LIKE '#39'Exp%'#39' ))'
          'GROUP BY WoMaster.Unit, WoMaster.UnitName')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'SubTotal'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'SubTotal'
          FieldLength = 2
          FieldName = 'SubTotal'
          Linkable = False
          SQLFieldName = 'SUM_WoParts_SubTotal'
          TableAlias = 'WoParts'
          TableName = 'WoParts'
          TableSQLAlias = 'WoParts'
          CalcType = dacaSum
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLike
          Value = 'Exp%'
          object TdaField
            Alias = 'Description'
            DisplayWidth = 10
            FieldAlias = 'Description'
            FieldLength = 10
            FieldName = 'Description'
            Mandatory = True
            SQLFieldName = 'Description'
            TableAlias = 'WoParts'
            TableName = 'WoParts'
            TableSQLAlias = 'WoParts'
          end
        end
        object daField1: TdaField
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 0
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField2: TdaField
          Alias = 'UnitName'
          DisplayWidth = 10
          FieldAlias = 'UnitName'
          FieldLength = 80
          FieldName = 'UnitName'
          SQLFieldName = 'UnitName'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField3: TdaField
          ChildType = 1
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField4: TdaField
          ChildType = 1
          Alias = 'UnitName'
          DisplayWidth = 10
          FieldAlias = 'UnitName'
          FieldLength = 10
          FieldName = 'UnitName'
          SQLFieldName = 'UnitName'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daField5: TdaField
          ChildType = 2
          Alias = 'Unit'
          DataType = dtDouble
          DisplayWidth = 10
          FieldAlias = 'Unit'
          FieldLength = 10
          FieldName = 'Unit'
          SQLFieldName = 'Unit'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
          TableSQLAlias = 'WoMaster'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'WoMaster'
          JoinType = dajtNone
          SQLAlias = 'WoMaster'
          TableAlias = 'WoMaster'
          TableName = 'WoMaster'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'WoParts'
          SQLAlias = 'WoParts'
          TableAlias = 'WoParts'
          TableName = 'WoParts'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField7: TdaField
              ChildType = 3
              Alias = 'WorkOrder'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'WorkOrder'
              FieldLength = 10
              FieldName = 'WorkOrder'
              SQLFieldName = 'WorkOrder'
              TableAlias = 'WoParts'
              TableName = 'WoParts'
              TableSQLAlias = 'WoParts'
            end
            object daField6: TdaField
              ChildType = 4
              Alias = 'Numbered'
              DataType = dtDouble
              DisplayWidth = 10
              FieldAlias = 'Numbered'
              FieldLength = 10
              FieldName = 'Numbered'
              SQLFieldName = 'Numbered'
              TableAlias = 'WoMaster'
              TableName = 'WoMaster'
              TableSQLAlias = 'WoMaster'
            end
          end
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end