Number format in RTC report

IsalandIsaland Member Posts: 52
edited 2012-08-08 in NAV Three Tier
Hello again.
I have a question about "format of number value" in RTC Report.
There is some standart formats, when you use textbox format property.
One of them is "N" which always shows 2 digits after coma, and separates thousand groups with space.
Its perfect format for currency values.

But how to use this format for Integer values? I need just separate thousand groups with space without decimal places.
MB7-840

Comments

  • clauslclausl Member Posts: 455
    Use the Format given to you from NAV. All standard reports uses this approach.

    Here is an example from report 111 in the W1 database:
    .

    If you prefer not to use the Format from NAV, you can use these Standard Numeric Format types:
    http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.95)

    /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 :-)
  • IsalandIsaland Member Posts: 52
    clausl wrote:
    Use the Format given to you from NAV. All standard reports uses this approach.
    It does not use thousand groups, like example - "345 547 542".
    clausl wrote:
    If you prefer not to use the Format from NAV, you can use these Standard Numeric Format types:
    http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.95)
    When i use N format, RDLC puts coma and two decimals after my number :|
    MB7-840
  • deV.chdeV.ch Member Posts: 543
    Isaland wrote:
    clausl wrote:
    Use the Format given to you from NAV. All standard reports uses this approach.
    It does not use thousand groups, like example - "345 547 542".

    But in NAV you can make your own 1000 char so just use a white space.
    Format(YourValue,0,'<Precision,2:3><Sign><Integer Thousand><1000Character, ><Decimals>')
    
Sign In or Register to comment.