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 = 
    'C:\Documents and Settings\gshoemate\Desktop\Reports for Carl\Fix' +
    'ed Report Vault\Fixed Reports\Analysis\Law Type by ZIP Code.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 = 'Law Type by ZIP Code'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWhite
      Font.Name = 'ARIAL'
      Font.Size = 24
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 9948
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 89747
      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 ppLabel2: TppLabel
      UserName = 'Label2'
      Caption = 'Law Type'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3810
      mmLeft = 1323
      mmTop = 1058
      mmWidth = 14436
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 10319
    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 = 4572
      mmLeft = 61383
      mmTop = 529
      mmWidth = 172805
      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 = 4572
      mmLeft = 37835
      mmTop = 529
      mmWidth = 21378
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      AutoSize = True
      DataField = 'Status'
      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 = 4763
      mmLeft = 151342
      mmTop = 529
      mmWidth = 16404
      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 = 4572
      mmLeft = 11642
      mmTop = 529
      mmWidth = 16171
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      AutoSize = True
      DataField = 'FullName'
      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 = 4763
      mmLeft = 37835
      mmTop = 5556
      mmWidth = 15346
      BandType = 4
    end
    object ppDBText9: TppDBText
      UserName = 'DBText9'
      AutoSize = True
      DataField = 'CaseType'
      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 = 4572
      mmLeft = 105304
      mmTop = 529
      mmWidth = 14266
      BandType = 4
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      Caption = 'Referral Source:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold]
      Transparent = True
      mmHeight = 3969
      mmLeft = 11642
      mmTop = 5556
      mmWidth = 25135
      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 ppGroup1: TppGroup
    BreakName = 'LawType'
    DataPipeline = daADSQueryDataView1.Matters
    KeepTogether = True
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'Matters'
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 11377
      mmPrintPosition = 0
      object ppShape1: TppShape
        UserName = 'Shape3'
        Brush.Color = clYellow
        ParentWidth = True
        mmHeight = 6879
        mmLeft = 0
        mmTop = 0
        mmWidth = 203200
        BandType = 3
        GroupNo = 0
      end
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        AutoSize = True
        DataField = 'LawType'
        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 = 2910
        mmTop = 1323
        mmWidth = 14563
        BandType = 3
        GroupNo = 0
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        Caption = 'ZIP Code'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3810
        mmLeft = 6350
        mmTop = 7567
        mmWidth = 13801
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 529
      mmPrintPosition = 0
    end
  end
  object ppGroup2: TppGroup
    BreakName = 'LEFT_rolodex_zipcode_5'
    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 = 5556
        mmTop = 0
        mmWidth = 197644
        BandType = 3
        GroupNo = 1
      end
      object ppDBText7: TppDBText
        UserName = 'DBText7'
        AutoSize = True
        DataField = 'LEFT_rolodex_zipcode_5'
        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 = 6350
        mmTop = 1323
        mmWidth = 42714
        BandType = 3
        GroupNo = 1
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        Caption = 'Matter'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3704
        mmLeft = 10319
        mmTop = 7673
        mmWidth = 9525
        BandType = 3
        GroupNo = 1
      end
    end
    object ppGroupFooterBand2: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 529
      mmPrintPosition = 0
    end
  end
  object ppGroup3: TppGroup
    BreakName = 'Title'
    DataPipeline = daADSQueryDataView1.Matters
    KeepTogether = True
    UserName = 'Group3'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'Matters'
    object ppGroupHeaderBand3: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 11906
      mmPrintPosition = 0
      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 = 61383
        mmTop = 7673
        mmWidth = 8678
        BandType = 3
        GroupNo = 2
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        Caption = 'Intake Date'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3704
        mmLeft = 11113
        mmTop = 7673
        mmWidth = 18785
        BandType = 3
        GroupNo = 2
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        Caption = 'Status'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3704
        mmLeft = 151342
        mmTop = 7938
        mmWidth = 9790
        BandType = 3
        GroupNo = 2
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        Caption = 'Case #'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3704
        mmLeft = 37835
        mmTop = 7673
        mmWidth = 10319
        BandType = 3
        GroupNo = 2
      end
      object ppShape3: TppShape
        UserName = 'Shape5'
        Brush.Color = clLime
        mmHeight = 6879
        mmLeft = 9260
        mmTop = 0
        mmWidth = 191823
        BandType = 3
        GroupNo = 2
      end
      object ppDBText3: TppDBText
        UserName = 'DBText3'
        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 = 4763
        mmLeft = 10319
        mmTop = 1323
        mmWidth = 7673
        BandType = 3
        GroupNo = 2
      end
      object ppLabel10: TppLabel
        UserName = 'Label10'
        Caption = 'Case Type'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 3704
        mmLeft = 105304
        mmTop = 7938
        mmWidth = 15875
        BandType = 3
        GroupNo = 2
      end
    end
    object ppGroupFooterBand3: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 794
      mmPrintPosition = 0
    end
  end
  object daDataModule1: TdaDataModule
    object daADSQueryDataView1: TdaADSQueryDataView
      Report = ppReport1
      UserName = 'Query_Matters'
      Height = 266
      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 = 'Lawtype'
          FieldName = 'LawType'
          FieldLength = 4
          DisplayWidth = 4
          Position = 0
          TableName = 'Matters'
        end
        object ppField2: TppField
          FieldAlias = 'Status'
          FieldName = 'Status'
          FieldLength = 30
          DisplayWidth = 30
          Position = 1
          TableName = 'Matters'
        end
        object ppField3: TppField
          FieldAlias = 'Casenumber1'
          FieldName = 'CaseNumber1'
          FieldLength = 15
          DisplayWidth = 15
          Position = 2
          TableName = 'Matters'
        end
        object ppField4: TppField
          FieldAlias = 'Office'
          FieldName = 'Office'
          FieldLength = 100
          IsDetail = True
          DisplayWidth = 100
          Position = 3
          TableName = 'Rolodex_2'
        end
        object ppField5: TppField
          FieldAlias = 'Intakedate'
          FieldName = 'IntakeDate'
          FieldLength = 0
          DataType = dtDate
          DisplayWidth = 0
          Position = 4
          TableName = 'Matters'
        end
        object ppField6: TppField
          FieldAlias = 'Title'
          FieldName = 'Title'
          FieldLength = 100
          DisplayWidth = 100
          Position = 5
          TableName = 'Matters'
        end
        object ppField7: TppField
          FieldAlias = 'Casetype'
          FieldName = 'CaseType'
          FieldLength = 30
          DisplayWidth = 30
          Position = 6
          TableName = 'Matters'
        end
        object ppField8: TppField
          FieldAlias = 'FullName'
          FieldName = 'FullName'
          FieldLength = 150
          IsDetail = True
          DisplayWidth = 150
          Position = 7
          TableName = 'Rolodex_2'
        end
        object ppField9: 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 = 8
          TableName = 'Rolodex'
        end
        object ppField10: TppField
          FieldAlias = 'LEFT(rolodex.zipcode, 5)'
          FieldName = 'LEFT_rolodex_zipcode_5'
          FieldLength = 10
          Linkable = False
          DisplayWidth = 10
          Position = 9
          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.LawType, Matters.Status, '
          '       Matters.CaseNumber1, Rolodex_2.Office, '
          '       Matters.IntakeDate, Matters.Title, '
          '       Matters.CaseType, Rolodex_2.FullName, '
          
            '       RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname)' +
            ' + '#39' '#39' + IFNULL(RTRIM(rolodex.middlename), '#39#39') AS RTRIM_rolodex_' +
            'lastname_RT, '
          '       LEFT(rolodex.zipcode, 5) AS LEFT_rolodex_zipcode_5'
          'FROM Matters Matters'
          '      LEFT OUTER JOIN Related Related ON '
          '     (Related.ID = Matters.MatterID)'
          '      LEFT OUTER JOIN Rolodex Rolodex ON '
          '     (Rolodex.Ident = Related.Related)'
          '      LEFT OUTER JOIN Rolodex Rolodex_2 ON '
          '     (Rolodex_2.Ident = Rolodex.ReferralSource1)'
          'WHERE ( Matters."Active" = 1 )'
          '       AND ( Related.Client = 1 )'
          'ORDER BY Matters.LawType, 10, Matters.IntakeDate')
        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 daCalculation2: TdaCalculation
          ChildType = 8
          Alias = 'LEFT(rolodex.zipcode, 5)'
          DisplayWidth = 10
          FieldAlias = 'Zipcode'
          FieldLength = 10
          FieldName = 'Zipcode'
          Linkable = False
          SQLFieldName = 'LEFT_rolodex_zipcode_5'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
          CalcType = dacaExpression
          Expression = 'LEFT(rolodex.zipcode, 5)'
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLike
          object TdaField
            Alias = 'Zipcode'
            AutoSearch = True
            DisplayWidth = 10
            FieldAlias = 'Zipcode'
            FieldLength = 10
            FieldName = 'Zipcode'
            SQLFieldName = 'Zipcode'
            TableAlias = 'Rolodex'
            TableName = 'Rolodex'
            TableSQLAlias = 'Rolodex'
          end
        end
        object daCriteria2: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoBetween
          object TdaField
            Alias = 'Intakedate'
            AutoSearch = True
            DataType = dtDate
            DisplayWidth = 10
            FieldAlias = 'Intakedate'
            FieldLength = 0
            FieldName = 'IntakeDate'
            SQLFieldName = 'IntakeDate'
            TableAlias = 'Matters'
            TableName = 'Matters'
            TableSQLAlias = 'Matters'
          end
        end
        object daCriteria3: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'True'
          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 daCriteria4: 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 daField1: TdaField
          Alias = 'Lawtype'
          DisplayWidth = 4
          FieldAlias = 'Lawtype'
          FieldLength = 4
          FieldName = 'LawType'
          SQLFieldName = 'LawType'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField2: TdaField
          Alias = 'Status'
          DisplayWidth = 30
          FieldAlias = 'Status'
          FieldLength = 30
          FieldName = 'Status'
          SQLFieldName = 'Status'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField3: TdaField
          Alias = 'Casenumber1'
          DisplayWidth = 15
          FieldAlias = 'Casenumber1'
          FieldLength = 15
          FieldName = 'CaseNumber1'
          SQLFieldName = 'CaseNumber1'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField4: TdaField
          Alias = 'Office'
          DisplayWidth = 100
          FieldAlias = 'Office'
          FieldLength = 100
          FieldName = 'Office'
          IsDetail = True
          SQLFieldName = 'Office'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex_2'
        end
        object daField5: TdaField
          Alias = 'Intakedate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Intakedate'
          FieldLength = 0
          FieldName = 'IntakeDate'
          SQLFieldName = 'IntakeDate'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField6: TdaField
          Alias = 'Title'
          DisplayWidth = 100
          FieldAlias = 'Title'
          FieldLength = 100
          FieldName = 'Title'
          SQLFieldName = 'Title'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField7: TdaField
          Alias = 'Casetype'
          DisplayWidth = 30
          FieldAlias = 'Casetype'
          FieldLength = 30
          FieldName = 'CaseType'
          SQLFieldName = 'CaseType'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField8: TdaField
          Alias = 'FullName'
          DisplayWidth = 150
          FieldAlias = 'FullName'
          FieldLength = 150
          FieldName = 'FullName'
          IsDetail = True
          SQLFieldName = 'FullName'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex_2'
        end
        object daField9: TdaField
          ChildType = 2
          Alias = 'Lawtype'
          DisplayWidth = 4
          FieldAlias = 'Lawtype'
          FieldLength = 4
          FieldName = 'LawType'
          SQLFieldName = 'LawType'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daCalculation3: TdaCalculation
          ChildType = 2
          Alias = 'LEFT(rolodex.zipcode, 5)'
          DisplayWidth = 10
          FieldAlias = 'Zipcode'
          FieldLength = 10
          FieldName = 'Zipcode'
          Linkable = False
          SQLFieldName = 'LEFT_rolodex_zipcode_5'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex'
          CalcType = dacaExpression
          Expression = 'LEFT(rolodex.zipcode, 5)'
        end
        object daField10: TdaField
          ChildType = 2
          Alias = 'Intakedate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Intakedate'
          FieldLength = 0
          FieldName = 'IntakeDate'
          SQLFieldName = 'IntakeDate'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        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 daField12: TdaField
              ChildType = 3
              Alias = 'Id'
              DisplayWidth = 10
              FieldAlias = 'Id'
              FieldLength = 10
              FieldName = 'ID'
              SQLFieldName = 'ID'
              TableAlias = 'Related'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
            object daField11: 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 daField14: TdaField
              ChildType = 3
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex'
            end
            object daField13: TdaField
              ChildType = 4
              Alias = 'Related'
              DisplayWidth = 10
              FieldAlias = 'Related'
              FieldLength = 10
              FieldName = 'Related'
              SQLFieldName = 'Related'
              TableAlias = 'Related'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
          end
        end
        object daTable4: TdaTable
          ChildType = 5
          Alias = 'Rolodex'
          JoinType = dajtLeftOuter
          SQLAlias = 'Rolodex_2'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          object daTableJoin3: TdaTableJoin
            ChildType = 6
            object daField16: TdaField
              ChildType = 3
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex_2'
            end
            object daField15: TdaField
              ChildType = 4
              Alias = 'Referralsource1'
              DisplayWidth = 10
              FieldAlias = 'Referralsource1'
              FieldLength = 10
              FieldName = 'ReferralSource1'
              SQLFieldName = 'ReferralSource1'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex'
            end
          end
        end
      end
    end
  end
end