ReportName = Demo Sub Report - Drill Down ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Units NoDataBehaviors = [ndBlankReport] PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Demo Sub Report - Drill Down' 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 Sub Report - Drill Down' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Demo Sub Report - Drill Down.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 = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.04' mmColumnWidth = 0 DataPipelineName = 'Units' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 40217 mmPrintPosition = 0 object ppLabel8: TppLabel UserName = 'Label8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit Name' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsBold, fsUnderline] Transparent = True mmHeight = 3344 mmLeft = 2117 mmTop = 35983 mmWidth = 13081 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Type' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsBold, fsUnderline] Transparent = True mmHeight = 3344 mmLeft = 48683 mmTop = 35719 mmWidth = 6181 BandType = 0 end object ppLabel10: TppLabel UserName = 'Label10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsBold, fsUnderline] Transparent = True mmHeight = 3344 mmLeft = 67733 mmTop = 35983 mmWidth = 9991 BandType = 0 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 demonstrates the use of a subreport wit' + 'h Drill Down capability. To view the drill\par'#13#10'down while prev' + 'iewing the report, click on the Unit name. To set the subreport' + ' to a drill \par'#13#10'down, right click on the subreport and left cl' + 'ick on Drill Down. In the Data tab, note the second query\par'#13#10 + 'and the link to the first query. In the Design tab, the subrepo' + 'rt is based on the second query\par'#13#10'of work orders. To view th' + 'e subreport design, click on the subreport tab at the bottom of ' + 'the\par'#13#10'Design page. A report can have multiple subreports. T' + 'he work orders are a good example \par'#13#10'of subreports.\f1\par'#13#10'}' + #13#10 mmHeight = 25665 mmLeft = 76200 mmTop = 8996 mmWidth = 127265 BandType = 0 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 end object ppLabel11: TppLabel UserName = 'Label11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Unit List With Work Orders Subreport Drill Down' Font.Charset = DEFAULT_CHARSET Font.Color = clBlue Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [fsBold] Transparent = True mmHeight = 4995 mmLeft = 2117 mmTop = 2117 mmWidth = 92837 BandType = 0 end end object ppDetailBand1: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 15081 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Name' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3440 mmLeft = 2117 mmTop = 2117 mmWidth = 46831 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Type' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3440 mmLeft = 48683 mmTop = 2117 mmWidth = 17198 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Unit' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3440 mmLeft = 67733 mmTop = 2117 mmWidth = 17198 BandType = 4 end object ppSubReport3: TppSubReport UserName = 'SubReport3' DrillDownComponent = ppDBText1 ExpandAll = False NewPrintJob = False OutlineSettings.CreateNode = True TraverseAllData = False DataPipelineName = 'WoMaster' mmHeight = 5027 mmLeft = 0 mmTop = 6350 mmWidth = 203200 BandType = 4 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 object ppChildReport3: TppChildReport AutoStop = False DataPipeline = daADOQueryDataView2.WoMaster PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Demo Sub Report - Drill Down' 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.DataPipeline = dpReports Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.SaveTo = stDatabase Template.Format = ftASCII Version = '10.04' mmColumnWidth = 0 DataPipelineName = 'WoMaster' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 4233 mmPrintPosition = 0 object ppLabel2: TppLabel UserName = 'Label2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Work Orders' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3440 mmLeft = 12700 mmTop = 0 mmWidth = 14817 BandType = 1 end object ppLabel3: TppLabel UserName = 'Label3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] Transparent = True mmHeight = 3440 mmLeft = 44450 mmTop = 0 mmWidth = 9260 BandType = 1 end object ppLabel4: TppLabel UserName = 'Label4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Completed' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] TextAlignment = taCentered Transparent = True mmHeight = 3440 mmLeft = 65881 mmTop = 0 mmWidth = 12435 BandType = 1 end object ppLabel5: TppLabel UserName = 'Label5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Labor Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] TextAlignment = taRightJustified Transparent = True mmHeight = 3440 mmLeft = 87313 mmTop = 0 mmWidth = 12700 BandType = 1 end object ppLabel6: TppLabel UserName = 'Label6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Parts Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] Transparent = True mmHeight = 3440 mmLeft = 107950 mmTop = 0 mmWidth = 11642 BandType = 1 end object ppLabel7: TppLabel UserName = 'Label7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total Cost' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [fsUnderline] Transparent = True mmHeight = 3440 mmLeft = 125942 mmTop = 0 mmWidth = 11906 BandType = 1 end end object ppDetailBand2: TppDetailBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3344 mmLeft = 44450 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompletedDate' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taCentered Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3429 mmLeft = 63500 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 84138 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'PartsCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 103717 mmTop = 265 mmWidth = 17198 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'TotalCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 120650 mmTop = 265 mmWidth = 17198 BandType = 4 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 7938 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 3969 mmLeft = 43392 mmTop = 0 mmWidth = 95250 BandType = 7 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView2.WoMaster Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 33867 mmTop = 2117 mmWidth = 15081 BandType = 7 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'LaborCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 84138 mmTop = 2117 mmWidth = 17198 BandType = 7 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'PartsCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 103717 mmTop = 2117 mmWidth = 17198 BandType = 7 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'TotalCost' DataPipeline = daADOQueryDataView2.WoMaster DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WoMaster' mmHeight = 3440 mmLeft = 120650 mmTop = 2117 mmWidth = 17198 BandType = 7 end end end end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Units' Height = 143 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object Units: TppChildDBPipeline AutoCreateFields = False UserName = 'Units' object ppField1: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 80 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'Type' FieldName = 'Type' FieldLength = 25 DisplayWidth = 25 Position = 2 TableName = 'Units' end object ppField4: TppField FieldAlias = 'RecordNumber' FieldName = 'RecordNumber' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 3 TableName = 'Units' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Units' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Units.Name, Units.Unit, Units.Type, ' ' Units.RecordNumber' 'FROM Units Units' 'ORDER BY Units.Name') SQLType = sqSQL2 object daField1: TdaField Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'Unit' DisplayWidth = 25 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' SQLFieldName = 'Type' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField4: TdaField Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField5: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 80 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daTable1: TdaTable ChildType = 5 Alias = 'Units' JoinType = dajtNone SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' end end end object daADOQueryDataView2: TdaADOQueryDataView UserName = 'Query_WoMaster' Height = 194 Left = 260 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 MasterDataViewUserName = 'Query_Units' object WoMaster: TppChildDBPipeline AutoCreateFields = False UserName = 'WoMaster' MasterDataPipelineName = 'Units' object ppField1: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 0 TableName = 'WoMaster' end object ppField2: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 1 TableName = 'WoMaster' end object ppField3: TppField FieldAlias = 'LaborHours' FieldName = 'LaborHours' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'LaborCost' FieldName = 'LaborCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'PartsCost' FieldName = 'PartsCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'TotalCost' FieldName = 'TotalCost' FieldLength = 2 DataType = dtDouble DisplayWidth = 2 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 6 TableName = 'WoMaster' end object TppMasterFieldLink MasterFieldName = 'Name' GuidCollationType = gcMSSQLServer DetailFieldName = 'Name' DetailSortOrder = soAscending end object TppMasterFieldLink MasterFieldName = 'RecordNumber' GuidCollationType = gcMSSQLServer DetailFieldName = 'Unit' DetailSortOrder = soAscending end end object daSQL2: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WoMaster' LinkColor = clNavy MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.Unit, WoMaster.CompletedDate, ' ' WoMaster.LaborHours, WoMaster.LaborCost, ' ' WoMaster.PartsCost, WoMaster.TotalCost, ' ' WoMaster.Numbered' 'FROM WoMaster WoMaster' 'WHERE ' ' ( WoMaster.CompletedDate > CONVERT(DATETIME,'#39'1899-12-30'#39',1' + '20) )' 'ORDER BY WoMaster.CompletedDate') SQLType = sqSQL2 object daCriteria1: TdaCriteria ChildType = 7 Level = 0 Operator = dacoGreaterThan Value = '0' object TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object TdaNumericValue end end object daField1: TdaField Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField3: TdaField Alias = 'LaborHours' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'LaborHours' FieldLength = 5 FieldName = 'LaborHours' SQLFieldName = 'LaborHours' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'LaborCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'LaborCost' FieldLength = 2 FieldName = 'LaborCost' SQLFieldName = 'LaborCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'PartsCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'PartsCost' FieldLength = 2 FieldName = 'PartsCost' SQLFieldName = 'PartsCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'TotalCost' DataType = dtDouble DisplayWidth = 2 FieldAlias = 'TotalCost' FieldLength = 2 FieldName = 'TotalCost' SQLFieldName = 'TotalCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField ChildType = 2 Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daTable1: TdaTable ChildType = 5 Alias = 'WoMaster' JoinType = dajtNone SQLAlias = 'WoMaster' TableAlias = 'WoMaster' TableName = 'WoMaster' end object TdaSQLLink ChildType = 9 object daField9: TdaField ChildType = 10 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'RecordNumber' FieldLength = 0 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField10: TdaField ChildType = 11 Alias = 'Unit' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Unit' FieldLength = 0 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end end end end end object ppParameterList1: TppParameterList end end