Currency Conversion in SSRS

Hi all,

I am trying to replicate the ‘Inventory Purchase Order’ NAV report in Reporting services (using visual studio 2005). It appears to be showing the correct lines; however the ‘Amount on Order Inc. VAT’ field is showing the values in currency when they should be in LCY.

I understand that the NAV report runs through some logic to evaluate the value according to currency, but I don’t know how I can do this in reporting services?

You can use the currency factor in the purchase header