Plataan - Microsoft Dynamics - Learning & Competence Management Vincent Bellefroid Koen Stox Steven Renders Conny Schuddinck Steffie Alexiou
A blog about Microsoft Dynamics
Home Archives Subscribe Plataan website

« Integrate the Dynamics NAV 2009 Role Tailored Client in Internet Explorer | Main | How can I see Notes in the Dynamics NAV 2009 Classic Sql Client? »

13/03/2009

Reporting Services Tip about using the user's regional settings.

When creating Sql Server Reporting Services Reports you can sometimes end-up with data in US format instead of the local regional settings of the user.

For Example:

Here we have a report showing the Sales LCY and Profit LCY by Salesperson and Country in a matrix control. The data is coming from the Dynamics-NAV Sql database, but the formatting of the amounts is in US format, even when the report is running on a system that has Belgium regional settings.

How can we correct this?

Well there's a simple solution for this common problem. In the Report Designer in Visual Studio, the report has a LANGUAGE property:

By default this will contain English (United States), but by changing it to an expression you can make it dependant on the users Regional Settings:

Select <Expression>, then the Expression Editor opens. Then type in =User!Language

Run the report again to see the result:

Then Report will recognize user client's culture settings, e.g. Internet Explorer's languages settings.

Comments

Hi,
How to get the regional language effect on text data in report when that TextBox value is formatted.

ex. Date return formatin SSRS is Date+Time, But I format Date by removing "Time" part.
For this "regional" setting discussed in this blog is not working.
Can you igve better solution for this?

Hello! I have several reports that are execute in different countries. What I want to do is no matter what regional settings the user have, always export in US-English. How can I do that?

Hi,
Thanks for the tip.
Do you know if this can be set at a SOLUTION LEVEL so I don't have to set it at a REPORT LEVEL? I have a solution that has many reports.
Regards,
Jason TEPOORTEN

I want to do the other way around. I want to export the information always using US language no matter what regional settings the user have.

Pivotier is a new reporting product for Dynamics NAV which enables both developers and end-users to leverage RDL and SSRS.

Demos are at www.pivotier.com.

The comments to this entry are closed.

October 2011

Mon Tue Wed Thu Fri Sat Sun
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31            

Plataan Community

Visit us on LinkedIn Visit us on Facebook Visit us on Twitter