ReportName = Demo Report Joins List
ReportGroup = Maintenance
object ppReport1: TppReport
  AutoStop = False
  DataPipeline = daADOQueryDataView1.ReportJoins
  NoDataBehaviors = [ndBlankReport]
  PassSetting = psTwoPass
  PrinterSetup.BinName = 'Default'
  PrinterSetup.DocumentName = 'Demo Report Joins List'
  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
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = dpReports
  Template.DatabaseSettings.Name = 'Demo Report Joins List'
  Template.DatabaseSettings.NameField = 'ReportName'
  Template.DatabaseSettings.TemplateField = 'NewDef'
  Template.FileName = 'Demo Report Joins List.rtm'
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  AllowPrintToFile = True
  DeviceType = 'Screen'
  EmailSettings.ReportFormat = 'PDF'
  EmailSettings.Enabled = True
  EmailSettings.PreviewInEmailClient = False
  EmailSettings.ShowEmailDialog = True
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = False
  OutlineSettings.Visible = True
  PreviewFormSettings.ZoomSetting = zs100Percent
  SavePrinterSetup = True
  ShowAutoSearchDialog = True
  TextSearchSettings.DefaultString = '<FindText>'
  TextSearchSettings.Enabled = True
  Left = 218
  Top = 155
  Version = '10.04'
  mmColumnWidth = 203200
  DataPipelineName = 'ReportJoins'
  object ppTitleBand1: TppTitleBand
    mmBottomOffset = 0
    mmHeight = 19315
    mmPrintPosition = 0
    object ppLabel1: TppLabel
      UserName = 'Label1'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'ReportJoins'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 20
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 8202
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 37835
      BandType = 1
    end
    object ppRichText1: TppRichText
      UserName = 'RichText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'RichText1'
      RichText = 
        '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcha' +
        'rset0 MS Sans Serif;}{\f1\fnil MS Sans Serif;}}'#13#10'\viewkind4\uc1\' +
        'pard\f0\fs16 This report provides a break down of the tables and' +
        ' typical joins between tables.   While there may be other ways t' +
        'o join between tables, these are the typical ones used and the o' +
        'nes that Report Builder automatically recognizes as defined in t' +
        'he ReportJoins table.\f1\par'#13#10'}'#13#10
      mmHeight = 12965
      mmLeft = 55033
      mmTop = 4233
      mmWidth = 142082
      BandType = 1
      mmBottomOffset = 0
      mmOverFlowOffset = 0
      mmStopPosition = 0
    end
  end
  object ppHeaderBand1: TppHeaderBand
    mmBottomOffset = 0
    mmHeight = 8731
    mmPrintPosition = 0
    object ppShape1: TppShape
      UserName = 'Shape1'
      Brush.Color = 13434828
      mmHeight = 6615
      mmLeft = 0
      mmTop = 0
      mmWidth = 201348
      BandType = 0
    end
    object ppLine1: TppLine
      UserName = 'Line1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Pen.Color = clNavy
      Pen.Width = 2
      Weight = 1.500000000000000000
      mmHeight = 2646
      mmLeft = 794
      mmTop = 6085
      mmWidth = 200555
      BandType = 0
    end
    object ppLabel2: TppLabel
      UserName = 'Label2'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Table 1'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 48948
      BandType = 0
    end
    object ppLabel3: TppLabel
      UserName = 'Label3'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Table 1 Field'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 51594
      mmTop = 1323
      mmWidth = 48948
      BandType = 0
    end
    object ppLabel4: TppLabel
      UserName = 'Label4'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Table 2'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 101865
      mmTop = 1323
      mmWidth = 48948
      BandType = 0
    end
    object ppLabel5: TppLabel
      UserName = 'Label5'
      AutoSize = False
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Caption = 'Table 2 Field'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 11
      Font.Style = [fsBold, fsItalic]
      Transparent = True
      mmHeight = 4763
      mmLeft = 152136
      mmTop = 1323
      mmWidth = 48948
      BandType = 0
    end
  end
  object ppDetailBand1: TppDetailBand
    mmBottomOffset = 0
    mmHeight = 4233
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = 'DBText1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'TableName1'
      DataPipeline = daADOQueryDataView1.ReportJoins
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ReportJoins'
      mmHeight = 3260
      mmLeft = 1323
      mmTop = 445
      mmWidth = 48948
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = 'DBText2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FieldNames1'
      DataPipeline = daADOQueryDataView1.ReportJoins
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ReportJoins'
      mmHeight = 3260
      mmLeft = 51594
      mmTop = 445
      mmWidth = 48948
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = 'DBText3'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'TableName2'
      DataPipeline = daADOQueryDataView1.ReportJoins
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ReportJoins'
      mmHeight = 3260
      mmLeft = 101865
      mmTop = 445
      mmWidth = 48948
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = 'DBText4'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      DataField = 'FieldNames2'
      DataPipeline = daADOQueryDataView1.ReportJoins
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = 'ARIAL'
      Font.Size = 8
      Font.Style = []
      Transparent = True
      DataPipelineName = 'ReportJoins'
      mmHeight = 3260
      mmLeft = 152136
      mmTop = 445
      mmWidth = 48948
      BandType = 4
    end
  end
  object ppFooterBand1: TppFooterBand
    mmBottomOffset = 0
    mmHeight = 6350
    mmPrintPosition = 0
    object ppLine2: TppLine
      UserName = 'Line2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      Pen.Color = clGray
      Pen.Width = 2
      Weight = 1.500000000000000000
      mmHeight = 3969
      mmLeft = 1323
      mmTop = 5027
      mmWidth = 200555
      BandType = 8
    end
    object ppSystemVariable1: TppSystemVariable
      UserName = 'SystemVariable1'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      VarType = vtPrintDateTime
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      Transparent = True
      mmHeight = 3725
      mmLeft = 1323
      mmTop = 1323
      mmWidth = 27517
      BandType = 8
    end
    object ppSystemVariable2: TppSystemVariable
      UserName = 'SystemVariable2'
      Border.BorderPositions = []
      Border.Color = clBlack
      Border.Style = psSolid
      Border.Visible = False
      VarType = vtPageNoDesc
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Name = 'TIMES NEW ROMAN'
      Font.Size = 9
      Font.Style = []
      TextAlignment = taRightJustified
      Transparent = True
      mmHeight = 3725
      mmLeft = 193411
      mmTop = 1323
      mmWidth = 8594
      BandType = 8
    end
  end
  object daDataModule1: TdaDataModule
    object daADOQueryDataView1: TdaADOQueryDataView
      UserName = 'Query_ReportJoins'
      Height = 211
      Left = 10
      NameColumnWidth = 105
      SizeColumnWidth = 35
      SortMode = 0
      Top = 10
      TypeColumnWidth = 52
      Width = 200
      AutoSearchTabOrder = 0
      object ReportJoins: TppChildDBPipeline
        AutoCreateFields = False
        UserName = 'ReportJoins'
        object ppField1: TppField
          FieldAlias = 'TableName1'
          FieldName = 'TableName1'
          FieldLength = 50
          DisplayWidth = 50
          Position = 0
          TableName = 'ReportJoins'
        end
        object ppField2: TppField
          FieldAlias = 'FieldNames1'
          FieldName = 'FieldNames1'
          FieldLength = 50
          DisplayWidth = 50
          Position = 1
          TableName = 'ReportJoins'
        end
        object ppField3: TppField
          FieldAlias = 'TableName2'
          FieldName = 'TableName2'
          FieldLength = 50
          DisplayWidth = 50
          Position = 2
          TableName = 'ReportJoins'
        end
        object ppField4: TppField
          FieldAlias = 'FieldNames2'
          FieldName = 'FieldNames2'
          FieldLength = 50
          DisplayWidth = 50
          Position = 3
          TableName = 'ReportJoins'
        end
        object ppField5: TppField
          FieldAlias = 'JoinType'
          FieldName = 'JoinType'
          FieldLength = 50
          DisplayWidth = 50
          Position = 4
          TableName = 'ReportJoins'
        end
        object ppField6: TppField
          FieldAlias = 'Operators'
          FieldName = 'Operators'
          FieldLength = 50
          DisplayWidth = 50
          Position = 5
          TableName = 'ReportJoins'
        end
        object ppField7: TppField
          FieldAlias = 'RecordNumber'
          FieldName = 'RecordNumber'
          FieldLength = 0
          DataType = dtDouble
          DisplayWidth = 0
          Position = 6
          TableName = 'ReportJoins'
        end
      end
      object daSQL1: TdaSQL
        GuidCollationType = gcMSSQLServer
        DatabaseName = 'ADO1'
        DatabaseType = dtMSSQLServer
        DataPipelineName = 'ReportJoins'
        LinkColor = clMaroon
        MaxSQLFieldAliasLength = 25
        SQLText.Strings = (
          'SELECT ReportJoins.TableName1, '
          '       ReportJoins.FieldNames1, '
          '       ReportJoins.TableName2, '
          '       ReportJoins.FieldNames2, '
          '       ReportJoins.JoinType, '
          '       ReportJoins.Operators, '
          '       ReportJoins.RecordNumber'
          'FROM ReportJoins ReportJoins'
          'ORDER BY ReportJoins.TableName1, '
          '         ReportJoins.TableName2')
        SQLType = sqSQL2
        object daField1: TdaField
          Alias = 'TableName1'
          DisplayWidth = 50
          FieldAlias = 'TableName1'
          FieldLength = 50
          FieldName = 'TableName1'
          SQLFieldName = 'TableName1'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField2: TdaField
          Alias = 'FieldNames1'
          DisplayWidth = 50
          FieldAlias = 'FieldNames1'
          FieldLength = 50
          FieldName = 'FieldNames1'
          SQLFieldName = 'FieldNames1'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField3: TdaField
          Alias = 'TableName2'
          DisplayWidth = 50
          FieldAlias = 'TableName2'
          FieldLength = 50
          FieldName = 'TableName2'
          SQLFieldName = 'TableName2'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField4: TdaField
          Alias = 'FieldNames2'
          DisplayWidth = 50
          FieldAlias = 'FieldNames2'
          FieldLength = 50
          FieldName = 'FieldNames2'
          SQLFieldName = 'FieldNames2'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField5: TdaField
          Alias = 'JoinType'
          DisplayWidth = 50
          FieldAlias = 'JoinType'
          FieldLength = 50
          FieldName = 'JoinType'
          SQLFieldName = 'JoinType'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField6: TdaField
          Alias = 'Operators'
          DisplayWidth = 50
          FieldAlias = 'Operators'
          FieldLength = 50
          FieldName = 'Operators'
          SQLFieldName = 'Operators'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField7: TdaField
          Alias = 'RecordNumber'
          DataType = dtDouble
          DisplayWidth = 0
          FieldAlias = 'RecordNumber'
          FieldLength = 0
          FieldName = 'RecordNumber'
          SQLFieldName = 'RecordNumber'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField8: TdaField
          ChildType = 2
          Alias = 'TableName1'
          DisplayWidth = 50
          FieldAlias = 'TableName1'
          FieldLength = 50
          FieldName = 'TableName1'
          SQLFieldName = 'TableName1'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daField9: TdaField
          ChildType = 2
          Alias = 'TableName2'
          DisplayWidth = 50
          FieldAlias = 'TableName2'
          FieldLength = 50
          FieldName = 'TableName2'
          SQLFieldName = 'TableName2'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
          TableSQLAlias = 'ReportJoins'
        end
        object daTable1: TdaTable
          ChildType = 5
          Alias = 'ReportJoins'
          JoinType = dajtNone
          SQLAlias = 'ReportJoins'
          TableAlias = 'ReportJoins'
          TableName = 'ReportJoins'
        end
      end
    end
  end
  object ppParameterList1: TppParameterList
  end
end