SSRS Multi-currency report DYNAMICS 365

Copper Contributor



Don't know exactly how to put my problem but I'll try to hope you understand :)


So my gol is to create a kind of Aging report. 

The report currently looks like this:




That's pretty much what I need.


 I have an sub-total amount for the invoices (highlighted in yellow) and an intermediate amount for the client (highlighted in green) and total for the report (highlighted in blue).


What I want to do is separate the table (if possible automatically) by invoice currency. So I get multiple tables according to the currencies and a separate total for each table according to the currencies (Instead of a total amount for the report).


Tips on how to do it right? 


Please note that I am really new to the of SSRS reports.


0 Replies