MR - Display multiple currencies on different rows?

(2) Share

Report

Posted on by Community Member

I have a client on GP 2013 using Management Reporter.

She would like to build a report and display the same Income Statement accounts on two lines - one in USD and one in CAD. Her functional currency is CAD, but the default currency for the report is USD.

She wants the same row definitions and the same columns. She only needs this one row to display in CAD, and everything else on the report to in USD.

She has tried creating a filter for the attribute Currency ID in the row modifier cell, but this did not give her what she needed.

Does anyone have any suggestions on how to accomplish this or if it is even possible?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Valerie,

is the client using the DataMart or the Legacy connector ? Could you post an example of the row & columns definitions to see what the client tried to achieve so far ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Beat.

Thanks for responding.

She is using a DataMart.

Here is where she tried the Attribute filter, that did not work:

Detail of the financial dimensions:

Column definitions:

Was this reply helpful? Yes No