Reports to meet European Union encryption software requirements

As a requirement of our Ireland Export License, we are required to run quarterly shipment reports on encryption product distributed out of the Ireland facility.  The value must be reported in Euro’s and the value is only the sum of the software and licenses sold, in other words, the value is a total of only certain line items not the sales order main line total.

We have developed a saved search with the Amount and the Amount (Foreign Currency). We use an Intercompany Drop Ship process to deliver software to Customers outside of our Inventory location.

I think I would need to convert my Amount (Foreign Currency) to Euro in the report but with Amount (Foreign Currency) representing multiple currencies, how do I set my criteria to select the correct exchange rate for conversion to EURO?