THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Oct 27, 2020

Implementing Drill-through in a BIRT report

More often than not, we may be working with a report which lacks all the necessary details about a particular Work Order or asset. In this instance, we need to access Maximo and retrieve the relevant record to obtain the information we are after. Wouldn’t it be so much simpler if we could retrieve this information within the BIRT report itself? That is exactly what this blog is going to show you! If a report is missing information, a Drill-through in your BIRT report needs to be implemented so that when you click the record in a BIRT list report, you are swiftly directed to a detail report.

How to implement a Drill-through from a list report to a detail report:

  1. Open the report for which you need to introduce a Drill-through in BIRT
  2. In the layout, right click on the relevant field to jump to the detail report and choose ‘Properties’. In this example below I am using the wonum field to jump to the woprint.rptdesign report.
  3. ~ Right click on chosen field and select ‘Properties’

  4. Select the option ‘Hyperlink’ and choose ‘Drill-through’ along with the necessary parameters as shown below
  5. ~ Choose Drill-through ~

  6. Your Drill-through is now set. You should be able to navigate to the detail report from the list report by clicking on Workorder

~ List report ~

~ Detail report displayed after clicking on the workorder number from the list report ~

Navigating back to the list report can be tricky if you set the Drill-through to show target report in same frame. Setting it to a new window is our solution here.

~ Set target report in a new window ~

If you need assistance with implementing a Drill-through in your BIRT report, or have any inquiries regarding the contents of this blog; please contact BPD Zenith.

Deepa Thomas

Deepa Thomas

Deepa is a Graduate consultant at BPD Zenith. Before shifting her focus onto Maximo, Deepa worked with IBM Mainframe systems in India. She is now an integral part of the ANZ Support team and enjoys solving day to day issues faced by clients. When not exploring and tinkering with Maximo she loves doodling, painting and exploring art.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Meet the Team – Niru Ojha

Meet the Team – Niru Ojha

1. What is your position at BPD Zenith? I am the Financial Controller. My day to day responsibilities include getting up to date with all financial activities. 2. What led you to choose this career path? I love working with numbers, reconciling, and solving problems...

Single Sign On (SSO) in Maximo

Single Sign On (SSO) in Maximo

As our work environments become more and more digitized, end users express a greater need to access software systems quickly and efficiently. Single Sign On (SSO) has been introduced to reduce the complexity for end users by enabling them to log in to multiple...

Meet the Team – Saravanaperumal Sankaranarayanan

Meet the Team – Saravanaperumal Sankaranarayanan

1. What is your position at BPD Zenith? I am the Principal Consultant at BPD Zenith ANZ and my day to day responsibilities include helping the Sales team with proposals, implementing, and upgrading Maximo for the BPD clients and providing guidance on how we can...

BPD Zenith are proud ReliabilityWeb.com Marketplace Partners

BPD Zenith are proud ReliabilityWeb.com Marketplace Partners

This month, BPD Zenith became proud members of the ReliabilityWeb.com Marketplace Program. ReliabilityWeb.com is the first port of call for all thing’s reliability! And they’re heavyweights on social media. You’ve probably came across Terrence, Maura or any of the...

Maximo Inspection Forms extension for Procurement

Maximo Inspection Forms extension for Procurement

Since the release of Maximo Work Centers, Inspection Forms have gained popularity in the work management circles, however, this powerful tool seems to be under-utilized for Maximo’s purchasing module. The below is an attempt to harness the potential for procurement. A...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Listen to your assets!

Most companies are aware of waste in their preventative maintenance efforts, but aren’t quite sure how to eliminate it.