Maximo Doclinks within BIRT Report

VHSteve · January 24, 2014

Is is possible to create a report that embeds doclinks within it? What I would like is to create a report which has work order details at the top, then doclink pictures shown below it (scaled down to fit one page). My company has a requirement to show a start and complete picture for each completed work order. Maximo users can easily see this information, but we need a report so that non-Maximo users can also see this information. If I can produce a report to show this, the user can run it from Maximo, export to a PDF and email to customers the work order details and completion details. Thanks.

wwilliams · January 27, 2014

First you'll have to add the doclink and docinfo tables to your sql something like the following;sqlText = "select wonum, urlname from workorder, doclinks, docinfo where workorderid = doclinks.ownerid and doclinks.document = docinfo.document and workorder.wonum = then insert an image control, Palette -> IMAGE, choose URI Then enter the following; "file:///" + row["urlname"]

VHSteve · January 28, 2014

<blockquote class="ipsBlockquote" data-author="wwilliams" data-cid="125315" data-time="1390848755"><div>First you'll have to add the doclink and docinfo tables to your sql something like the following;sqlText = "select wonum, urlname from workorder, doclinks, docinfo where workorderid = doclinks.ownerid and doclinks.document = docinfo.document and workorder.wonum = then insert an image control, Palette -> IMAGE, choose URI Then enter the following; "file:///" + row["urlname"]</div></blockquote> Thank you that has worked a treat. Just need to tweak the layout slightly. Do you know if it is possible to force a maximum size for the visible photo? It worked well with small demo pictures, but some real life photos could be 5 megapixels or larger.

juans · August 23, 2016

This is a old question but I'll answer it so that others can get an answer.
 
In Birt it's possible to scale images proportionally according to width or height. Unfortunately I have not found a working way to proportionally size a portrait image into same constrictions as a landscape picture. I've tried to script it, but adjusting by height then failed. I've resolved to set Proportional Scale and only scale on width, though in most cases scaling on height would be more suitable.

raj21 · December 4, 2022

Can some one please guide , how we can insert actual image on work order details BIRT report in Maximo from Doclink?

davidsimmons · May 31

Can some one please guide , how we can insert actual image on work order details BIRT report in Maximo from Doclink?

juanweiss · June 10

Have the same question with you.

Maximo Doclinks within BIRT Report

Comments

Categories