How to make Views in Navision

sadozaiw

Dear All!
I am new to Navision but had been working in Oracle and VIEWS were very handy in Oracle programing.
Can we make views in Navision also and base our reports on those views?

bbrown

You can use views by use linked tables. Linked tables are explained in the Application Designers Guide. (See w1w1adg.pdf in the DOC folder of the CD).

The basic steps are:

1. Create a view that returns the desired data. The fields must conform to NAV standards.

2. Create a NAV table object with the same name and field names as the view

3. Set the LinkedObject property and compile.

The ADG provided addtional information. This is a very useful feature.

slmaluwa

And, this applies to NAV+SQL DB only?
With NativeDB, i think that there is no such thing called "VIEW"
Am I correct or is there a way to create a view and display them on a TableBox?

bbrown

slmaluwa wrote:

And, this applies to NAV+SQL DB only?
With NativeDB, i think that there is no such thing called "VIEW"
Am I correct or is there a way to create a view and display them on a TableBox?

You are correct. This applies to NAV SQL only.

Waldo

If it could be of any help .. I wrote a little something about it on my blog.