View – Page 4 – Pardaan.com

High Performance SQL Views Using WITH(NOLOCK)

Every now and then you find a simple way to make everything much faster. We often find customers creating data warehouses or OLAP cubes even though they have a relatively small amount of data (a few gigs) compared to their server memory. If you have more…

16 July 2014

Dynamics NAV & BC Tips & tricks

NAV AS 101 Lesson 16: Analysis Views

Now that you know you can use dimensions with account schedules, how do you do it? You need to create an analysis view. Analysis views give us the ability to reach into our dimensions, past the two globals, and into the full list of dimensions, allowing…

12 June 2014

Dynamics NAV & BC Tips & tricks

View Change Log from Ribbon

The Change Log in Microsoft Dynamics NAV is used to log inserts, modifications and deletions of records. This is very useful and can be an option for the users to see who created the record, what was the value of a field before, when was the…

5 May 2014

Dynamics NAV & BC Tips & tricks

Expand your use of dimensions in NAV account schedules by using analysis views

If I had to pick only three basic elements to Microsoft Dynamics NAV account schedules, I’d have to choose row setups, column layouts and analysis views. Of course, row setups give you access to basic general ledger accounts and column layouts give you options on how…

31 October 2012

Dynamics NAV & BC Tips & tricks

Creating Filtered Views in NAV 2009 RTC

Last Monday, we posted an article here about filtering effectively using wildcards and expressions. The ability to filter has been part of NAV for a very long time (if not since the very beginning) and is a very powerful feature of the user interface. Bron :…

9 April 2012

Dynamics NAV & BC Tips & tricks

Using a SQL view in a NAV 2009 RDLC Report

Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. Bron…

18 March 2012

Dynamics NAV & BC Tips & tricks

View data in a webpage.

How you viewdata in the Nav 2009 SP1/R2 through a Web service in a web form with VB.NET. Ingredients: 1.Visual Studio 2010 2.Dynamics NAV 2009 R2 Bron : My tiny tips Lees meer...

9 January 2012