Finance | Project Operations, Human Resources, ...

need to show amount with currency in ssrs report

(0) Share

Report

Posted on by @rp@n

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

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

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

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

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Customer wants me to show $250.00 not USD 250.00.

This is not possible?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

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.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

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.

Was this reply helpful? Yes No