Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730> in wotrack Copyright (c) 2006 <<Your Company Name here>> This template will create a report with one or more subreports, each having different data fields. MaximoSystemLibrary.maximoTheme Tivoli Maximo Subreport Template MaximoSystemLibrary.rptlibrary MaximoSystemLibrary Label Double-click to enter the report title. Report Title static string false text-box 1=1 Unformatted static string false text-box Unformatted true static string false text-box Unformatted true static string false text-box Unformatted 1 workorderid string 2 woclass string 3 wonum string 4 wodesc string 5 siteid string 6 schedstart date-time 7 schedfinish date-time 8 status string 9 targstartdate date-time 10 targcompdate date-time 11 parent string 12 actstart date-time 13 actfinish date-time 14 worktype string 15 reportdate date-time 16 reportedby string 17 wopriority string 18 glaccount string 19 vendor string 20 contract string 21 classstructureid string 22 failurecode string 23 problemcode string 24 lead string 25 supervisor string 26 persongroup string 27 owner string 28 ownergroup string 29 commodity string 30 commoditygroup string 31 onbehalfof string 32 jpnum string 33 jpdesc string 34 assetnum string 35 assetdesc string 36 location string 37 locdesc string 38 istask string 39 orgid string 40 cinum string 41 cidesc string 42 longdesc string workorderid woclass wonum wodesc siteid schedstart schedfinish status targstartdate targcompdate parent actstart actfinish worktype reportdate reportedby wopriority glaccount vendor contract classstructureid failurecode problemcode lead supervisor persongroup owner ownergroup commodity commoditygroup onbehalfof jpnum jpdesc assetnum assetdesc location locdesc istask orgid cinum cidesc longdesc 1 workorderid string 2 woclass string 3 wonum string 4 wodesc string 5 siteid string 6 schedstart date-time 7 schedfinish date-time 8 status string 9 targstartdate date-time 10 targcompdate date-time 11 parent string 12 actstart date-time 13 actfinish date-time 14 worktype string 15 reportdate date-time 16 reportedby string 17 wopriority string 18 glaccount string 19 vendor string 20 contract string 21 classstructureid string 22 failurecode string 23 problemcode string 24 lead string 25 supervisor string 26 persongroup string 27 owner string 28 ownergroup string 29 commodity string 30 commoditygroup string 31 onbehalfof string 32 jpnum string 33 jpdesc string 34 assetnum string 35 assetdesc string 36 location string 37 locdesc string 38 istask string 39 orgid string 40 cinum string 41 cidesc string 42 longdesc string maximoDataSource 1 assetnum string 2 location string 3 cinum string 4 assetdesc string 5 locdesc string 6 cidesc string 7 targetdesc string assetnum location cinum assetdesc locdesc cidesc targetdesc 1 assetnum string 2 location string 3 cinum string 4 assetdesc string 5 locdesc string 6 cidesc string 7 targetdesc string maximoDataSource 1 assetattrid string 2 alnvalue string 3 numvalue decimal 4 measureunitid string 5 description string 6 workorderspecid decimal assetattrid alnvalue numvalue measureunitid description workorderspecid 1 assetattrid string 2 alnvalue string 3 numvalue decimal 4 measureunitid string 5 description string 6 workorderspecid decimal maximoDataSource 1 taskid decimal 2 description string 3 status string 4 pointnum string 5 measurementvalue decimal 6 measuredate date-time 7 observation string 8 ldtext string taskid description status pointnum measurementvalue measuredate observation ldtext 1 taskid decimal 2 description string 3 status string 4 pointnum string 5 measurementvalue decimal 6 measuredate date-time 7 observation string 8 ldtext string maximoDataSource 1 laborcode string 2 craft string 3 skilllevel string 4 vendor string 5 contractnum string 6 quantity decimal 7 orgid string 8 laborhrs string 9 rate decimal 10 linecost decimal 11 istask decimal 12 taskid decimal 13 ratehaschanged integer laborcode craft skilllevel vendor contractnum quantity orgid laborhrs rate linecost istask taskid ratehaschanged 1 laborcode string 2 craft string 3 skilllevel string 4 vendor string 5 contractnum string 6 quantity decimal 7 orgid string 8 laborhrs string 9 rate decimal 10 linecost decimal 11 istask decimal 12 taskid decimal 13 ratehaschanged integer maximoDataSource 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 location string 6 itemqty decimal 7 unitcost decimal 8 linecost decimal taskid istask itemnum description location itemqty unitcost linecost 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 location string 6 itemqty decimal 7 unitcost decimal 8 linecost decimal maximoDataSource 1 taskid decimal 2 istask decimal 3 itemnum string 4 linetype string 5 description string 6 vendor string 7 itemqty decimal 8 unitcost decimal 9 linecost decimal taskid istask itemnum linetype description vendor itemqty unitcost linecost 1 taskid decimal 2 istask decimal 3 itemnum string 4 linetype string 5 description string 6 vendor string 7 itemqty decimal 8 unitcost decimal 9 linecost decimal maximoDataSource 1 taskid decimal 2 istask decimal 3 description string 4 itemqty decimal 5 hours string 6 rate decimal 7 linecost decimal 8 itemnum string taskid istask description itemqty hours rate linecost itemnum 1 taskid decimal 2 istask decimal 3 description string 4 itemqty decimal 5 hours string 6 rate decimal 7 linecost decimal 8 itemnum string maximoDataSource 1 taskid decimal 2 craft string 3 skilllevel string 4 laborcode string 5 vendor string 6 contractnum string 7 regularhrs string 8 premiumpayhours string 9 payrate decimal 10 premiumpayratetype string 11 linecost decimal 12 premiumpayrate decimal taskid craft skilllevel laborcode vendor contractnum regularhrs premiumpayhours payrate premiumpayratetype linecost premiumpayrate 1 taskid decimal 2 craft string 3 skilllevel string 4 laborcode string 5 vendor string 6 contractnum string 7 regularhrs string 8 premiumpayhours string 9 payrate decimal 10 premiumpayratetype string 11 linecost decimal 12 premiumpayrate decimal maximoDataSource 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 location string 6 quantity decimal 7 unitcost decimal 8 linecost decimal 9 wonum string 10 storeloc string taskid istask itemnum description location quantity unitcost linecost wonum storeloc 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 location string 6 quantity decimal 7 unitcost decimal 8 linecost decimal 9 wonum string 10 storeloc string maximoDataSource 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 vendor string 6 quantity string 7 unitcost decimal 8 linecost decimal 9 wonum string taskid istask itemnum description vendor quantity unitcost linecost wonum 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 vendor string 6 quantity string 7 unitcost decimal 8 linecost decimal 9 wonum string maximoDataSource 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 toolqty decimal 6 toolhrs string 7 toolrate decimal 8 linecost decimal taskid istask itemnum description toolqty toolhrs toolrate linecost 1 taskid decimal 2 istask decimal 3 itemnum string 4 description string 5 toolqty decimal 6 toolhrs string 7 toolrate decimal 8 linecost decimal maximoDataSource 1 relatedreckey string 2 description string 3 relatedrecclass string 4 status string 5 relatetype string relatedreckey description relatedrecclass status relatetype 1 relatedreckey string 2 description string 3 relatedrecclass string 4 status string 5 relatetype string maximoDataSource 1 relatedreckey string 2 ticketid string 3 description string 4 relatedrecclass string 5 status string 6 relatetype string relatedreckey ticketid description relatedrecclass status relatetype 1 relatedreckey string 2 ticketid string 3 description string 4 relatedrecclass string 5 status string 6 relatetype string maximoDataSource 1 createdate date-time 2 class string 3 createby string 4 description string 5 subject string 6 rowid decimal 7 ldtext string 8 recordkey string createdate class createby description subject rowid ldtext recordkey 1 createdate date-time 2 class string 3 createby string 4 description string 5 subject string 6 rowid decimal 7 ldtext string 8 recordkey string maximoDataSource 1 slanum string 2 description string 3 slatype string 4 status string 5 contactdate date-time 6 responsedate date-time 7 resolutiondate date-time slanum description slatype status contactdate responsedate resolutiondate 1 slanum string 2 description string 3 slatype string 4 status string 5 contactdate date-time 6 responsedate date-time 7 resolutiondate date-time maximoDataSource 100%mainDataSet wonum_desc if (rows[0]["wodesc"] == null || rows[0]["wodesc"] == "") rows[0]["wonum"] else rows[0]["wonum"] + ": " + rows[0]["wodesc"] string schedstart dataSetRow["schedstart"] date-time schedfinish dataSetRow["schedfinish"] date-time siteid dataSetRow["siteid"] string targstartdate dataSetRow["targstartdate"] date-time targcompdate dataSetRow["targcompdate"] date-time status dataSetRow["status"] string actstart dataSetRow["actstart"] date-time actfinish dataSetRow["actfinish"] date-time parent dataSetRow["parent"] string reportdate dataSetRow["reportdate"] date-time reportedby dataSetRow["reportedby"] string worktype dataSetRow["worktype"] string wopriority dataSetRow["wopriority"] string glaccount dataSetRow["glaccount"] string vendor dataSetRow["vendor"] string contract dataSetRow["contract"] string classstructureid dataSetRow["classstructureid"] string failurecode dataSetRow["failurecode"] string problemcode dataSetRow["problemcode"] string lead dataSetRow["lead"] string supervisor dataSetRow["supervisor"] string persongroup dataSetRow["persongroup"] string owner dataSetRow["owner"] string ownergroup dataSetRow["ownergroup"] string onbehalfof dataSetRow["onbehalfof"] string jpnum dataSetRow["jpnum"] string jpdesc dataSetRow["jpdesc"] string assetnum dataSetRow["assetnum"] string assetdesc dataSetRow["assetdesc"] string location dataSetRow["location"] string locdesc dataSetRow["locdesc"] string commodity dataSetRow["commodity"] string commoditygroup dataSetRow["commoditygroup"] string cinum dataSetRow["cinum"] string cidesc dataSetRow["cidesc"] string wodesc dataSetRow["wodesc"] string longdesc dataSetRow["longdesc"] string wonum dataSetRow["wonum"] string wosite_key row["wonum"]+row["siteid"] string woclass dataSetRow["woclass"] string 50 1.5in 1.5in 1.5in 1.5in 1.5in 2.5in

title 6 1 all params["appname"] != "RELEASE" Release Details all params["appname"] != "CHANGE" Change Details all params["appname"] != "ACTIVITY" Activity Details NewTemplateParameterDefinition all params["appname"] != "WOTRACK" Work Order Details all params["appname"] != "QUICKREP" Quick Reporting Details 0.08in 6 1 #000000 solid thin 0.06in 6 1

wositeGroup none asc row["wosite_key"] row["wonum"] + " - " + row["siteid"] true false always-excluding-last auto

reportheaderlabel left 6 1 wonum_desc reportheaderlabel left all (row["longdesc"] == null || row["longdesc"] == "") 6 1 longdesc

6 1 #000000 solid thin 2pt 2pt 100% 1in reportheaderlabel 1in 8in Asset: assetnum assetdesc Location: location locdesc CI: cinum cidesc 6 1 #000000 solid thin 2pt 2pt 100% 1in reportheaderlabel 2.2in reportheaderdata 0.2in reportheaderdata 1in 2.2in reportheaderdata 0.2in reportheaderdata 1in 2.2in reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Sched Start: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date schedstart 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Site: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px siteid reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Job Plan: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px jpnum #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Sched Finish: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date schedfinish 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Priority: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px wopriority reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Supervisor: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px supervisor #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Target Start: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date targstartdate 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Work Type: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px worktype reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Lead: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px lead #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Target Finish: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date targcompdate 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Status: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px status reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Vendor: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px vendor #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Actual Start: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date actstart 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Parent: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px parent reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Owner: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px owner #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Actual Finish: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date actfinish 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Failure Class: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px failurecode reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Owner Group: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px ownergroup #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Report Date: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Short Date Short Date reportdate 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Problem Code: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px problemcode reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Service: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px commodity #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Reported By: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px reportedby 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Service Group: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px commoditygroup #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin all params["appname"].value != "CHANGE" && params["appname"].value != "WOTRACK" On Behalf Of: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px all params["appname"].value != "CHANGE" && params["appname"].value != "WOTRACK" onbehalfof 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px GL Account: reportheaderdata #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px glaccount reportheaderdata 2px reportheaderlabel #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px Classification: #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin 2px classstructureid 6 1 2pt0pt100%multiAssetDataSet all (Total.count(row["assetnum"] != null) == 0) && (Total.count(row["location"] != null) == 0) && (Total.count(row["cinum"] != null) == 0) assetnum dataSetRow["assetnum"] string location dataSetRow["location"] string cinum dataSetRow["cinum"] string assetdesc dataSetRow["assetdesc"] string locdesc dataSetRow["locdesc"] string cidesc dataSetRow["cidesc"] string targetdesc dataSetRow["targetdesc"] string 50 1in 2in 1in 2in 1in 2in 1in

tableheaderrow 7 1 tableheaderlabel Multi Asset/Location/CI tabledetailslabel tabledetailslabelcell Asset tabledetailslabelcell Description tabledetailslabelcell Location tabledetailslabelcell Description tabledetailslabelcell CI tabledetailslabelcell Description tabledetailslabelcell Target Description

tabledetailsdatarow tabledetailsdatacell assetnum tabledetailsdatacell assetdesc tabledetailsdatacell location tabledetailsdatacell locdesc tabledetailsdatacell cinum tabledetailsdatacell cidesc tabledetailsdatacell targetdesc 2pt0pt100%specificationDataSet all Total.count(row["workorderspecid"] != null) == 0 assetattrid dataSetRow["assetattrid"] string alnvalue dataSetRow["alnvalue"] string numvalue dataSetRow["numvalue"] decimal measureunitid dataSetRow["measureunitid"] string description dataSetRow["description"] string workorderspecid dataSetRow["workorderspecid"] decimal 50 1in 3in 1.5in 1.5in 1.5in 1.5in

tableheaderrow 6 1 tableheaderlabel Specification tabledetailslabel tabledetailslabelcell Attribute tabledetailslabelcell Description tabledetailslabelcell ALN Value tabledetailslabelcell Numeric Value tabledetailslabelcell Unit of Measure tabledetailslabelcell

tabledetailsdatarow tabledetailsdatacell assetattrid tabledetailsdatacell description tabledetailsdatacell alnvalue tabledetailsdatacell numvalue tabledetailsdatacell measureunitid tabledetailsdatacell 2pt100%taskDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal description dataSetRow["description"] string status dataSetRow["status"] string pointnum dataSetRow["pointnum"] string measurementvalue dataSetRow["measurementvalue"] decimal measuredate dataSetRow["measuredate"] date-time observation dataSetRow["observation"] string ldtext ldtext dataSetRow["ldtext"] string 50 1in 3in 1in 1in 1in 2in 1in

tableheaderrow 7 1 tableheaderlabel Task IDs tabledetailslabel center tabledetailslabelcell Task ID tabledetailslabelcell Description tabledetailslabelcell Status tabledetailslabelcell Measurement Point tabledetailslabelcell Value tabledetailslabelcell Date tabledetailslabelcell Observations

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell left description tabledetailsdatacell status tabledetailsdatacell pointnum tabledetailsdatacell measurementvalue tabledetailsdatacell Short Date Short Date measuredate tabledetailsdatacell observation tabledetailsdatarow tabledetailsdatacell 5 1 tabledetailsdatacell left ldtext tabledetailsdatacell 2pt100%plannedLaborDataSet all Total.count(row["taskid"] != null) == 0 laborcode dataSetRow["laborcode"] string craft dataSetRow["craft"] string skilllevel dataSetRow["skilllevel"] string vendor dataSetRow["vendor"] string contractnum dataSetRow["contractnum"] string quantity dataSetRow["quantity"] decimal orgid dataSetRow["orgid"] string laborhrs dataSetRow["laborhrs"] string rate dataSetRow["rate"] decimal linecost dataSetRow["linecost"] decimal istask dataSetRow["istask"] decimal taskid dataSetRow["taskid"] decimal ratehaschanged dataSetRow["ratehaschanged"] integer data item Total.sum(row["linecost"]) decimal 50 1in 1in 1in 1in 1in 1in 1in 1in 1in 1in

tableheaderrow 10 1 tableheaderlabel Planned Labor tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Craft tabledetailslabelcell Skill Level tabledetailslabelcell Labor tabledetailslabelcell Vendor tabledetailslabelcell Contract tabledetailslabelcell Qty tabledetailslabelcell Hours tabledetailslabelcell Rate tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell craft tabledetailsdatacell skilllevel tabledetailsdatacell laborcode tabledetailsdatacell vendor tabledetailsdatacell contractnum tabledetailsdatacell quantity tabledetailsdatacell laborhrs tabledetailsdatacell Currency ###0.00 rate tabledetailsdatacell Currency ###0.00 linecost 2pt100%plannedMaterialsDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal itemnum dataSetRow["itemnum"] string description dataSetRow["description"] string location dataSetRow["location"] string itemqty dataSetRow["itemqty"] decimal unitcost dataSetRow["unitcost"] decimal linecost dataSetRow["linecost"] decimal data item Total.sum(row["linecost"]) integer 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Planned Materials tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Item tabledetailslabelcell Description tabledetailslabelcell Storeroom tabledetailslabelcell Qty tabledetailslabelcell Unit Cost tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell location tabledetailsdatacell itemqty tabledetailsdatacell Currency ###0.00 unitcost tabledetailsdatacell Currency ###0.00 linecost 2pt0.9583333333333334in10inplannedServicesDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal itemnum dataSetRow["itemnum"] string linetype dataSetRow["linetype"] string description dataSetRow["description"] string vendor dataSetRow["vendor"] string itemqty dataSetRow["itemqty"] decimal unitcost dataSetRow["unitcost"] decimal linecost dataSetRow["linecost"] decimal data item Total.sum(row["linecost"]) integer 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Planned Services tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Service Item tabledetailslabelcell Description tabledetailslabelcell Vendor tabledetailslabelcell Qty tabledetailslabelcell Unit Cost tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell vendor tabledetailsdatacell itemqty tabledetailsdatacell Currency ###0.00 unitcost tabledetailsdatacell Currency ###0.00 linecost 2pt100%plannedToolsDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal description dataSetRow["description"] string itemqty dataSetRow["itemqty"] decimal hours dataSetRow["hours"] string rate dataSetRow["rate"] decimal linecost dataSetRow["linecost"] decimal itemnum dataSetRow["itemnum"] string data item Total.sum(row["linecost"]) integer 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Planned Tools tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Tool tabledetailslabelcell Description tabledetailslabelcell Qty tabledetailslabelcell Hrs tabledetailslabelcell Rate tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell itemqty tabledetailsdatacell hours tabledetailsdatacell Currency ###0.00 rate tabledetailsdatacell Currency ###0.00 linecost 2pt100%actualLaborDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal craft dataSetRow["craft"] string skilllevel dataSetRow["skilllevel"] string laborcode dataSetRow["laborcode"] string vendor dataSetRow["vendor"] string contractnum dataSetRow["contractnum"] string regularhrs dataSetRow["regularhrs"] string premiumpayhours dataSetRow["premiumpayhours"] string payrate dataSetRow["payrate"] decimal premiumpayratetype dataSetRow["premiumpayratetype"] string linecost dataSetRow["linecost"] decimal premiumpayrate dataSetRow["premiumpayrate"] decimal data item Total.sum(row["linecost"]) integer 50 1in 0.7in 1in 1in 1in 1in 0.7in 1in 0.7in 0.9in 1in

tableheaderrow 11 1 tableheaderlabel Actual Labor tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Craft tabledetailslabelcell Skill Level tabledetailslabelcell Labor tabledetailslabelcell Vendor tabledetailslabelcell Contract Num tabledetailslabelcell Regular Hours tabledetailslabelcell Premium Hours tabledetailslabelcell Regular Rate tabledetailslabelcell Premium Rate tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell craft tabledetailsdatacell skilllevel tabledetailsdatacell laborcode tabledetailsdatacell vendor tabledetailsdatacell contractnum tabledetailsdatacell regularhrs tabledetailsdatacell premiumpayhours tabledetailsdatacell Currency ###0.00 payrate tabledetailsdatacell Currency ###0.00 premiumpayrate tabledetailsdatacell Currency ###0.00 linecost 2pt100%actualMaterialsDataSet all Total.count(row["wonum"] != null) == 0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal itemnum dataSetRow["itemnum"] string description dataSetRow["description"] string location dataSetRow["location"] string quantity dataSetRow["quantity"] decimal unitcost dataSetRow["unitcost"] decimal linecost dataSetRow["linecost"] decimal wonum dataSetRow["wonum"] string data item Total.sum(row["linecost"]) integer storeloc dataSetRow["storeloc"] string 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Actual Materials tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Item tabledetailslabelcell Description tabledetailslabelcell Storeroom tabledetailslabelcell Qty tabledetailslabelcell Unit Cost tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell storeloc tabledetailsdatacell quantity tabledetailsdatacell Currency ###0.00 unitcost tabledetailsdatacell Currency ###0.00 linecost 2pt100%actualServicesDataSet all row["actualservices_count"]==0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal itemnum dataSetRow["itemnum"] string description dataSetRow["description"] string vendor dataSetRow["vendor"] string quantity dataSetRow["quantity"] string unitcost dataSetRow["unitcost"] decimal linecost dataSetRow["linecost"] decimal wonum dataSetRow["wonum"] string data item Total.sum(row["linecost"]) integer actualservices_count integer COUNT Expression row["wonum"] 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Actual Services tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Service Item tabledetailslabelcell Description tabledetailslabelcell Vendor tabledetailslabelcell Qty tabledetailslabelcell Unit Cost tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell vendor tabledetailsdatacell quantity tabledetailsdatacell Currency ###0.00 unitcost tabledetailsdatacell Currency ###0.00 linecost 2pt100%actualToolsDataSet all Total.count(row["taskid"] != null) == 0 taskid dataSetRow["taskid"] decimal istask dataSetRow["istask"] decimal itemnum dataSetRow["itemnum"] string description dataSetRow["description"] string toolqty dataSetRow["toolqty"] decimal toolhrs dataSetRow["toolhrs"] string toolrate dataSetRow["toolrate"] decimal linecost dataSetRow["linecost"] decimal data item Total.sum(row["linecost"]) integer 50 1in 1in 4in 1in 1in 1in 1in

tableheaderrow 7 1 tableheaderlabel Actual Tools tabledetailslabel tabledetailslabelcell Task ID tabledetailslabelcell Tool tabledetailslabelcell Description tabledetailslabelcell Qty tabledetailslabelcell Hrs tabledetailslabelcell Rate tabledetailslabelcell Line Cost

tabledetailsdatarow tabledetailsdatacell all row["taskid"] == 0 taskid tabledetailsdatacell itemnum tabledetailsdatacell description tabledetailsdatacell toolqty tabledetailsdatacell toolhrs tabledetailsdatacell Currency ###0.00 toolrate tabledetailsdatacell Currency ###0.00 linecost 2pt100%relatedRecordsWODataSet all if((Total.count(row["relatedreckey"] != null) == 0) && (! thereAreTickets(row._outer["wonum"], this))) true; else false; relatedreckey dataSetRow["relatedreckey"] string description dataSetRow["description"] string relatedrecclass dataSetRow["relatedrecclass"] string status dataSetRow["status"] string relatetype dataSetRow["relatetype"] string 50 1.5in 4in 1.5in 1.5in 1.5in

tableheaderrow 5 1 tableheaderlabel Related Records tabledetailslabel all Total.count(row["relatedreckey"] != null) == 0 tabledetailslabelcell WO tabledetailslabelcell Description tabledetailslabelcell Class tabledetailslabelcell Status tabledetailslabelcell Relationship

tabledetailsdatarow all Total.count(row["relatedreckey"] != null) == 0 tabledetailsdatacell relatedreckey tabledetailsdatacell description tabledetailsdatacell relatedrecclass tabledetailsdatacell status tabledetailsdatacell relatetype 0pt100%relatedRecordsTicketDataSet all Total.count(row["ticketid"] != null) == 0 relatedreckey dataSetRow["relatedreckey"] string ticketid dataSetRow["ticketid"] string description dataSetRow["description"] string relatedrecclass dataSetRow["relatedrecclass"] string status dataSetRow["status"] string relatetype dataSetRow["relatetype"] string 50 1.5in 4in 1.5in 1.5in 1.5in

tabledetailslabel tabledetailslabelcell Ticket tabledetailslabelcell Description tabledetailslabelcell Class tabledetailslabelcell Status tabledetailslabelcell Relationship

tabledetailsdatarow tabledetailsdatacell ticketid tabledetailsdatacell description tabledetailsdatacell relatedrecclass tabledetailsdatacell status tabledetailsdatacell relatetype 2pt0pt100%workLogDataSet all Total.count(row["recordkey"] != null) == 0 createdate dataSetRow["createdate"] date-time class dataSetRow["class"] string createby dataSetRow["createby"] string description dataSetRow["description"] string subject dataSetRow["subject"] string rowid dataSetRow["rowid"] decimal ldtext dataSetRow["ldtext"] string recordkey dataSetRow["recordkey"] string 50 1.5in 1in 1in 1in 3in 2.5in

tableheaderrow 6 1 tableheaderlabel Log tabledetailslabel tabledetailslabelcell Date tabledetailslabelcell Class tabledetailslabelcell Created By tabledetailslabelcell Subject tabledetailslabelcell Description tabledetailslabelcell Long Description

tabledetailsdatarow tabledetailsdatacell Short Date Short Date createdate tabledetailsdatacell class tabledetailsdatacell createby tabledetailsdatacell subject tabledetailsdatacell description tabledetailsdatacell ldtext 2ptautoauto100%slaDataSet all Total.count(row["slanum"] != null) == 0 slanum dataSetRow["slanum"] string description dataSetRow["description"] string slatype dataSetRow["slatype"] string status dataSetRow["status"] string contactdate dataSetRow["contactdate"] date-time responsedate dataSetRow["responsedate"] date-time resolutiondate dataSetRow["resolutiondate"] date-time 50 1.5in 2in 1in 1in 1.5in 1.5in 1.5in

tableheaderrow 7 1 tableheaderlabel SLA tabledetailslabel tabledetailslabelcell SLA tabledetailslabelcell Description tabledetailslabelcell Type tabledetailslabelcell Status tabledetailslabelcell Contact Date tabledetailslabelcell Response Date tabledetailslabelcell Resolution Date

tabledetailsdatarow tabledetailsdatacell slanum tabledetailsdatacell description tabledetailsdatacell slatype tabledetailsdatacell status tabledetailsdatacell Short Date Short Date contactdate tabledetailsdatacell Short Date Short Date responsedate tabledetailsdatacell Short Date Short Date resolutiondate