Number format in RTC report

Isaland
Member Posts: 52
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.
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
0
Comments
-
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ømClaus 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 :-)0 -
clausl wrote:Use the Format given to you from NAV. All standard reports uses this approach.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)MB7-8400 -
Isaland wrote:clausl wrote:Use the Format given to you from NAV. All standard reports uses this approach.
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>')
1
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions