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\Med' +
    'ical\Medical History with Notes.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 ppLine1: TppLine
      UserName = 'Line1'
      Pen.Color = clGray
      Pen.Width = 3
      Weight = 2.25
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 200555
      BandType = 1
    end
    object ppLabel1: TppLabel
      UserName = 'Label1'
      Caption = 'Medical History w/Notes '
      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 = 99822
      BandType = 1
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 3704
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = 'Line2'
      Pen.Color = clGray
      Pen.Width = 3
      Weight = 2.25
      mmHeight = 1852
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 200555
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    PrintHeight = phDynamic
    mmBottomOffset = 0
    mmHeight = 30427
    mmPrintPosition = 0
    object ppLabel9: TppLabel
      UserName = 'Label9'
      AutoSize = False
      Caption = 'Medical Provider'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3810
      mmLeft = 1058
      mmTop = 529
      mmWidth = 53446
      BandType = 4
    end
    object ppLabel10: TppLabel
      UserName = 'Label10'
      AutoSize = False
      Caption = 'Subject'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 794
      mmTop = 9790
      mmWidth = 53446
      BandType = 4
    end
    object ppDBText9: TppDBText
      UserName = 'DBText9'
      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 = 4572
      mmLeft = 1058
      mmTop = 4763
      mmWidth = 15536
      BandType = 4
    end
    object ppLabel11: TppLabel
      UserName = 'Label101'
      AutoSize = False
      Caption = 'From'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 98161
      mmTop = 9790
      mmWidth = 16933
      BandType = 4
    end
    object ppLabel12: TppLabel
      UserName = 'Label12'
      AutoSize = False
      Caption = 'To'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 118798
      mmTop = 9790
      mmWidth = 13758
      BandType = 4
    end
    object ppLabel13: TppLabel
      UserName = 'Label13'
      Caption = 'Rec. Req.'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 141023
      mmTop = 9790
      mmWidth = 14552
      BandType = 4
    end
    object ppLabel14: TppLabel
      UserName = 'Label14'
      Caption = 'Rec. Recvd.'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 161396
      mmTop = 9790
      mmWidth = 17992
      BandType = 4
    end
    object ppLabel15: TppLabel
      UserName = 'Label15'
      AutoSize = False
      Caption = 'Bill'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3704
      mmLeft = 184680
      mmTop = 9790
      mmWidth = 11906
      BandType = 4
    end
    object ppDBText10: TppDBText
      UserName = 'DBText10'
      AutoSize = True
      DataField = 'FromDate'
      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 = 98161
      mmTop = 14288
      mmWidth = 14901
      BandType = 4
    end
    object ppDBText11: TppDBText
      UserName = 'DBText11'
      AutoSize = True
      DataField = 'ToDate'
      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 = 119063
      mmTop = 14288
      mmWidth = 10880
      BandType = 4
    end
    object ppDBText12: TppDBText
      UserName = 'DBText12'
      AutoSize = True
      DataField = 'RequestDate'
      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 = 141288
      mmTop = 14288
      mmWidth = 19092
      BandType = 4
    end
    object ppDBText13: TppDBText
      UserName = 'DBText13'
      AutoSize = True
      DataField = 'ReceiveDate'
      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 = 161661
      mmTop = 14288
      mmWidth = 19050
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = 'DBText5'
      AutoSize = True
      DataField = 'Bill'
      DataPipeline = daADSQueryDataView1.Matters
      DisplayFormat = '$#,0.00;($#,0.00)'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = []
      Transparent = True
      DataPipelineName = 'Matters'
      mmHeight = 4572
      mmLeft = 184680
      mmTop = 14288
      mmWidth = 5884
      BandType = 4
    end
    object ppDBText15: TppDBText
      UserName = 'DBText15'
      AutoSize = True
      DataField = 'Subject'
      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 = 794
      mmTop = 14288
      mmWidth = 11769
      BandType = 4
    end
    object ppLabel16: TppLabel
      UserName = 'Label16'
      AutoSize = False
      Caption = 'Notes:'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = [fsBold, fsUnderline]
      Transparent = True
      mmHeight = 3440
      mmLeft = 1058
      mmTop = 20638
      mmWidth = 13494
      BandType = 4
    end
    object ppDBMemo2: TppDBMemo
      UserName = 'DBMemo2'
      CharWrap = True
      Color = clSilver
      DataField = 'Notes'
      DataPipeline = daADSQueryDataView1.Matters
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 9
      Font.Style = []
      Stretch = True
      DataPipelineName = 'Matters'
      mmHeight = 4763
      mmLeft = 12965
      mmTop = 20902
      mmWidth = 188119
      BandType = 4
      mmBottomOffset = 0
      mmOverFlowOffset = 0
      mmStopPosition = 0
      mmLeading = 0
    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 ppLine4: TppLine
      UserName = 'Line4'
      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 = 'Title'
    DataPipeline = daADSQueryDataView1.Matters
    UserName = 'Group1'
    mmNewColumnThreshold = 0
    mmNewPageThreshold = 0
    DataPipelineName = 'Matters'
    object ppGroupHeaderBand1: TppGroupHeaderBand
      mmBottomOffset = 0
      mmHeight = 17463
      mmPrintPosition = 0
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        Color = clYellow
        DataField = 'Title'
        DataPipeline = daADSQueryDataView1.Matters
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 11
        Font.Style = [fsBold]
        DataPipelineName = 'Matters'
        mmHeight = 4763
        mmLeft = 265
        mmTop = 529
        mmWidth = 200819
        BandType = 3
        GroupNo = 0
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        AutoSize = False
        Caption = 'Casemanager'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 176742
        mmTop = 6615
        mmWidth = 22225
        BandType = 3
        GroupNo = 0
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Caption = 'Attorney Lead'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 153194
        mmTop = 6615
        mmWidth = 21960
        BandType = 3
        GroupNo = 0
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Caption = 'Lawtype'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 135996
        mmTop = 6615
        mmWidth = 13758
        BandType = 3
        GroupNo = 0
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        AutoSize = False
        Caption = 'Ss'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 112713
        mmTop = 6615
        mmWidth = 5027
        BandType = 3
        GroupNo = 0
      end
      object ppLabel3: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Caption = 'Intakedate'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 28310
        mmTop = 6615
        mmWidth = 16933
        BandType = 3
        GroupNo = 0
      end
      object ppLabel2: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Caption = 'Casenumber1'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 794
        mmTop = 6615
        mmWidth = 22225
        BandType = 3
        GroupNo = 0
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        AutoSize = False
        Caption = 'Plaintiff'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 9
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3969
        mmLeft = 49477
        mmTop = 6615
        mmWidth = 53446
        BandType = 3
        GroupNo = 0
      end
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        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 = 794
        mmTop = 11642
        mmWidth = 21378
        BandType = 3
        GroupNo = 0
      end
      object ppDBText3: TppDBText
        UserName = 'DBText3'
        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 = 28310
        mmTop = 11642
        mmWidth = 16171
        BandType = 3
        GroupNo = 0
      end
      object ppDBText6: TppDBText
        UserName = 'DBText6'
        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 = 4572
        mmLeft = 153194
        mmTop = 11642
        mmWidth = 22606
        BandType = 3
        GroupNo = 0
      end
      object ppDBText7: TppDBText
        UserName = 'DBText7'
        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 = 4572
        mmLeft = 176742
        mmTop = 11642
        mmWidth = 20913
        BandType = 3
        GroupNo = 0
      end
      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 = 49742
        mmTop = 11642
        mmWidth = 95716
        BandType = 3
        GroupNo = 0
      end
      object ppDBText4: TppDBText
        UserName = 'DBText4'
        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 = 4572
        mmLeft = 112977
        mmTop = 11642
        mmWidth = 3683
        BandType = 3
        GroupNo = 0
      end
      object ppDBText14: TppDBText
        UserName = 'DBText14'
        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 = 4572
        mmLeft = 136261
        mmTop = 11642
        mmWidth = 13589
        BandType = 3
        GroupNo = 0
      end
    end
    object ppGroupFooterBand1: TppGroupFooterBand
      mmBottomOffset = 0
      mmHeight = 0
      mmPrintPosition = 0
    end
  end
  object daDataModule1: TdaDataModule
    object daADSQueryDataView1: TdaADSQueryDataView
      Report = ppReport1
      UserName = 'Query_Matters'
      Height = 211
      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 = 'Casenumber1'
          FieldName = 'CaseNumber1'
          FieldLength = 30
          DisplayWidth = 30
          Position = 1
          TableName = 'Matters'
        end
        object ppField3: TppField
          FieldAlias = 'Intakedate'
          FieldName = 'IntakeDate'
          FieldLength = 0
          DataType = dtDate
          DisplayWidth = 0
          Position = 2
          TableName = 'Matters'
        end
        object ppField4: TppField
          FieldAlias = 'Lawtype'
          FieldName = 'LawType'
          FieldLength = 4
          DisplayWidth = 4
          Position = 3
          TableName = 'Matters'
        end
        object ppField5: TppField
          FieldAlias = 'Attorney Lead'
          FieldName = 'Attorney_Lead'
          FieldLength = 10
          DisplayWidth = 10
          Position = 4
          TableName = 'Matters'
        end
        object ppField6: TppField
          FieldAlias = 'Casemanager'
          FieldName = 'CaseManager'
          FieldLength = 10
          DisplayWidth = 10
          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 = 'FullName'
          FieldName = 'FullName'
          FieldLength = 150
          IsDetail = True
          DisplayWidth = 150
          Position = 7
          TableName = 'Rolodex_2'
        end
        object ppField9: TppField
          FieldAlias = 'Subject'
          FieldName = 'Subject'
          FieldLength = 80
          IsDetail = True
          DisplayWidth = 80
          Position = 8
          TableName = 'Medical'
        end
        object ppField10: TppField
          FieldAlias = 'Fromdate'
          FieldName = 'FromDate'
          FieldLength = 20
          IsDetail = True
          DisplayWidth = 20
          Position = 9
          TableName = 'Medical'
        end
        object ppField11: TppField
          FieldAlias = 'Todate'
          FieldName = 'ToDate'
          FieldLength = 20
          IsDetail = True
          DisplayWidth = 20
          Position = 10
          TableName = 'Medical'
        end
        object ppField12: TppField
          FieldAlias = 'Requestdate'
          FieldName = 'RequestDate'
          FieldLength = 0
          IsDetail = True
          DataType = dtDate
          DisplayWidth = 0
          Position = 11
          TableName = 'Medical'
        end
        object ppField13: TppField
          FieldAlias = 'Receivedate'
          FieldName = 'ReceiveDate'
          FieldLength = 0
          IsDetail = True
          DataType = dtDate
          DisplayWidth = 0
          Position = 12
          TableName = 'Medical'
        end
        object ppField14: TppField
          FieldAlias = 'Bill'
          FieldName = 'Bill'
          FieldLength = 0
          IsDetail = True
          DataType = dtDouble
          DisplayWidth = 0
          Position = 13
          TableName = 'Medical'
        end
        object ppField15: TppField
          FieldAlias = 'Notes'
          FieldName = 'Notes'
          FieldLength = 1
          IsDetail = True
          Linkable = False
          DataType = dtMemo
          DisplayWidth = 1
          Position = 14
          Searchable = False
          Sortable = False
          TableName = 'Medical'
        end
        object ppField16: TppField
          FieldAlias = 'RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname)'
          FieldName = 'RTRIM_rolodex_lastname_RT'
          FieldLength = 20
          Linkable = False
          DisplayWidth = 20
          Position = 15
          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.CaseNumber1, '
          '       Matters.IntakeDate, Matters.LawType, '
          '       Matters.Attorney_Lead, '
          '       Matters.CaseManager, Rolodex.SS, '
          '       Rolodex_2.FullName, Medical.Subject, '
          '       Medical.FromDate, Medical.ToDate, '
          '       Medical.RequestDate, Medical.ReceiveDate, '
          '       Medical.Bill, Medical.Notes, '
          
            '       RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname)' +
            ' AS RTRIM_rolodex_lastname_RT'
          'FROM Matters Matters, Related Related'
          '     , Rolodex Rolodex, Medical Medical'
          '     , Rolodex Rolodex_2'
          'WHERE (Related.ID = Matters.MatterID) AND '
          '      (Rolodex.Ident = Related.Related) AND '
          '      (Medical.ID = Rolodex.Ident) AND '
          '      (Rolodex_2.Ident = Medical.Related) AND ('
          '      ( Related.Client = 1 )'
          '       AND ( Matters."Active" = 1 ))'
          'ORDER BY Matters.Title')
        SQLType = sqSQL2
        object daCalculation1: TdaCalculation
          ChildType = 8
          Alias = 'RTRIM(rolodex.lastname) + '#39', '#39' + RTRIM(rolodex.firstname)'
          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)'
        end
        object daCriteria1: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'True'
          object TdaField
            Alias = 'Client'
            DataType = dtBoolean
            DisplayWidth = 0
            FieldAlias = 'Client'
            FieldLength = 0
            FieldName = 'Client'
            SQLFieldName = 'Client'
            TableAlias = 'Rolodex related to Matters'
            TableName = 'Related'
            TableSQLAlias = 'Related'
          end
        end
        object daCriteria2: TdaCriteria
          ChildType = 7
          Level = 0
          Value = 'True'
          object TdaField
            Alias = 'Active'
            DataType = dtBoolean
            DisplayWidth = 0
            FieldAlias = 'Active'
            FieldLength = 0
            FieldName = 'Active'
            SQLFieldName = 'Active'
            TableAlias = 'Matters'
            TableName = 'Matters'
            TableSQLAlias = 'Matters'
          end
        end
        object daCriteria3: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLike
          object TdaField
            Alias = 'Firstname'
            AutoSearch = True
            DisplayWidth = 20
            FieldAlias = 'Firstname'
            FieldLength = 20
            FieldName = 'Firstname'
            SQLFieldName = 'Firstname'
            TableAlias = 'Rolodex'
            TableName = 'Rolodex'
            TableSQLAlias = 'Rolodex'
          end
        end
        object daCriteria4: TdaCriteria
          ChildType = 7
          Level = 0
          Operator = dacoLike
          object TdaField
            Alias = 'Lastname'
            AutoSearch = True
            DisplayWidth = 20
            FieldAlias = 'Lastname'
            FieldLength = 20
            FieldName = 'Lastname'
            SQLFieldName = 'Lastname'
            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 = 'Casenumber1'
          DisplayWidth = 30
          FieldAlias = 'Casenumber1'
          FieldLength = 30
          FieldName = 'CaseNumber1'
          SQLFieldName = 'CaseNumber1'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField3: TdaField
          Alias = 'Intakedate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Intakedate'
          FieldLength = 0
          FieldName = 'IntakeDate'
          SQLFieldName = 'IntakeDate'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField4: TdaField
          Alias = 'Lawtype'
          DisplayWidth = 4
          FieldAlias = 'Lawtype'
          FieldLength = 4
          FieldName = 'LawType'
          SQLFieldName = 'LawType'
          TableAlias = 'Matters'
          TableName = 'Matters'
          TableSQLAlias = 'Matters'
        end
        object daField5: 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 daField6: TdaField
          Alias = 'Casemanager'
          DisplayWidth = 10
          FieldAlias = 'Casemanager'
          FieldLength = 10
          FieldName = 'CaseManager'
          SQLFieldName = 'CaseManager'
          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 = 'FullName'
          DisplayWidth = 150
          FieldAlias = 'FullName'
          FieldLength = 150
          FieldName = 'FullName'
          IsDetail = True
          SQLFieldName = 'FullName'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          TableSQLAlias = 'Rolodex_2'
        end
        object daField9: TdaField
          Alias = 'Subject'
          DisplayWidth = 80
          FieldAlias = 'Subject'
          FieldLength = 80
          FieldName = 'Subject'
          IsDetail = True
          SQLFieldName = 'Subject'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField10: TdaField
          Alias = 'Fromdate'
          DisplayWidth = 20
          FieldAlias = 'Fromdate'
          FieldLength = 20
          FieldName = 'FromDate'
          IsDetail = True
          SQLFieldName = 'FromDate'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField11: TdaField
          Alias = 'Todate'
          DisplayWidth = 20
          FieldAlias = 'Todate'
          FieldLength = 20
          FieldName = 'ToDate'
          IsDetail = True
          SQLFieldName = 'ToDate'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField12: TdaField
          Alias = 'Requestdate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Requestdate'
          FieldLength = 0
          FieldName = 'RequestDate'
          IsDetail = True
          SQLFieldName = 'RequestDate'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField13: TdaField
          Alias = 'Receivedate'
          DataType = dtDate
          DisplayWidth = 0
          FieldAlias = 'Receivedate'
          FieldLength = 0
          FieldName = 'ReceiveDate'
          IsDetail = True
          SQLFieldName = 'ReceiveDate'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField14: TdaField
          Alias = 'Bill'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'Bill'
          FieldLength = 0
          FieldName = 'Bill'
          IsDetail = True
          SQLFieldName = 'Bill'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField15: TdaField
          Alias = 'Notes'
          DataType = dtMemo
          DisplayWidth = 1
          FieldAlias = 'Notes'
          FieldLength = 1
          FieldName = 'Notes'
          IsDetail = True
          Linkable = False
          Searchable = False
          Sortable = False
          SQLFieldName = 'Notes'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          TableSQLAlias = 'Medical'
        end
        object daField16: TdaField
          ChildType = 2
          Alias = 'Title'
          DisplayWidth = 100
          FieldAlias = 'Title'
          FieldLength = 100
          FieldName = 'Title'
          SQLFieldName = 'Title'
          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 = 'Rolodex related to Matters'
          SQLAlias = 'Related'
          TableAlias = 'Rolodex related to Matters'
          TableName = 'Related'
          object daTableJoin1: TdaTableJoin
            ChildType = 6
            object daField18: TdaField
              ChildType = 3
              Alias = 'Id'
              DisplayWidth = 10
              FieldAlias = 'Id'
              FieldLength = 10
              FieldName = 'ID'
              SQLFieldName = 'ID'
              TableAlias = 'Rolodex related to Matters'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
            object daField17: 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'
          SQLAlias = 'Rolodex'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          object daTableJoin2: TdaTableJoin
            ChildType = 6
            object daField20: TdaField
              ChildType = 3
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex'
            end
            object daField19: TdaField
              ChildType = 4
              Alias = 'Related'
              DisplayWidth = 10
              FieldAlias = 'Related'
              FieldLength = 10
              FieldName = 'Related'
              SQLFieldName = 'Related'
              TableAlias = 'Rolodex related to Matters'
              TableName = 'Related'
              TableSQLAlias = 'Related'
            end
          end
        end
        object daTable4: TdaTable
          ChildType = 5
          Alias = 'Medical History'
          SQLAlias = 'Medical'
          TableAlias = 'Medical History'
          TableName = 'Medical'
          object daTableJoin3: TdaTableJoin
            ChildType = 6
            object daField22: TdaField
              ChildType = 3
              Alias = 'Id'
              DisplayWidth = 10
              FieldAlias = 'Id'
              FieldLength = 10
              FieldName = 'ID'
              SQLFieldName = 'ID'
              TableAlias = 'Medical History'
              TableName = 'Medical'
              TableSQLAlias = 'Medical'
            end
            object daField21: TdaField
              ChildType = 4
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex'
            end
          end
        end
        object daTable5: TdaTable
          ChildType = 5
          Alias = 'Rolodex'
          SQLAlias = 'Rolodex_2'
          TableAlias = 'Rolodex'
          TableName = 'Rolodex'
          object daTableJoin4: TdaTableJoin
            ChildType = 6
            object daField24: TdaField
              ChildType = 3
              Alias = 'Ident'
              DisplayWidth = 10
              FieldAlias = 'Ident'
              FieldLength = 10
              FieldName = 'Ident'
              SQLFieldName = 'Ident'
              TableAlias = 'Rolodex'
              TableName = 'Rolodex'
              TableSQLAlias = 'Rolodex_2'
            end
            object daField23: TdaField
              ChildType = 4
              Alias = 'Related'
              DisplayWidth = 10
              FieldAlias = 'Related'
              FieldLength = 10
              FieldName = 'Related'
              SQLFieldName = 'Related'
              TableAlias = 'Medical History'
              TableName = 'Medical'
              TableSQLAlias = 'Medical'
            end
          end
        end
      end
    end
  end
end