ReportName = Units Work Order History ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Units PassSetting = psTwoPass PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Units Work Order History' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.SaveDeviceSettings = False 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 = 'Units Work Order History' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Units Work Order History.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True ArchiveFileName = '($MyDocuments)\ReportArchive.raf' DeviceType = 'Screen' DefaultFileDeviceType = 'PDF' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True EmailSettings.ShowCancelDialog = True LanguageID = 'Default' OnPreviewFormCreate = ppReport1PreviewFormCreate OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PDFSettings.EmbedFontOptions = [] PDFSettings.EncryptSettings.AllowCopy = True PDFSettings.EncryptSettings.AllowInteract = True PDFSettings.EncryptSettings.AllowModify = True PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.Enabled = False PDFSettings.FontEncoding = feAnsi PDFSettings.ImageCompressionLevel = 25 PreviewFormSettings.ZoomSetting = zs100Percent RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] SavePrinterSetup = True TextFileName = '($MyDocuments)\Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True TextSearchSettings.Visible = True XLSSettings.AppName = 'ReportBuilder' XLSSettings.Author = 'ReportBuilder' XLSSettings.Subject = 'Report' XLSSettings.Title = 'Report' Left = 218 Top = 155 Version = '14.06' mmColumnWidth = 0 DataPipelineName = 'Units' object ppTitleBand1: TppTitleBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 15346 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' AutoSize = False Caption = 'Units Work Order History' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 20 Font.Style = [fsBold, fsItalic] TextAlignment = taCentered Transparent = True mmHeight = 8213 mmLeft = 1323 mmTop = 1323 mmWidth = 200555 BandType = 1 LayerName = Foreground end object ppLabel11: TppLabel UserName = 'Params' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True mmHeight = 3260 mmLeft = 1323 mmTop = 11377 mmWidth = 635 BandType = 1 LayerName = Foreground end end object ppHeaderBand1: TppHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 7408 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 6085 mmWidth = 200555 BandType = 0 LayerName = Foreground end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Caption = 'Numbered' 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 = 18521 BandType = 0 LayerName = Foreground end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Caption = 'ScheduledDate' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 21167 mmTop = 1323 mmWidth = 26194 BandType = 0 LayerName = Foreground end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Caption = 'CompletedDate' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 48683 mmTop = 1323 mmWidth = 26723 BandType = 0 LayerName = Foreground end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 76729 mmTop = 1323 mmWidth = 17463 BandType = 0 LayerName = Foreground end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Caption = 'LaborCost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 95515 mmTop = 1323 mmWidth = 17992 BandType = 0 LayerName = Foreground end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Caption = 'PartsCost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 114829 mmTop = 1323 mmWidth = 16933 BandType = 0 LayerName = Foreground end object ppLabel8: TppLabel UserName = 'Label8' AutoSize = False Caption = 'OtherCost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 133086 mmTop = 1323 mmWidth = 17727 BandType = 0 LayerName = Foreground end object ppLabel9: TppLabel UserName = 'Label9' AutoSize = False Caption = 'TaxCost' 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 = 14817 BandType = 0 LayerName = Foreground end object ppLabel10: TppLabel UserName = 'Label10' AutoSize = False Caption = 'TotalCost' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 170392 mmTop = 1323 mmWidth = 16669 BandType = 0 LayerName = Foreground end end object ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 4498 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 1323 mmTop = 529 mmWidth = 18521 BandType = 4 LayerName = Foreground end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 21167 mmTop = 529 mmWidth = 26194 BandType = 4 LayerName = Foreground end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 48683 mmTop = 529 mmWidth = 26723 BandType = 4 LayerName = Foreground end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Employee' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 76729 mmTop = 529 mmWidth = 17463 BandType = 4 LayerName = Foreground end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 95515 mmTop = 529 mmWidth = 17992 BandType = 4 LayerName = Foreground end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 114829 mmTop = 529 mmWidth = 16933 BandType = 4 LayerName = Foreground end object ppDBText7: TppDBText UserName = 'DBText7' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 133086 mmTop = 529 mmWidth = 17727 BandType = 4 LayerName = Foreground end object ppDBText8: TppDBText UserName = 'DBText8' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 152136 mmTop = 529 mmWidth = 16933 BandType = 4 LayerName = Foreground end object ppDBText9: TppDBText UserName = 'DBText9' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 170392 mmTop = 529 mmWidth = 16933 BandType = 4 LayerName = Foreground end end object ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5027 mmWidth = 200555 BandType = 8 LayerName = Foreground end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' 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 = 27771 BandType = 8 LayerName = Foreground end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' 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 LayerName = Foreground end end object ppGroup1: TppGroup BreakName = 'Name' DataPipeline = daADOQueryDataView1.Units GroupFileSettings.NewFile = False GroupFileSettings.EmailFile = False KeepTogether = True OutlineSettings.CreateNode = True StartOnOddPage = False UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Units' NewFile = False object ppGroupHeaderBand1: TppGroupHeaderBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6615 mmPrintPosition = 0 object ppDBText10: TppDBText UserName = 'DBText10' DataField = 'Name' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Units' mmHeight = 4191 mmLeft = 1323 mmTop = 1852 mmWidth = 74083 BandType = 3 GroupNo = 0 LayerName = Foreground end object ppDBText11: TppDBText UserName = 'DBText11' DataField = 'Unit' DataPipeline = daADOQueryDataView1.Units Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 10 Font.Style = [fsBold] Transparent = True DataPipelineName = 'Units' mmHeight = 4191 mmLeft = 76729 mmTop = 1852 mmWidth = 25400 BandType = 3 GroupNo = 0 LayerName = Foreground end end object ppGroupFooterBand1: TppGroupFooterBand Background.Brush.Style = bsClear HideWhenOneDetail = False mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0 object ppLabel12: TppLabel UserName = 'Label11' Caption = 'Unit Totals' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3260 mmLeft = 77238 mmTop = 1852 mmWidth = 13250 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppLine3: TppLine UserName = 'Line3' Weight = 0.750000000000000000 mmHeight = 1323 mmLeft = 95515 mmTop = 529 mmWidth = 93663 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' DataField = 'LaborCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3260 mmLeft = 96309 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' DataField = 'PartsCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 114565 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' DataField = 'OtherCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 133615 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' DataField = 'TaxCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 151871 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 LayerName = Foreground end object ppDBCalc5: TppDBCalc UserName = 'DBCalc5' DataField = 'TotalCost' DataPipeline = daADOQueryDataView1.Units DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Units' mmHeight = 3175 mmLeft = 170127 mmTop = 1852 mmWidth = 17198 BandType = 5 GroupNo = 0 LayerName = Foreground end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Units' Height = 114 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 224 AutoSearchTabOrder = 0 object Units: TppChildDBPipeline AutoCreateFields = False UserName = 'Units' object ppField1: TppField FieldAlias = 'Unit' FieldName = 'Unit' FieldLength = 25 DisplayWidth = 10 Position = 0 TableName = 'Units' end object ppField2: TppField FieldAlias = 'Name' FieldName = 'Name' FieldLength = 80 DisplayWidth = 10 Position = 1 TableName = 'Units' end object ppField3: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 10 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 IsDetail = True DataType = dtDateTime DisplayWidth = 10 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 IsDetail = True DisplayWidth = 10 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'Downtime' FieldName = 'Downtime' FieldLength = 5 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 6 TableName = 'WoMaster' end object ppField8: TppField FieldAlias = 'PartsCost' FieldName = 'PartsCost' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 7 TableName = 'WoMaster' end object ppField9: TppField FieldAlias = 'OtherCost' FieldName = 'OtherCost' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 8 TableName = 'WoMaster' end object ppField10: TppField FieldAlias = 'LaborCost' FieldName = 'LaborCost' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 9 TableName = 'WoMaster' end object ppField11: TppField FieldAlias = 'TaxCost' FieldName = 'TaxCost' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 10 TableName = 'WoMaster' end object ppField12: TppField FieldAlias = 'TotalCost' FieldName = 'TotalCost' FieldLength = 2 IsDetail = True DataType = dtDouble DisplayWidth = 10 Position = 11 TableName = 'WoMaster' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Units' LinkColor = clMaroon LinkType = ltMagicSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Units.Unit, Units.Name, WoMaster.Numbered, ' ' WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate, WoMaster.Employee, ' ' WoMaster.Downtime, WoMaster.PartsCost, ' ' WoMaster.OtherCost, WoMaster.LaborCost, ' ' WoMaster.TaxCost, WoMaster.TotalCost' 'FROM Units Units INNER JOIN WoMaster WoMaster ON ' ' (WoMaster.Unit = Units.RecordNumber)' 'WHERE ('#39'c'#39' <> '#39'c'#39' )') SQLType = sqSQL2 object daField1: TdaField Alias = 'Unit' DisplayWidth = 10 FieldAlias = 'Unit' FieldLength = 25 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField2: TdaField Alias = 'Name' DisplayWidth = 10 FieldAlias = 'Name' FieldLength = 80 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField3: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' IsDetail = True SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' IsDetail = True SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' IsDetail = True SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'Employee' DisplayWidth = 10 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' IsDetail = True SQLFieldName = 'Employee' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'Downtime' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Downtime' FieldLength = 5 FieldName = 'Downtime' IsDetail = True SQLFieldName = 'Downtime' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField Alias = 'PartsCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'PartsCost' FieldLength = 2 FieldName = 'PartsCost' IsDetail = True SQLFieldName = 'PartsCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField9: TdaField Alias = 'OtherCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'OtherCost' FieldLength = 2 FieldName = 'OtherCost' IsDetail = True SQLFieldName = 'OtherCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField10: TdaField Alias = 'LaborCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'LaborCost' FieldLength = 2 FieldName = 'LaborCost' IsDetail = True SQLFieldName = 'LaborCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField Alias = 'TaxCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'TaxCost' FieldLength = 2 FieldName = 'TaxCost' IsDetail = True SQLFieldName = 'TaxCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField12: TdaField Alias = 'TotalCost' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'TotalCost' FieldLength = 2 FieldName = 'TotalCost' IsDetail = True SQLFieldName = 'TotalCost' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField13: TdaField ChildType = 2 Alias = 'Name' DisplayWidth = 10 FieldAlias = 'Name' FieldLength = 10 FieldName = 'Name' SQLFieldName = 'Name' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end object daField14: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 10 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daTable1: TdaTable ChildType = 5 Alias = 'Units' JoinType = dajtNone SQLAlias = 'Units' TableAlias = 'Units' TableName = 'Units' end object daTable2: TdaTable ChildType = 5 Alias = 'WoMaster' SQLAlias = 'WoMaster' TableAlias = 'WoMaster' TableName = 'WoMaster' object daTableJoin1: TdaTableJoin ChildType = 6 object daField16: TdaField ChildType = 3 Alias = 'Unit' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Unit' FieldLength = 10 FieldName = 'Unit' SQLFieldName = 'Unit' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField15: TdaField ChildType = 4 Alias = 'RecordNumber' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'RecordNumber' FieldLength = 10 FieldName = 'RecordNumber' SQLFieldName = 'RecordNumber' TableAlias = 'Units' TableName = 'Units' TableSQLAlias = 'Units' end end end end end end object ppDesignLayers1: TppDesignLayers object ppDesignLayer1: TppDesignLayer UserName = 'Foreground' LayerType = ltBanded Index = 0 end end object ppParameterList1: TppParameterList object ppParameter1: TppParameter AutoSearchSettings.LogicalPrefix = [] AutoSearchSettings.Mandatory = True DataType = dtInteger LookupSettings.DisplayType = dtNameOnly LookupSettings.SortOrder = soName Value = 5 UserName = 'Parameter1' end end end