Home

SSRS Multi-currency report DYNAMICS 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1039694%22%20slang%3D%22en-US%22%3ESSRS%20Multi-currency%20report%20DYNAMICS%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039694%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20know%20exactly%20how%20to%20put%20my%20problem%20but%20I'll%20try%20to%20hope%20you%20understand%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20gol%20is%20to%20create%20a%20kind%20of%20Aging%20report.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20report%20currently%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20542px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159418iA9BA276C34F02A0C%2Fimage-dimensions%2F542x348%3Fv%3D1.0%22%20width%3D%22542%22%20height%3D%22348%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20pretty%20much%20what%20I%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20an%20sub-total%20amount%20for%20the%20invoices%20(highlighted%20in%20yellow)%20and%20an%20intermediate%20amount%20for%20the%20client%20(highlighted%20in%20green)%20and%20total%20for%20the%20report%20(highlighted%20in%20blue).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%20is%20separate%20the%20table%20(if%20possible%20automatically)%20%3CSTRONG%3Eby%20invoice%20currency%3C%2FSTRONG%3E.%26nbsp%3BSo%20I%20get%20multiple%20tables%20according%20to%20the%20currencies%20and%20a%20%3CSTRONG%3Eseparate%20total%20for%20each%20table%3C%2FSTRONG%3E%20according%20to%20the%20currencies%20(Instead%20of%20a%20total%20amount%20for%20the%20report).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETips%20on%20how%20to%20do%20it%20right%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20I%20am%20really%20new%20to%20the%20of%20SSRS%20reports.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
alexander yurpolsky
New Contributor

Hello,

 

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:

 

clipboard_image_1.png

 

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.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies