Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

need to show amount with currency in ssrs report

Posted on by 5,885

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,148 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,740 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,885 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,885 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans