Maximo Open Forum

 View Only

 Creating report with the attached images

  • Integrations
  • Reporting
JAN VERELST's profile image
JAN VERELST posted 10-24-2023 00:23

Hello,

I am searching a way to create a report from a work order where we can see the attached images. The intention is that when a ticket is created about a damage case with photos and we create a work order from this, we can subsequently create a detailed BIRT report in which we can read the necessary information as well as the added photos of the ticket or work order and costs of the recovery.a damage case with photos and we create a work order from this, we can subsequently create a detailed BIRT report in which we can read the necessary information as well as the added photos of the ticket or work order and costs of the recovery.

Regards,

Jan

Prashant Sharma's profile image
Prashant Sharma posted 10-24-2023 08:01

When you do attachment, there is a checkbox as highlighted below should be checked which allows reports to read the attachment.

In your report, Print attachment settings should be configured.

vineet joshi's profile image
vineet joshi posted 10-26-2023 08:08

Along with what Prashant has suggested, you can add images in the Grid and have a separate dataset for it. you can write sql logic for which picture to choose based on your business requirement. Images will be one per icon.

The benefit I see from this is, picture will support text beside it rather than printed at the end of the report.

Danielle Shaw's profile image
Danielle Shaw posted 10-27-2023 09:42

If you need to embed directly into the report rather than print all the images at the end of the report, you first have to add an image element. If you are using secured attachments, you will need to set choose "Dynamic image" in the "Select Image from" option list, create an onRender script for the image that makes a REST API GET request to the appropriate object structure (one with the table you're interested in and also has DOCLINKS as a child table) to pull in the base64 data of the image, and set this.data to that base64 data within the onRender script, which BIRT will then render as an image that is viewable in all formats (HTML, PDF, etc.) I figure out the call in Postman first to make sure it brings back an image.

If you are not using secured attachments you should be able to pull the image source URL from the DOCINFO table into a Data Set element, choose "URI" from the "Select Image from" menu, and set that to the field from the data set that holds the URL.

Related Content