Format – Page 3 – Pardaan.com

RDLC – Format the Number & Thousand Seperator as per Region Setup

RDLC supports the local language Number formats, Thousands separator and Date format. For example: Switzerland (de-CH), number formats is like “1.234,56” but it in a report it always print like: 1,234.56 Bron : Nilesh Gajjar Lees meer...

20 July 2015

Dynamics NAV & BC Tips & tricks

Format XML standard

When you have to format C/AL variables (numbers, dates/times, booleans) for exchange with other apps, call FORMAT(variable,0,9) instead of simply FORMAT(variable). The format 9 formats the variable according to XML standards, and this value can then be interpreted correctly on any system with any regional settings.…

27 February 2015

Dynamics NAV & BC Tips & tricks

Tip #41 | Smart Page Address Formatting

We all know that pages use more real estate than classic forms and we are limmited to two columns. Putting two controls side by side in one column is cumbersome. One of the things I run into a lot since I do many logistics customers (TMS)…

4 February 2015

Dynamics NAV & BC Tips & tricks

Formatting Numbers and Dates in RDLC Report

You can specify a format for numeric and date values by updating the Format property of its text box with a formatting string. For example, you can set a text box for a numeric field to display the number as currency. Bron : Nilesh Gajjar Lees…

20 January 2015

Dynamics NAV & BC Tips & tricks

NAV AS 101 Lesson 8: Formatting

Formatting options for Microsoft Dynamics NAV are pretty basic, but there are a few tricks you should know to get the most out of what you have. Because very little has changed with formatting options in newer versions I’ll show some basics in NAV 2009 Classic,…

19 May 2014

Dynamics NAV & BC Tips & tricks

“The length of the source exceeds the size of the destination buffer” error when using FORMAT function for RecordRef variable

Recently, one of our client started getting error “The length of the source exceeds the size of the destination buffer” when trying to export text file using code (not using dataport). They were exporting file daily since many years and objects also not modified since long…

21 November 2013

Dynamics NAV & BC Tips & tricks

The date format is incorrect in an Excel worksheet when you export in excel via RTC Client

Today i created a processing only report in navision classic client which used to pull some data into excel. The format contain the date fields too. Now while running that report from classic client it works great but while running report from RTC client the date…

6 December 2012