Hi Folks
In Management Reporter on a column format I know I can;
1. Add a currency display filter that will allow me to show different currencies side by side. This works very well when I want to take company A and print it in say Canadian and American dollars.
2. Add a reporting unit filter to restrict a column to a certain level of a reporting tree, say Company A and Company B.
My challenge today is that I need to combine these concepts and display company A in American dollars, and company B in Canadian dollars, on the same column definition.
What happens however is that the company that is set as the company name in the report, or if @Any is selected for the company name the company set as the default company for MR, drives the currency of the report. So if my US company is selected, the US displays properly, the CAD displays as a currency conversion rather than originating, or if I select the CAD company the opposite happens, US translates and CAD displays properly.
Can MR do this? If so how?
thanks!
