I have this custom SSRS report that works except one field. There is a simple formula that is LaborRate * ProdHours. The problem is I just can’t seem to get it to switch to a different currency if the customer is not in the US. I tried wrapping it in CurrencyID, but got an error. I know this is a lot easier than what I am making it. Anything to point me in the right direction would be appreciated.
Not sure what tables you are getting the data out of, but aren’t you going need to know the exchange rate at the time of the transaction or pull it from current exchange rate data as well as the currency code?
Well the other thing I was playing with was the Placeholder properties>Custom and trying to set that as the currency look.
As to your question, I would assume pull it from the current exchange rate.
Not necessarily. Not considering you current requirement, if for example you were wanting to currency related data from a PO or SO, there is the option to lock the rate, which tells the system to use the rate on that transaction rather than get the current rate.