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
------------------------------
Original Message:
Sent: 08-05-2022 10:50
From: Sahil Dutta
Subject: Birt Report Issue
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
------------------------------