ReportName = Demo Variables ReportGroup = Maintenance object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.WorkOrders NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Demo Variables' 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 Variables' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Demo Variables.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 = False PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True ShowAutoSearchDialog = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.04' mmColumnWidth = 0 DataPipelineName = 'WorkOrders' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 37571 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Work Order List By Category With Variable Calcs' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 1058 mmWidth = 116713 BandType = 1 end object ppDBText8: TppDBText UserName = 'DBText8' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 159565 mmTop = 1058 mmWidth = 41783 BandType = 1 end object ppLabel12: TppLabel UserName = 'Params' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'CompletedDate: 9/28/2000- 9/28/2006' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 7938 mmWidth = 54737 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 demonstrates the use of logic based var' + 'iables to calculated the number of work orders completed and sch' + 'eduled.\par'#13#10'Click on the vRunning component which is a variable' + ' compontent. Right click on vRunning and then left click on Cal' + 'culations.\par'#13#10'You will see the logic used to keep a running to' + 'tal of Days. To view the logic used to calculated the total ope' + 'n and completed\par'#13#10'work orders, right click on Variable1 at th' + 'e bottom of the report and then left click on Calculations. The' + ' logic uses the Rapid\par'#13#10'Applicaiton Pascal (RAP) language. T' + 'o learn more, see the help and tech bulletins at the website.\f1' + '\par'#13#10'}'#13#10 mmHeight = 19315 mmLeft = 35983 mmTop = 14817 mmWidth = 163248 BandType = 1 mmBottomOffset = 0 mmOverFlowOffset = 0 mmStopPosition = 0 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 7673 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 1852 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3683 mmLeft = 3704 mmTop = 1323 mmWidth = 10837 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Unit Name' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 15346 mmTop = 1323 mmWidth = 41275 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Employee' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 57679 mmTop = 1323 mmWidth = 29104 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Company' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 87577 mmTop = 1323 mmWidth = 32544 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Scheduled' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 122767 mmTop = 1323 mmWidth = 13758 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Completed' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 3704 mmLeft = 141023 mmTop = 1323 mmWidth = 14023 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Days' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 167482 mmTop = 1323 mmWidth = 6615 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Running Total' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 3683 mmLeft = 177536 mmTop = 1323 mmWidth = 19473 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 Border.Weight = 1.000000000000000000 DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 3704 mmTop = 529 mmWidth = 9525 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'UnitName' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 15346 mmTop = 529 mmWidth = 41010 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'Employee' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 57679 mmTop = 529 mmWidth = 29104 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'Company' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 88371 mmTop = 265 mmWidth = 32544 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'ScheduledDate' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 123031 mmTop = 265 mmWidth = 19315 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'CompletedDate' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = 'mm/dd/yyyy' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3175 mmLeft = 141817 mmTop = 265 mmWidth = 19579 BandType = 4 end object ppDBText10: TppDBText UserName = 'DBText10' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'DATEDIFF_day_WoMaster_Sch' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3260 mmLeft = 163851 mmTop = 265 mmWidth = 10245 BandType = 4 end object ppVariable3: TppVariable UserName = 'vRunning' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False BlankWhenZero = False CalcOrder = 0 DataType = dtDouble DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3260 mmLeft = 185209 mmTop = 265 mmWidth = 11896 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4487 mmLeft = 1323 mmTop = 1323 mmWidth = 17187 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4487 mmLeft = 184680 mmTop = 1323 mmWidth = 17187 BandType = 8 end end object ppSummaryBand1: TppSummaryBand PrintHeight = phDynamic mmBottomOffset = 0 mmHeight = 31221 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'Numbered' DataPipeline = daADOQueryDataView1.WorkOrders DisplayFormat = '#####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'WorkOrders' mmHeight = 3725 mmLeft = 29590 mmTop = 15875 mmWidth = 23326 BandType = 7 end object ppVariable1: TppVariable UserName = 'Variable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 BlankWhenZero = False CalcOrder = 0 Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 40217 mmTop = 6879 mmWidth = 12700 BandType = 7 end object ppVariable2: TppVariable UserName = 'Variable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 BlankWhenZero = False CalcOrder = 1 Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3704 mmLeft = 40217 mmTop = 11113 mmWidth = 12700 BandType = 7 end object ppLabel10: TppLabel UserName = 'Label10' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Summary Info:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 4233 mmTop = 2117 mmWidth = 19177 BandType = 7 end object ppLabel11: TppLabel UserName = 'Label11' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Open Work Orders' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3704 mmLeft = 5821 mmTop = 6879 mmWidth = 24342 BandType = 7 end object ppLabel13: TppLabel UserName = 'Label12' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Completed Work Orders' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 5556 mmTop = 11113 mmWidth = 31369 BandType = 7 end object ppLabel14: TppLabel UserName = 'Label13' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 Caption = 'Total Work Orders' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 5556 mmTop = 15875 mmWidth = 24130 BandType = 7 end object ppLabel15: TppLabel UserName = 'Label14' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total Days Between:' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 6350 mmTop = 23283 mmWidth = 26670 BandType = 7 end object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'DATEDIFF_day_WoMaster_Sch' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3704 mmLeft = 33867 mmTop = 23283 mmWidth = 17198 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'WOCategoryID' DataPipeline = daADOQueryDataView1.WorkOrders KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'WorkOrders' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 5821 mmPrintPosition = 0 object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Border.Weight = 1.000000000000000000 DataField = 'WOCategoryID' DataPipeline = daADOQueryDataView1.WorkOrders Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'WorkOrders' mmHeight = 3725 mmLeft = 1323 mmTop = 1852 mmWidth = 20151 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object raCodeModule1: TraCodeModule ProgramStream = { 01060F5472614576656E7448616E646C65720B50726F6772616D4E616D65060F 5661726961626C65314F6E43616C630B50726F6772616D54797065070B747450 726F63656475726506536F7572636506E470726F636564757265205661726961 626C65314F6E43616C63287661722056616C75653A2056617269616E74293B0D 0A626567696E0D0A0D0A0D0A2020696620576F726B4F72646572735B27436F6D 706C6574656444617465275D3D30207468656E0D0A2020202020205661726961 626C65312E4173496E7465676572203A3D5661726961626C65312E4173496E74 656765722B310D0A2020656C73650D0A2020095661726961626C65322E417349 6E7465676572203A3D5661726961626C65322E4173496E74656765722B313B0D 0A202020202020202020200D0A0D0A656E643B0D0A0D436F6D706F6E656E744E 616D6506095661726961626C6531094576656E744E616D6506064F6E43616C63 074576656E74494402210001060F5472614576656E7448616E646C65720B5072 6F6772616D4E616D65060E7652756E6E696E674F6E43616C630B50726F677261 6D54797065070B747450726F63656475726506536F75726365068170726F6365 64757265207652756E6E696E674F6E43616C63287661722056616C75653A2056 617269616E74293B0D0A626567696E0D0A0D0A20207652756E6E696E672E4173 446F75626C65203A3D207652756E6E696E672E4173446F75626C652B576F726B 4F72646572735B274461746544696666275D0D0A0D0A656E643B0D0A0D436F6D 706F6E656E744E616D6506087652756E6E696E67094576656E744E616D650606 4F6E43616C63074576656E74494402210000} end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_WorkOrders' Height = 277 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 200 AutoSearchTabOrder = 0 object WorkOrders: TppChildDBPipeline AutoCreateFields = False UserName = 'WorkOrders' object ppField1: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 0 Position = 0 TableName = 'WoMaster' end object ppField2: TppField FieldAlias = 'UnitName' FieldName = 'UnitName' FieldLength = 80 DisplayWidth = 80 Position = 1 TableName = 'WoMaster' end object ppField3: TppField FieldAlias = 'Employee' FieldName = 'Employee' FieldLength = 35 DisplayWidth = 35 Position = 2 TableName = 'WoMaster' end object ppField4: TppField FieldAlias = 'Company' FieldName = 'Company' FieldLength = 50 DisplayWidth = 50 Position = 3 TableName = 'WoMaster' end object ppField5: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 4 TableName = 'WoMaster' end object ppField6: TppField FieldAlias = 'ScheduledDate' FieldName = 'ScheduledDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 5 TableName = 'WoMaster' end object ppField7: TppField FieldAlias = 'CompletedDate' FieldName = 'CompletedDate' FieldLength = 0 DataType = dtDateTime DisplayWidth = 0 Position = 6 TableName = 'WoMaster' end object ppField8: TppField FieldAlias = 'WOCategoryID' FieldName = 'WOCategoryID' FieldLength = 25 DisplayWidth = 25 Position = 7 TableName = 'WoMaster' end object ppField9: TppField FieldAlias = 'DateDiff' FieldName = 'DATEDIFF_day_WoMaster_Sch' FieldLength = 0 Linkable = False DataType = dtInteger DisplayWidth = 0 Position = 8 TableName = 'WoMaster' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'WorkOrders' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT WoMaster.Numbered, WoMaster.UnitName, ' ' WoMaster.Employee, WoMaster.Company, ' ' WoMaster.Site, WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate, ' ' WoMaster.WOCategoryID, ' ' DATEDIFF(day, WoMaster.ScheduledDate, WoMaster.CompletedD' + 'ate) DATEDIFF_day_WoMaster_Sch' 'FROM WoMaster WoMaster' 'WHERE ' ' ( WoMaster.CompletedDate BETWEEN CONVERT(DATETIME,'#39'2000-09' + '-28 00:00:00'#39',120) AND CONVERT(DATETIME,'#39'2006-09-28 23:59:59'#39',12' + '0) )' 'ORDER BY WoMaster.WOCategoryID, ' ' WoMaster.Numbered, ' ' WoMaster.ScheduledDate, ' ' WoMaster.CompletedDate') SQLType = sqSQL2 object daCalculation1: TdaCalculation Tag = 32 ChildType = 8 Alias = 'DateDiff' DataType = dtInteger DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' Linkable = False SQLFieldName = 'DATEDIFF_day_WoMaster_Sch' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' CalcType = dacaExpression Expression = 'DATEDIFF(day, WoMaster.ScheduledDate, WoMaster.CompletedDate) ' end object TdaCriteria ChildType = 7 Level = 0 Operator = dacoBetween Value = '"9/28/2000 12:00:00 AM"," 9/28/2006 11:59:59 PM"' object TdaField Alias = 'CompletedDate' AutoSearch = True DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object TdaNumericValue Value = 36797.000000000000000000 end object TdaNumericValue Value = 38988.999988425920000000 end end object daField1: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField2: TdaField Alias = 'UnitName' DisplayWidth = 80 FieldAlias = 'UnitName' FieldLength = 80 FieldName = 'UnitName' SQLFieldName = 'UnitName' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField3: TdaField Alias = 'Employee' DisplayWidth = 35 FieldAlias = 'Employee' FieldLength = 35 FieldName = 'Employee' SQLFieldName = 'Employee' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField4: TdaField Alias = 'Company' DisplayWidth = 50 FieldAlias = 'Company' FieldLength = 50 FieldName = 'Company' SQLFieldName = 'Company' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField5: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField6: TdaField Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField7: TdaField Alias = 'CompletedDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'CompletedDate' FieldLength = 0 FieldName = 'CompletedDate' SQLFieldName = 'CompletedDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField8: TdaField Alias = 'WOCategoryID' DisplayWidth = 25 FieldAlias = 'WOCategoryID' FieldLength = 25 FieldName = 'WOCategoryID' SQLFieldName = 'WOCategoryID' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField9: TdaField ChildType = 2 Alias = 'WOCategoryID' DisplayWidth = 25 FieldAlias = 'WOCategoryID' FieldLength = 25 FieldName = 'WOCategoryID' SQLFieldName = 'WOCategoryID' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField10: TdaField ChildType = 2 Alias = 'Numbered' DataType = dtDouble DisplayWidth = 0 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField11: TdaField ChildType = 2 Alias = 'ScheduledDate' DataType = dtDateTime DisplayWidth = 0 FieldAlias = 'ScheduledDate' FieldLength = 0 FieldName = 'ScheduledDate' SQLFieldName = 'ScheduledDate' TableAlias = 'WoMaster' TableName = 'WoMaster' TableSQLAlias = 'WoMaster' end object daField12: 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 end end end object ppParameterList1: TppParameterList end end