I have to assign a "Date" Value to a "DateTime" variable. How do I convert the "Date" to a "DateTime"? There are two ways to achieve this, Using CREATEDATETIME procedure Using EVALUATE procedure Using CREATDATETIME Procedure: Use…
Read moreI have to assign a "Date" Value to a "DateTime" variable. How do I convert the "Date" to a "DateTime"? There are two ways to achieve this, Using CREATEDATETIME procedure Using EVALUATE procedure Using CREATDATETIME Procedure: Use…
Read moreIn this rdlc report designer tutorial , I will discuss the basic setup for the rdlc report in Report Builder . Microsoft Report Builder is a tool to build paginated reports used by the Microsoft reporting system. RDLC Stands for Report Definition Language Client-Sid…
Read moreRecently I wrote a change order for a client. Their requirement was to track revision with different vendors and revision include multiple fields. Also, the client provided a list of fields they want to track. The guy who gave requirements was a technical guy and he g…
Read moreWhen we work on multiple tables in excel, sometimes we need to join two tables based on some values common to both tables. There are tables with Header and Line relationships like sales header and sales line, invoice header and invoice line, we need or want to join th…
Read moreHow to convert a date into a specific date format in RDLC report? In RDLC report when we set a date field in a report it displays either full DateTime or it shows in a different style than we desire. We could solve this kind of situation in different ways. In my ca…
Read moreHow to convert .fob file into .txt file in Microsoft Dynamics NAV? How to change '.fob' backup file to '.txt' file or how can I view contents of a .fob file is a common question for new developer of Microsoft Dynamics NAV. When we export objects fr…
Read moreConverting Column into Row or Cell Converting column into row is useful many times while working with Database, CSV file or in Microsoft Dynamics NAV . We have columns of data in Excel sheet and we just want to convert a specific column into cell. In case of Micr…
Read moreFind Duplicate rows in Excel We use excel for different data processing and one of the major requirement is finding repeating data. We can easily remove duplicate data using remove duplicate in excel but finding unique or duplicate value is quite tricky. This list …
Read more–>