Notifications
Announcements
No record found.
I need to change the currency symbol from Dollar to Euro in the GP SSRS report. Please reply your answers. Thank in advance.
Manikandan.S
*This post is locked for comments
You can use numeric data type for currency field and concatenate the currency symbol from currency setup tables.
Soma,
Thanks for the reply, I need a changes from default GP SSRS reports. If I need to change in default it will take more time consumption. However there are many currency fields in the report.
Mani,
Based on my analysis, I assume there is no option available for printing GP SSRS report with multicurrency. It will print based on client workstation currency.
Hope this helps!!!
Even I have changed my currency in the religion set up window in my system still I am getting the same dollar symbol. Was I right in changing the currency? If it was wrong please let me know how to change currency in local?
Have a look on below link.
stackoverflow.com/.../changing-currency-symbol-in-sql-reporting-2005
formatting-currency-on-a-row-by-row-basis-in-reporting-services.aspx
Hello Soma,
The links explain how to change currency symbol in report level. I am expecting common set up, because report level is more time consumption and rework.
What is your GP version?
Manikandan,
There is no way in the system toi change a setting and have the reports work as other than en-US (unfortunately)
However, PM me your email address and I can send you some Powershell scripts which download the reports and then upload them; Notepad++, or similar, can be used to do a global find and replace of the en-US language code to whatever you want between the download and upload.
I am going to blog about them once I've had a chance to tidy them up so they're presentable; very rough and ready at present, but they do work.
Ian
Thanks to all, I have created work around for this. Actually, we need SSRS report as excel file, after exported the SSRS report as excel file we just do ctrl + A and changed "Accounting number format" to Euro in excel. It is working fine.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
