Maximo 7.5 Long Description print issues

Maximo v: 7.5
Birt: 2.32

See the below error. In using the new RTF format that Maximo 7.5 provides, my report now prints as the below. It doesn't look this way in Maximo's LD field, just when it prints. I'm sure it has to do with copying and pasting the info into the LD from a Microsoft product.

In any event, I have tried a couple of options and now hope that you will have some ideas.

I first tried entering a dynamicText field and then adding the field to that. I did nothing more than set the field. Perhaps there is a setting there or something?

Second, I tried a text field, then <VALUE-OF FORMAT="HTML" tags with the same result. Our ability to print work packages is pretty much dead in the water and any help you have would be greatly appreciated.

Find more posts tagged with

Comments

mwilliams

The only thing I can find to make the formatting correct is to use the dynamic text element. You're saying you already tried this. What is your output? Is it just the preview? Or PDF? I don't have Maximo to be able to test this.

wwilliams

Have you tried changing longDescDataSet.getHtmlString("ldtext") to just getString? in the Fetch method?

TheShadraq

Thanks for the replies. I ended using SQL to do the conversion. The RTF format, and being text, didn't allow for a straight "replace" or a straight "convert". I'm sure I could have built something in BIRT utilizing JavaScript, but I chose to do it through SQL. SHould anyone come across this I hope they find it useful. You may need to look at the database output and replace my characters with yours. But at least this is a start.

select CAST(replace(replace(replace(replace(replace(cast(ldtext as varchar(max)),'',''),'<font','<font'),'',''),'',' ') as TEXT) as ldtext

maximomax

Maximo for Beginners

Part 1

Details description is in the attached document.

jperras

I was having the same issue and wanted to provide a solution that is extremely simple for BIRT for maximo in the 7.5 and later formats. All you have to do is insert a dynamic text field and set it equal to the long description field that you pull into BIRT. This will allow any rich text formats to pull into your BIRT report (color, font etc...)