Including YORN fields in a Maximo 7.1 BIRT report

ghm728

<p>I am trying to add a YORN field that we have added to the item table to the query in one of our existing BIRT reports for Maximo 7.1, but after I add it, no data is returned.  When I remove the new field from the report, I get data again.  In the database, the YORN field is defined as integer, so I defined it as Integer in the Output Columns of my report.  In the Fetch, I tried using the following functions:  getBooleanString(), getString(), getBoolean(), but nothing works.  I am not getting any error messages, so I do not know what is wrong.  I pulled the modified query from my report, and it works just fine in sqlserver.  Could someone please point me in the right direction as to what I'm doing wrong?</p><p> </p>

ghm728

<p>Solved my issue by downloading the report from the database.  The one in our reports library turned out to be the wrong version.  getBooleanString() was the right function for the fetch.</p>