Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build <2.3.2.v20090218-0730>inIBM 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.
09-19764@000This template will create a report having a single header with multiple rows of data.MaximoSystemLibrary.maximoThemeTivoli Maximo Portrait List TemplateltrMaximoSystemLibrary.rptlibraryMaximoSystemLibraryLabelDouble-click to enter the report title.staticstringfalsetext-box1=1Unformattedstaticstringfalsetext-boxUnformattedtruestaticstringfalsetext-boxUnformattedtruestaticstringfalsetext-boxUnformattedtruestaticstringsimplefalsetext-boxtruetrueUnformattedstaticdateTimesimpleDate From:falsetext-boxtrueUnformattedstaticdateTimesimpleDate To:falsetext-boxtrueUnformatted1ponumstring2descriptionstring3orderdatestringponumdescriptionorderdate1ponumstring2descriptionstring3orderdatestringmaximoDataSource= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]); }
else {
start_date = " and po.orderdate >= dateadd(month,datediff(month,1,getdate()) +0,0) "; }
if (params["enddate"].value) {
end_date = " and po.orderdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]); }
else {
end_date = " and po.orderdate < dateadd(month,datediff(month,1,getdate()) +1,0) "; }
// Add query to sqlText variable.
sqlText = "select po.ponum, po.description, po.orderdate from po"
// Include the Maximo where clause
+ " where " + params["where"]
+ start_date
+ end_date
;
maximoDataSet.setQuery(sqlText);]]>middlemiddlemiddlecenterleft