Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730> in report_opt IBM Confidential OCO Source Materials 5724-M19 (C) COPYRIGHT IBM CORP. 2006 The source code for this program is not published or otherwise divested of its trade secrets, irrespective of what has been deposited with the U.S. Copyright Office. This template will create a report with one or more groups, each having identical data fields. MaximoSystemLibrary.maximoTheme Tivoli Maximo Grouped Template ltr 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 reportname string 2 reportfolder string 3 appname string 4 description string 5 problemcode integer 6 problemdescr string 7 found integer reportname reportfolder appname description problemcode problemdescr found 1 reportname string 2 reportfolder string 3 appname string 4 description string 5 problemcode integer 6 problemdescr string 7 found integer maximoDataSource >> on reportEntry: " + reportEntry.reportfolder + "\\" + reportEntry.reportname ); } bugCounter++; case 1: // 1- Null Date Parameter row["problemcode"] = bugCounter; row["found"] = 0; bug1DS = MXReportDataSetProvider.create(this.getDataSource().getName(), "bug1DS"); bug1DS.open(); sqlText = "select reportlookup.parametername " + " from reportlookup " + " where reportlookup.appname = ? " + " and reportlookup.reportname = ? " + " and reportlookup.lookupname is null " + " and upper(reportlookup.parametername) like '%DATE%'"; bug1DS.setQuery(sqlText); bug1DS.setQueryParameterValue(1, reportEntry.appname); bug1DS.setQueryParameterValue(2, reportEntry.reportname); if (bug1DS.fetch()) { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+mainDataSet.getName() + "] >>> on report: " + reportEntry.reportfolder + "\\" + reportEntry.reportname + " app: " + reportEntry.appname + " at check: " + bugCounter); scriptLogger.debug("["+ bug1DS.getName() + "] >>> bug1DS param: " + bug1DS.getString("parametername") ); } //row["problemdescr"] = reportContext.getMessage("nulldateparameter", reportContext.getLocale()); row["problemdescr"] = "Null Date Parameter"; row["found"] = 1; } bug1DS.close(); bugCounter++; break; case 2: // 2 - Block comment row["problemcode"] = bugCounter; row["found"] = 0; var blockcomment = /(\/\*[\x00-\x7F\s\x20-\x7E]*?\*\/)/; if(blockcomment.test(reportEntry.design)) { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+mainDataSet.getName() + "] >>> on report: " + reportEntry.reportfolder + "\\" + reportEntry.reportname + " app: " + reportEntry.appname + " at check: " + bugCounter); scriptLogger.debug("["+mainDataSet.getName() + "] >>> blockcomment found: " + reportEntry.design.match(blockcomment)); } //row["problemdescr"] = reportContext.getMessage("commentformatting", reportContext.getLocale()); row["problemdescr"] = "Comment Formatting"; row["found"] = 1; } bugCounter++; break; case 3: // 3 - ANY datatype row["problemcode"] = bugCounter; row["found"] = 0; var anydatatype = /any<\/property>/i; if(anydatatype.test(reportEntry.design)) { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+mainDataSet.getName() + "] >>> on report: " + reportEntry.reportfolder + "\\" + reportEntry.reportname + " app: " + reportEntry.appname + " at check: " + bugCounter); scriptLogger.debug("["+mainDataSet.getName() + "] >>> anydatatype "); } //row["problemdescr"] = reportContext.getMessage("anydatatype", reportContext.getLocale()); row["problemdescr"] = "Any Data Type"; row["found"] = 1; } bugCounter++; break; case 4: // 4 - Null Comparison row["problemcode"] = bugCounter; row["found"] = 0; var nulljavacheck = /(params\["[^"]*"\]\s*(?:!=|==)\s*null)/i; var toSkip = ["forwardsched_changes.rptdesign", "leased_asset_due.rptdesign", "inventory_abc.rptdesign", "inventory_transactions.rptdesign", "inventory_transactions_receipt_transfers.rptdesign", "kit.rptdesign", "inventory_transactions.rptdesign", "inventory_transactions_receipt_transfers.rptdesign", "service_target_compliance.rptdesign", "login_history.rptdesign", "user_session.rptdesign"]; var skip = false; for(var i=0; i < toSkip.length; i++) { if(BirtComp.equalTo(BirtStr.toLower(reportEntry.reportname), BirtStr.toLower(toSkip[i]))) { skip=true; break; } } if(!skip) { if(nulljavacheck.test(reportEntry.design)) { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+mainDataSet.getName() + "] >>> on report: " + reportEntry.reportfolder + "\\" + reportEntry.reportname + " app: " + reportEntry.appname + " at check: " + bugCounter); scriptLogger.debug("["+mainDataSet.getName() + "] >>> nulljavacheck found: " + reportEntry.design.match(nulljavacheck)); } //row["problemdescr"] = reportContext.getMessage("nullcomparison", reportContext.getLocale()); row["problemdescr"] = "Null Comparison"; row["found"] = 1; } } else { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+ mainDataSet.getName() + "] >>> Skipped on nulljavacheck : " + reportEntry.reportname); } } bugCounter++; break; case 5: // 5 - Date Time Calendar Formatting row["problemcode"] = bugCounter; row["found"] = 0; //the following reports must not be checked against the use of the methods var toSkip = ["oeekpi_by_asset.rptdesign","oeekpi_by_location.rptdesign","inventory_eoq_tbl.rptdesign", "projected_pm_labor.rptdesign","amdaily_format.rptdesign","ammonthly_format.rptdesign","wo_matlbal.rptdesign"]; var skip = false; for(var i=0; i < toSkip.length; i++) { if(BirtComp.equalTo(BirtStr.toLower(reportEntry.reportname), BirtStr.toLower(toSkip[i]))) { skip=true; break; } } if(!skip) { var datetimespam = /(DateTimeSpan[\s\S](?:addDate|addTime|subDate|subTime)\()/; if(datetimespam.test(reportEntry.design)) { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+mainDataSet.getName() + "] >>> on report: " + reportEntry.reportfolder + "\\" + reportEntry.reportname + " app: " + reportEntry.appname + " at check: " + bugCounter); scriptLogger.debug("["+mainDataSet.getName() + "] >>> datetimespam: " + reportEntry.design.match(datetimespam)); } //row["problemdescr"] = reportContext.getMessage("datetimecalendarformating", reportContext.getLocale()); row["problemdescr"] = "Date Time Calendar Formatting"; row["found"] = 1; } } else { if (scriptLogger.isDebugEnabled()) { scriptLogger.debug("["+ mainDataSet.getName() + "] >>> Skipped on datetimespam : " + reportEntry.reportname); } } bugCounter++; break; } row["reportname"] = reportEntry.reportname; row["reportfolder"] = reportEntry.reportfolder; row["appname"] = reportEntry.appname; row["description"] = reportEntry.description; return (true);]]> 100%mainDataSet reportname dataSetRow["reportname"] string reportfolder dataSetRow["reportfolder"] string appname dataSetRow["appname"] string description dataSetRow["description"] string problemcode dataSetRow["problemcode"] integer problemdescr dataSetRow["problemdescr"] string found dataSetRow["found"] integer 50 eq row["found"] 1 2.5in 2.5in 0.8in 0.8in 2in 1.4in

title 6 1 #000000 solid thin 3pt NewTemplateParameterDefinition1 Report Upgrade Listing

reportfolderGroup none asc row["reportfolder"] row["reportfolder"] true false auto auto auto

0.08in 6 1 tableheaderrow 6 1 100% 1in tableheaderlabel 9in tableheaderdata Report Folder: reportfolder 0.08in 6 1 tabledetailslabel tabledetailslabelcell Report File Name tabledetailslabelcell Description tabledetailslabelcell Application tabledetailslabelcell Category Number tabledetailslabelcell Category Description tabledetailslabelcell

tabledetailsdatarow tabledetailsdatacell reportname tabledetailsdatacell description tabledetailsdatacell appname tabledetailsdatacell problemcode tabledetailsdatacell problemdescr tabledetailsdatacell