Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / need to show amount wi...
Finance | Project Operations, Human Resources, ...
Suggested answer

need to show amount with currency in ssrs report

(0) ShareShare
ReportReport
Posted on by @rp@n 5,901

Hi all,

i need to show amount with currency in SSRS report.So, for that i did below code. but the amount field is showing 0.00. not coming valus

amount = salesLine.LineAmount;
currencyCode = salesLine.CurrencyCode;


currencySymbol = Currency::find(CurrencyCode).Symbol;


amountCurrency = StrFmt(" %1 %2", CurrencySymbol,amount);

i have checked, currency setup is not there. i have spoke to the concern person , he will do soon. but atleast, amount will come rite? why amount is not coming?

plaese let me know

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: need to show amount with currency in ssrs report

    The code that you shared has no link to SSRS reports. It just initializes some values to some variables. You forgot to share any details about your report implementation. So it's not possible for us to know why the field is not showing on your report.

    Anyway first you need to test if your code is working and you get the expected text in your amountCurrency variable.

    Did you already do it? Does it work?

    Once you have the correct value in the variable, then you need to somehow show this information on your report. Most likely you need to save it to a temp table and then show the temp table field on your report.

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,746 on at
    RE: need to show amount with currency in ssrs report

    Hi RP,

    Imagine if your transaction is posted in Canadian dollars then how you will show/distinguish in your report because we use $ symbol for canadian transaction as well that is why it it suggested to use CAD50.00, USD50.00 code instead of symbols in the report to keep it simple.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: need to show amount with currency in ssrs report

    Customer wants me to show $250.00 not USD 250.00.

    This is not possible?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: need to show amount with currency in ssrs report

    Hi,

    The sales line table has the currency code available, it will look like EUR 250.00, USD 250.00, AUD 250.00, which looks much better and consistent for me than US$ 250.00, €250.00, etc. which has a different length.

    About your values:

    Do you have transactions recorded in your company? In the standard MS demo companies, the sales line table has a couple of records included e.g. in the USMF demo company.

    Best regards,

    Ludwig

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: need to show amount with currency in ssrs report

    Sorry, not unde6

    As I explained already currency setup is not yet done.but atleast I am expecting to get the amount.

    What is different between currency code and symbol.

    If I am not wrong, I planning to achieve $ 250.00 not Dollar 250.00

    So, I am using symbol.

    Let me know , if anything wrong

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: need to show amount with currency in ssrs report

    Hi @rp@n,

    Do you have a currency symbol setup for all of your currencies?

    Why don't you use the currency code instead of the symbol?

    The code has a clear structure and should be easier to identify compared to a symbol such as $, which can represent the US Dollar, AU Dollar, etc.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans