Revised Maximo 76 Report Administration and Feature Guide | Maximo

This guide highlights on the Administration process of the Maximo BIRT reporting functionality.

It starts with an overview of the installation process, file and database structure, and then moves into reviews of scheduling, emailing and security. It concludes with detailed reviews of each of the Report Administration actions, along with property settings and cron tasks. Throughout the guide, best practice recommendations are highlighted.


http://www-01.ibm.com/support/docview.wss?uid=swg21696690

Child Dataset in BIRT using Scripted Data Source | IBM Maximo

developing complex reports for Maximo requires a number of data sets in Birt sometimes. And definately every second dataset is a subset/or dependent of Main dataset. therefore every child dataset takes a parameter as input from MainDataSet.

for example;
A PO data set,
and a POLINE dataset, poline dataset takes PONUM as InputParameter from PO.

1. create a Paramter in PolineDataSet "Edit DataSet"
PONUM, String, Input, NULL
2. In Layout tab, draw table, and in Table Data Binding

a Click on DataSet Parameter Binding (b)
b Click Edit (b)
c type/select row["ponum"]

3. In PoLineDataSet's Open event (4 things)
i data source provider
ii dataset open
iii set query
iv Query Parameters

3(i) SetQuery:
we need to append our where class in (iii) set query part

sqlText = "select * from PO where ponum = ?";

don't forget to comment this line in child dataset "where " + param["where"]

3(ii) Query Parameter:
name first paramater in this line

polineDataset.setQueryParamterValue(1,inputParams["ponum"]);

Maximo Safetyplan and associated Hazard n Precautions SQL | IBM Maximo

select
      sp.safetyplanid
      , sp.description
      , h.hazardid
      , h.description
      , p.precautionid
      , P.description
      , p.siteid
  from
      safetyplan sp
  join
      spworkasset spwa
      on sp.safetyplanid = spwa.safetyplanid
  join
      splexiconlink spll
      on spwa.spworkassetid = spll.spworkassetid

Import/Re-import a Modified BIRT Report | IBM Maximo

Goto > Administration > Report Administration
Filter desired report with attached Application (for example podetail.rptdesign, with PLUSGPO application)

1. Click to open that report

How to Hide Elements based on Condition in BIRT in 5 Steps - IBM Maximo