I've created the report using query but i need to add a field of Price for corresponding itemid..
How and where can i write the display method for that item..
Thanks in advance..
In reply to Kranthi:
In reply to Ilamvazhudhi Sri Ranjani:
the price field isn't fetching the value, Kranthi
display Price getprice()
select Price from Item
where item.itemid == inventItemPrice_1.ItemId
&& item.InventDimId == inventItemPrice_1.InventDimId && item.CostingType==inventItemPrice_1.CostingType && item.PriceType==inventItemPrice_1.PriceType; //use other fields to get the related price