You’re offline. This is a read only version of the page.
22
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
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.
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.
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
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
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
#1
Martin Dráb
439
Most Valuable Professional
#2
Abhilash Warrier
305
#3
Saalim Ansari
261
Share
Report
All responses (
Answers (
