Report need to display only active price

pastedimage1509165708389v2.png

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