Data – Page 30 – Pardaan.com

Copying Data from NAV using Windows Clipboard – RTC vs. CC

For one time analysis of data in NAV I always take the quick and easy route of copying data from NAV to Excel using the windows clipboard. Running the relevant table(s) from Object Designer, copy (preferably) all records and paste the whole bulk into an Excel…

2 January 2012

Dynamics NAV & BC Technical Tips & tricks

SQL Server Data Compression and Microsoft Dynamics

I am pleased to announce the release of the SQL Server Database Compression Analyzer for Dynamics. This tool was created to help Dynamics partners and customers leverage the benefits of SQL Server Data Compression and to make the processing of analyzing and implementing compression quicker and…

25 August 2011

Dynamics NAV & BC Tips & tricks

The Query returned no rows for the data set

If you are using RTC and previewing certain reports you probably will run into this error. “An error occurred during local report processing.” The Hidden expression for the textbox ‘……’ contains an error: The query returned no rows for the data set. The expression therefore evaluates…

18 August 2011

Dynamics NAV & BC Tips & tricks

Encrypting Data in NAV using SQL with ADO

A lot of Dynamics NAV databases carry sensitive information that by law in some countries need to be encrypted. For example credit card number or social security number. There are many solutions available. The following solution utilizes SQL Server 2005 and SQL Server 2008 provided encryption…

10 August 2011