RDLC Report Language issue

thijshensthijshens Member Posts: 15
edited 2012-09-17 in NAV Three Tier
Hi there,

I have made several RDLC reports that have one same problem:

In Classic, the report shows dates like '31-01-2012'. Amounts are shown as 5.120,99.
So far so good, because this is European notation.

When I run this same report in RTC, the date is shown as 01\31\2012 and the amounts are 5,1200.99.

Can anyone explain me how I can solve this problem?
I don't know why RTC still shows the USA dates.

Thanks in advance!

Comments

  • geordiegeordie Member Posts: 655
    Which value is set in "Language" property in RDLC design? And what about regional settings in NAV server?
  • thijshensthijshens Member Posts: 15
    geordie wrote:
    Which value is set in "Language" property in RDLC design? And what about regional settings in NAV server?

    Thanks very much! It was set to USA.
    Changed it to Dutch and now it works fine.
    I didn't knew this is an option for te report.
  • geordiegeordie Member Posts: 655
    I usually set "=User!Language", to prevent this kind of matters :wink:
  • thijshensthijshens Member Posts: 15
    geordie wrote:
    I usually set "=User!Language", to prevent this kind of matters :wink:

    That is a good option indeed.
    Thanks again!
  • clauslclausl Member Posts: 455
    If you use "Create Layout Suggestion" when you create your report in the first place "=User!Language" will be set automatically by the tool.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
Sign In or Register to comment.