Friday, January 23, 2015

Export All Object and Split into single text file Using Microsoft Dynamics NAV2015 Development Shell

1.Export All application objects from NAV Database to text file,

Export-NAVApplicationObject NAV2015AP-APP-TEST “E:\NAV2015-Objects\All-Objs\NAV2015-All-Objects.txt


Example with filter
Exports codeunits 80..84 from the NAV2015AP-APP-TEST to COD80-84.txt

Export-NAVApplicationObject NAV2015AP-APP-TEST “E:\NAV2015-Objects \COD80-84.txt -Filter 'Type=Codeunit;Id=80..84'


2. Splits a text file that contains more than two application objects into separate text files for each object.

Split-NAVApplicationObjectFile -Source "E:\NAV2015-Objects\All-Objs\NAV2015-All-Objects.txt" -Destination E:\NAV2015-Objects\Text\






This is make is easier to using team foundation to maintain such as history of the objects, version control and etc.

Wednesday, January 7, 2015

NAV Report – RDLC ROW Background Color Iteration



NAV Report – RDLC ROW Background Color Iteration


 BackgroundColor


Background color for Column heading




 


Expressions


In report  properties you can change the color base on expressions.




 


create an expression,




=IIf(RowNumber(Nothing) Mod 2, "Yellow","Khaki")


Result