object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADSQueryDataView1.Matters
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Report'
  PrinterSetup.PaperName = 'Letter'
  PrinterSetup.PrinterName = 'Default'
  PrinterSetup.mmMarginBottom = 6350
  PrinterSetup.mmMarginLeft = 6350
  PrinterSetup.mmMarginRight = 6350
  PrinterSetup.mmMarginTop = 6350
  PrinterSetup.mmPaperHeight = 279401
  PrinterSetup.mmPaperWidth = 215900
  PrinterSetup.PaperSize = 1
  Template.DatabaseSettings.NameField = 'Name'
  Template.DatabaseSettings.TemplateField = 'Template'
  Template.FileName = 'I:\Fixed Reports\Closed Matters\Closed Matters by City.rtm'
  Template.Format = ftASCII
  DeviceType = 'Screen'
  ShowAutoSearchDialog = True
  Left = 332
  Top = 92
  Version = '6.03'
  mmColumnWidth = 0
  DataPipelineName = 'Matters'
  object ppTitleBand1: TppTitleBand
    mmBottomOffset = 0
    mmHeight = 12435
    mmPrintPosition = 0
    object TppShape
      UserName = 'Shape1'
      Brush.Color = clSilver
      Pen.Color = clSilver
      mmHeight = 12435
      mmLeft = 0
      mmTop = 0
      mmWidth = 203200
      BandType = 1
    end
    object ppLabel1: TppLabel
      UserName = 'Label1'
      Caption = 'Closed Matters by City'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWhite
      Font.Name = 'ARIAL'
      Font.Size = 24
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 10089
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 91017
      BandType = 1
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 6350
    mmPrintPosition = 0
    object ppLine1: TppLine
      UserName = 'Line1'
      Pen.Color = clGray
      Pen.Width = 3
      Weight = 2.25
      mmHeight = 1323
      mmLeft = 1323
      mmTop = 5027
      mmWidth = 200555
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      Caption = 'ZIP Code'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3810
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 13801
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 5556
    mmPrintPosition = 0
    object ppDBText8: TppDBText
      UserName = 'DBText8'
      AutoSize = True
      DataField = 'RTRIM_rolodex_lastname_RT'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 64029
      mmTop = 529
      mmWidth = 171803
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      AutoSize = True
      DataField = 'CaseManager'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 165629
      mmTop = 529
      mmWidth = 20673
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      AutoSize = True
      DataField = 'CaseNumber1'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 19579
      mmTop = 529
      mmWidth = 21237
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      AutoSize = True
      DataField = 'LawType'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 140229
      mmTop = 529
      mmWidth = 13406
      BandType = 4
    end
    object ppDBText6: TppDBText
      UserName = 'DBText6'
      AutoSize = True
      DataField = 'IntakeDate'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 41804
      mmTop = 529
      mmWidth = 15875
      BandType = 4
    end
    object ppDBText9: TppDBText
      UserName = 'DBText9'
      AutoSize = True
      DataField = 'SS'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 114829
      mmTop = 529
      mmWidth = 3598
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 7144
    mmPrintPosition = 0
    object TppShape
      UserName = 'Shape2'
      Brush.Color = clSilver
      Pen.Color = clSilver
      mmHeight = 7144
      mmLeft = 0
      mmTop = 0
      mmWidth = 203200
      BandType = 8
    end
    object ppLine2: TppLine
      UserName = 'Line2'
      Pen.Color = clGray
      Pen.Width = 3
      Weight = 2.25
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 5821
      mmWidth = 200555
      BandType = 8
    end
    object ppSystemVariable1: TppSystemVariable
      UserName = 'SystemVariable1'
      VarType = vtPrintDateTime
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4487
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 17187
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = 'SystemVariable2'
      VarType = vtPageNoDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 4487
      mmLeft = 184680
      mmTop = 1323
      mmWidth = 17187
      BandType = 8
    end
  end
  object ppSummaryBand1: TppSummaryBand
    mmBottomOffset = 0
    mmHeight = 6879
    mmPrintPosition = 0
    object ppDBCalc2: TppDBCalc
      UserName = 'DBCalc2'
      AutoSize = True
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Name = 'Times New Roman'
      Font.Size = 11
      Font.Style = [fsBold]
      TextAlignment = taRightJustified
      Transparent = True
      DBCalcType = dcCount
      DataPipelineName = 'Matters'
      mmHeight = 4516
      mmLeft = 29492
      mmTop = 1323
      mmWidth = 14958
      BandType = 7
    end
    object ppLabel11: TppLabel
      UserName = 'Label11'
      Caption = 'Grand Total:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'Times New Roman'
      Font.Size = 11
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 4572
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 22183
      BandType = 7
    end
  end
  object ppGroup1: TppGroup
    BreakName = 'City'
    DataPipeline = daADSQueryDataView1.Matters
    KeepTogether = True
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'Matters'
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 11377
      mmPrintPosition = 0
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        AutoSize = True
        DataField = 'Attorney_Lead'
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 11
        Font.Style = []
        Transparent = True
        DataPipelineName = 'Matters'
        mmHeight = 4516
        mmLeft = 1058
        mmTop = 1323
        mmWidth = 22296
        BandType = 3
        GroupNo = 0
      end
      object ppShape1: TppShape
        UserName = 'Shape3'
        Brush.Color = clYellow
        ParentWidth = True
        mmHeight = 6879
        mmLeft = 0
        mmTop = 0
        mmWidth = 203200
        BandType = 3
        GroupNo = 0
      end
      object ppLabel2: TppLabel
        UserName = 'Label2'
        Caption = 'Matter'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3704
        mmLeft = 12700
        mmTop = 7673
        mmWidth = 9525
        BandType = 3
        GroupNo = 0
      end
      object ppDBText10: TppDBText
        UserName = 'DBText10'
        AutoSize = True
        DataField = 'City'
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 11
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = 'Matters'
        mmHeight = 4572
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 7154
        BandType = 3
        GroupNo = 0
      end
      object ppLabel12: TppLabel
        UserName = 'Label12'
        Caption = 'Closed Date'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3810
        mmLeft = 165100
        mmTop = 7673
        mmWidth = 18203
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 9525
      mmPrintPosition = 0
      object ppDBCalc1: TppDBCalc
        UserName = 'DBCalc1'
        AutoSize = True
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Times New Roman'
        Font.Size = 11
        Font.Style = [fsBold]
        ResetGroup = ppGroup1
        TextAlignment = taRightJustified
        Transparent = True
        DBCalcType = dcCount
        DataPipelineName = 'Matters'
        mmHeight = 4516
        mmLeft = 29492
        mmTop = 1323
        mmWidth = 14958
        BandType = 5
        GroupNo = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        Caption = 'Total:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Times New Roman'
        Font.Size = 11
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4498
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 10319
        BandType = 5
        GroupNo = 0
      end
    end
  end
  object ppGroup2: TppGroup
    BreakName = 'Title'
    DataPipeline = daADSQueryDataView1.Matters
    KeepTogether = True
    UserName = 'Group2'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'Matters'
    object ppGroupHeaderBand2: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 11377
      mmPrintPosition = 0
      object ppShape2: TppShape
        UserName = 'Shape4'
        Brush.Color = clAqua
        mmHeight = 6879
        mmLeft = 11377
        mmTop = 0
        mmWidth = 191823
        BandType = 3
        GroupNo = 1
      end
      object ppLabel9: TppLabel
        UserName = 'Label9'
        Caption = 'Client'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 64029
        mmTop = 7567
        mmWidth = 8678
        BandType = 3
        GroupNo = 1
      end
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        AutoSize = True
        DataField = 'Title'
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 11
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = 'Matters'
        mmHeight = 4498
        mmLeft = 12700
        mmTop = 1323
        mmWidth = 41540
        BandType = 3
        GroupNo = 1
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        Caption = 'Case Manager'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 165629
        mmTop = 7567
        mmWidth = 21632
        BandType = 3
        GroupNo = 1
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        Caption = 'Case #'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 19579
        mmTop = 7567
        mmWidth = 10287
        BandType = 3
        GroupNo = 1
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        Caption = 'Law Type'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 140229
        mmTop = 7567
        mmWidth = 14436
        BandType = 3
        GroupNo = 1
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        Caption = 'Intake Date'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 41804
        mmTop = 7567
        mmWidth = 17018
        BandType = 3
        GroupNo = 1
      end
      object ppLabel10: TppLabel
        UserName = 'Label10'
        Caption = 'SS #'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3810
        mmLeft = 114829
        mmTop = 7567
        mmWidth = 6900
        BandType = 3
        GroupNo = 1
      end
      object ppDBText7: TppDBText
        UserName = 'DBText7'
        AutoSize = True
        DataField = 'CloseDate'
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 11
        Font.Style = [fsBold]
        Transparent = True
        DataPipelineName = 'Matters'
        mmHeight = 4516
        mmLeft = 165365
        mmTop = 1058
        mmWidth = 16157
        BandType = 3
        GroupNo = 1
      end
    end
    object ppGroupFooterBand2: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
  end
  object daDataModule1: TdaDataModule
    object daADSQueryDataView1: TdaADSQueryDataView
      Report = ppReport1
      UserName = 'Query_Matters'
      Height = 304
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 200
      AutoSearchTabOrder = 0
      object Matters: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'Matters'
        object ppField1: TppField
          FieldAlias = 'Title'
          FieldName = 'Title'
          FieldLength = 100
          DisplayWidth = 100
          Position = 0
          TableName = 'Matters'
        end
        object ppField2: TppField
          FieldAlias = 'Attorney Lead'
          FieldName = 'Attorney_Lead'
          FieldLength = 10
          DisplayWidth = 10
          Position = 1
          TableName = 'Matters'
        end
        object ppField3: TppField
          FieldAlias = 'Casemanager'
          FieldName = 'CaseManager'
          FieldLength = 10
          DisplayWidth = 10
          Position = 2
          TableName = 'Matters'
        end
        object ppField4: TppField
          FieldAlias = 'Casenumber1'
          FieldName = 'CaseNumber1'
          FieldLength = 15
          DisplayWidth = 15
          Position = 3
          TableName = 'Matters'
        end
        object ppField5: TppField
          FieldAlias = 'Lawtype'
          FieldName = 'LawType'
          FieldLength = 4
          DisplayWidth = 4
          Position = 4
          TableName = 'Matters'
        end
        object ppField6: TppField
          FieldAlias = 'Location'
          FieldName = 'Location'
          FieldLength = 30
          DisplayWidth = 30
          Position = 5
          TableName = 'Matters'
        end
        object ppField7: TppField
          FieldAlias = 'Ss'
          FieldName = 'SS'
          FieldLength = 11
          IsDetail = True
          DisplayWidth = 11
          Position = 6
          TableName = 'Rolodex'
        end
        object ppField8: TppField
          FieldAlias = 'Intakedate'
          FieldName = 'IntakeDate'
          FieldLength = 0
          DataType = dtDate
          DisplayWidth = 10
          Position = 7
          TableName = 'Matters'
        end
        object ppField9: TppField
          FieldAlias = 'City'
          FieldName = 'City'
          FieldLength = 35
          IsDetail = True
          DisplayWidth = 35
          Position = 8
          TableName = 'Rolodex'
        end
        object ppField10: TppField
          FieldAlias = 'Closedate'
          FieldName = 'CloseDate'
          FieldLength = 0
          DataType = dtDate
          DisplayWidth = 0
          Position = 9
          TableName = 'Matters'
        end
        object ppField11: TppField
          FieldAlias = 
            'RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname) + '#39' '#39' ' +
            '+ IFNULL(RTRIM(rolodex.middlename), '#39#39')'
          FieldName = 'RTRIM_rolodex_lastname_RT'
          FieldLength = 20
          Linkable = False
          DisplayWidth = 20
          Position = 10
          TableName = 'Rolodex'
        end
      end
      object daSQL1: TdaSQL
        CollationType = ctASCII
        DatabaseName = 'euDatabase'
        DatabaseType = dtAdvantage
        DataPipelineName = 'Matters'
        IsCaseSensitive = True
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT Matters.Title, Matters.Attorney_Lead, '
          '       Matters.CaseManager, Matters.CaseNumber1, '
          '       Matters.LawType, Matters.Location, '
          '       Rolodex.SS, Matters.IntakeDate, '
          '       Rolodex.City, Matters.CloseDate, '
          
            '       RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname)' +
            ' + '#39' '#39' + IFNULL(RTRIM(rolodex.middlename), '#39#39') AS RTRIM_rolodex_' +
            'lastname_RT'
          'FROM Matters Matters'
          '      LEFT OUTER JOIN Related Related ON '
          '     (Related.ID = Matters.MatterID)'
          '      LEFT OUTER JOIN Rolodex Rolodex ON '
          '     (Rolodex.Ident = Related.Related)'
          'WHERE ( Matters."Active" = 0 )'
          '       AND ( Related.Client = 1 )'
          'ORDER BY Rolodex.City, Matters.Title, '
          '         Rolodex.Lastname, Rolodex.Firstname, '
          '         Rolodex.Middlename')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 
            'RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname) + '#39' '#39' ' +
            '+ IFNULL(RTRIM(rolodex.middlename), '#39#39')'
          DisplayWidth = 20
          FieldAlias = 'Lastname'
          FieldLength = 20
          FieldName = 'Lastname'
          Linkable = False
          SQLFieldName = 'RTRIM_rolodex_lastname_RT'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
          CalcType = dacaExpression
          Expression = 
            'RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname) + '#39' '#39' ' +
            '+ IFNULL(RTRIM(rolodex.middlename), '#39#39')'
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'False'
          object TdaField
            Alias = 'Active'
            DataType = dtBoolean
            DisplayWidth = 5
            FieldAlias = 'Active'
            FieldLength = 0
            FieldName = 'Active'
            SQLFieldName = 'Active'
            TableAlias = 'Matters'
            TableName = 'Matters'
            TableSQLAlias = 'Matters'
          end
        end
        object daCriteria2: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'True'
          object TdaField
            Alias = 'Client'
            DataType = dtBoolean
            DisplayWidth = 5
            FieldAlias = 'Client'
            FieldLength = 0
            FieldName = 'Client'
            SQLFieldName = 'Client'
            TableAlias = 'Related'
            TableName = 'Related'
            TableSQLAlias = 'Related'
          end
        end
        object daCriteria3: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLike
          object TdaField
            Alias = 'City'
            AutoSearch = True
            DisplayWidth = 35
            FieldAlias = 'City'
            FieldLength = 35
            FieldName = 'City'
            ShowAllValues = True
            SQLFieldName = 'City'
            TableAlias = 'Rolodex'
            TableName = 'Rolodex'
            TableSQLAlias = 'Rolodex'
          end
        end
        object daField1: TdaField
          Alias = 'Title'
          DisplayWidth = 100
          FieldAlias = 'Title'
          FieldLength = 100
          FieldName = 'Title'
          SQLFieldName = 'Title'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField2: TdaField
          Alias = 'Attorney Lead'
          DisplayWidth = 10
          FieldAlias = 'Attorney Lead'
          FieldLength = 10
          FieldName = 'Attorney_Lead'
          SQLFieldName = 'Attorney_Lead'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField3: TdaField
          Alias = 'Casemanager'
          DisplayWidth = 10
          FieldAlias = 'Casemanager'
          FieldLength = 10
          FieldName = 'CaseManager'
          SQLFieldName = 'CaseManager'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField4: TdaField
          Alias = 'Casenumber1'
          DisplayWidth = 15
          FieldAlias = 'Casenumber1'
          FieldLength = 15
          FieldName = 'CaseNumber1'
          SQLFieldName = 'CaseNumber1'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField5: TdaField
          Alias = 'Lawtype'
          DisplayWidth = 4
          FieldAlias = 'Lawtype'
          FieldLength = 4
          FieldName = 'LawType'
          SQLFieldName = 'LawType'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField6: TdaField
          Alias = 'Location'
          DisplayWidth = 30
          FieldAlias = 'Location'
          FieldLength = 30
          FieldName = 'Location'
          SQLFieldName = 'Location'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField7: TdaField
          Alias = 'Ss'
          DisplayWidth = 11
          FieldAlias = 'Ss'
          FieldLength = 11
          FieldName = 'SS'
          IsDetail = True
          SQLFieldName = 'SS'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daField8: TdaField
          Alias = 'Intakedate'
          DataType = dtDate
          DisplayWidth = 10
          FieldAlias = 'Intakedate'
          FieldLength = 0
          FieldName = 'IntakeDate'
          SQLFieldName = 'IntakeDate'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField9: TdaField
          Alias = 'City'
          DisplayWidth = 35
          FieldAlias = 'City'
          FieldLength = 35
          FieldName = 'City'
          IsDetail = True
          SQLFieldName = 'City'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daField10: TdaField
          Alias = 'Closedate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Closedate'
          FieldLength = 0
          FieldName = 'CloseDate'
          SQLFieldName = 'CloseDate'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField11: TdaField
          ChildType = 2
          Alias = 'City'
          DisplayWidth = 35
          FieldAlias = 'City'
          FieldLength = 35
          FieldName = 'City'
          SQLFieldName = 'City'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daField12: TdaField
          ChildType = 2
          Alias = 'Title'
          DisplayWidth = 100
          FieldAlias = 'Title'
          FieldLength = 100
          FieldName = 'Title'
          SQLFieldName = 'Title'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField13: TdaField
          ChildType = 2
          Alias = 'Lastname'
          DisplayWidth = 20
          FieldAlias = 'Lastname'
          FieldLength = 20
          FieldName = 'Lastname'
          SQLFieldName = 'Lastname'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daField14: TdaField
          ChildType = 2
          Alias = 'Firstname'
          DisplayWidth = 20
          FieldAlias = 'Firstname'
          FieldLength = 20
          FieldName = 'Firstname'
          SQLFieldName = 'Firstname'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daField15: TdaField
          ChildType = 2
          Alias = 'Middlename'
          DisplayWidth = 20
          FieldAlias = 'Middlename'
          FieldLength = 20
          FieldName = 'Middlename'
          SQLFieldName = 'Middlename'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'Matters'
          JoinType = dajtNone
          SQLAlias = 'Matters'
          TableAlias = 'Matters'
          TableName = 'Matters'
        end
        object daTable2: TdaTable
          ChildType = 5
          Alias = 'Related'
          JoinType = dajtLeftOuter
          SQLAlias = 'Related'
          TableAlias = 'Related'
          TableName = 'Related'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField17: TdaField
              ChildType = 3
              Alias = 'Id'
              DisplayWidth = 10
              FieldAlias = 'Id'
              FieldLength = 10
              FieldName = 'ID'
              SQLFieldName = 'ID'
              TableAlias = 'Related'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
            object daField16: TdaField
              ChildType = 4
              Alias = 'Matterid'
              DisplayWidth = 10
              FieldAlias = 'Matterid'
              FieldLength = 10
              FieldName = 'MatterID'
              SQLFieldName = 'MatterID'
              TableAlias = 'Matters'
              TableName = 'Matters'
              TableSQLAlias = 'Matters'
            end
          end
        end
        object daTable3: TdaTable
          ChildType = 5
          Alias = 'Rolodex'
          JoinType = dajtLeftOuter
          SQLAlias = 'Rolodex'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          object daTableJoin2: TdaTableJoin
            ChildType = 6
            object daField19: TdaField
              ChildType = 3
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex'
            end
            object daField18: TdaField
              ChildType = 4
              Alias = 'Related'
              DisplayWidth = 10
              FieldAlias = 'Related'
              FieldLength = 10
              FieldName = 'Related'
              SQLFieldName = 'Related'
              TableAlias = 'Related'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
          end
        end
      end
    end
  end
end