Kunal Blog

 Hi Everyone, First of all, Wish You all Happy New Year in Advance. May God bless you all with wonderful life ahead😊😊😊.. Print Blank when the value is Zero in Navision (RDLC) Reports Sometimes when we are printing Integer or Decimal type field in RDLC Report we didn't want to display 0 if the value of that field or expression is Zero, but rather display it as blank. Example:-  Here we have created one Report, and you can see that in Debit(LCY) and Debit (ACY) column fields value is zero and it did not print zero i.e, its printed as blank. This is only done because in RDLC Report Properties there is a pre-defined function called BlankZero which looks like :   This function consider numeric value and if the value is zero it returns blank text string. So if you need to display blank you can use the below mention expression with the required field value. =Code.BlankZero(Fields!Debit_Amount.Value) Syntax denoted as : =Code.BlankZero(YourFieldHere) I hope this blog helps you to dis

Hi Guys, In this article, we will see how to display amount in words in Microsoft Dynamics Business Central. Here, I am taking an example of Report object  which is widely used in Navision for converting decimal amount field into words. Procedure :-  Step-1 Declare the following Global Variables :         RepCheck:  Report  "Check";         NoText:  array [ 2 ]  of   Text ;         AmountInWords:  Text ; where, (1) RepCheck is a variable of  Report DataType Named as " Check " which is 1401. (2) NoText is a variable of DataType " Text " with array Dimension value as 2 which is defined as shown above. (3) AmountInWords is a variable of DataType " Text " which will store final result of amount in words. Step-2 Now, add the following code in OnAfterGetRecord() trigger of DataItem containing that decimal field value. So in my custom Purchase Order Report, i am adding code in the Purchase Header (DataItem) - OnAfterGetRecord() trigger.   trigger  OnA

 Hi Everyone, In this article we will see how we can Calculate Date by adding and subtracting No. of Days / Months based on CalcDate and DateFormula datatype. Here, I define three variables required for: (1) " No of Days " -  To define No. of Days / Months as required. You can also use these units denoted as: <Unit> = D | WD | W | M | Q | Y (D=day, WD=weekday, W=week, M=month, Q=quarter, Y=year). (2) " From Date " and " To Date "  Date type Variables to store calculated date in it. page   50103  "Date from Date Formula" {     PageType = Card;     ApplicationArea = All;     UsageCategory = Administration;     SourceTable =  Integer ;      layout     {          area( Content )         {              group( General )             {                  field( "No. of Days"; "No. of Days" )                 {                     ApplicationArea = All;                 }             }         }     }      actions     {          area