Maximo Open Forum

 View Only

Related Content

  • 1.  Birt Report Issue

    Posted 08-05-2022 10:56
      |   view attached
    Hi All,
    I am developing a Birt report  Here if you see in output ShortQty is getting calculated as ShortQty-Quantity Required.
    I am not able to understand why as i calculated the difference in sql only but when i am trying to display in crosstab its doing calculation again,
    I have attached the .txt file. Please rename to .rptdesign while opening


    #Reporting

    ------------------------------
    Sahil Dutta
    xyz
    ------------------------------

    Attachment(s)

    txt
    test - Copy.txt   132 KB 1 version


  • 2.  RE: Birt Report Issue

    Posted 08-15-2022 15:26
    Sahil,
    It is performing a calculation when you run a report as you have the expression set to "dataSetRow["curbal"]-dataSetRow["itemcnt"]".  This tells the report to perform a calculation.  If you don't want the report to perform a calculation you must enter a new value in the receipts data set for ShortQty.  Also you should change the type of the items in the data set to Integer, Decimal, or Float when numbers, not String.  itemcnt, curbal, minlevel, and poqty are numbers.

    ------------------------------
    James Robb
    NASA
    ------------------------------



Newest Episode
Ep. 2 | Adding a QR Code to a BIRT Report

Watch Steven Shull walk through how to add a QR code to a BIRT report and make Maximo reporting more scannable, connected, and useful in the field.

Watch on YouTube Listen on Spotify
MORE by Naviam Episode 2 cover
Watch Episode 2
Also available: Ep. 1 | IBM Maximo Application Suite 9.2
Ep. 1 YouTube Ep. 1 Spotify Browse all episodes →