Question Status

Suggested Answer
Natarajan SankaraNarayanan asked a question on 14 Feb 2014 6:47 AM

how to set the currency symbol of a company in ssrs report? in GP, the reports run with company's currency but in ssrs it display single currency symbol to all companies. any solution for this?

Any configuration is missing?

Please advise..

Regards

Nataraj S

Reply
Suggested Answer
Richard L. Whaley responded on 14 Feb 2014 2:54 PM

If I remember correctly, SSRS takes the currency symbol from the work station setup.  As an alternative, you could use a numeric data type rather than currency and pre-pend the currency symbol from the multicurrency home currency setup.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Suggested Answer
Richard L. Whaley responded on 15 Feb 2014 7:54 PM

Please use Rich Formatting when pasting images (bottom right of Answer Window.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Suggested Answer
Richard L. Whaley responded on 14 Feb 2014 2:54 PM

If I remember correctly, SSRS takes the currency symbol from the work station setup.  As an alternative, you could use a numeric data type rather than currency and pre-pend the currency symbol from the multicurrency home currency setup.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Natarajan SankaraNarayanan responded on 14 Feb 2014 10:13 PM

Hi Richard,

Since the default standard reports show like this..

Regards

Nataraj S

Reply
Suggested Answer
Richard L. Whaley responded on 15 Feb 2014 7:54 PM

Please use Rich Formatting when pasting images (bottom right of Answer Window.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Natarajan SankaraNarayanan responded on 17 Feb 2014 6:24 AM

Hi Richard,

if the report is customized/new report then what you have mentioned above is correct..

how can we modify all the GP reports in this scenario. its is a Bug? or missing configuration?

please find the attached snap of GP standard report in SSRS.

Regards

Nataraj S

Reply
Raghu Ariga responded on 17 Feb 2014 7:20 AM

Hi Nataraj,

You can use Rich Formatting when pasting images

And replace the currency $ to the image you like to display.

Thanks,

Raghu

Reply
Natarajan SankaraNarayanan responded on 20 Feb 2014 6:18 AM

Hi Raghu,

I want the company currency symbol in SSRS. its is possible or not? and not about Rich formatting.

Regards

Nataraj S

Reply