The above report displays all prices for an item, but i need the report to be displayed only active price(latest price).
Thanks in advance.
Have a look at \Reports\InventPriceOverview, it already has the logic for the same. \Reports\InventPriceOverview\Methods\addActiveFilter