IBM Maximo : Calling a report from a push button in Maximo

Idea here is to launch a report from a push button on any screen. In this way business can run a specific report by clicking a button in the screen itself.

1.       Find the report which you want to run (ex: woprint.rptdesign) and hit the database to find the report number and execute below query

select reportnum,reportname,appname from report where reportname='woprint.rptdesign' and APPNAME='WOTRACK';

2.       From Report Library file (REPLIBRARY) and search for reportnum="351" , note the id related to it (highlighted)

id="reportd351"

label="Request Page" mboname="WORKORDER" reportnum="351" reporttype="BIRT" width="550">

3.       Navigate to application designer, search for WOTRACK and a new button with details like

Event : reportd351 and save it

4.       From Work Order Tracking application , you can see a Print Report button, when you click it shows report page like below

And on Submit, it generates the report.

----------------------------------------------------------------------------
 All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo .. Update database using Birt report

Sometimes database has to be updated after each report run showing that a report  has been run(example like last run date).

In Birt simple way to achieve this is to execute update query in the 'beforeClose' method of dataset.

var myTxn = MXReportTxnProvider.create("maximoDataSource");


var updateSqlText = new String();

updateSqlText = " update poline set enterdate=SYSDATE  where enterdate is null'";

var apextractStmt = myTxn.createStatement();
apextractStmt.setQuery(updateSqlText);

myTxn.save();

---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.