what is the user of Settableview keyword?

chandrurec

Hi all,

I want to know the usage of the keyword Settableview in navision.

If anyone knows the use of Settableview in NAV, Kindly explain me with an example.

Thanks in advance.

Regards,
chandru.

mohana_cse06

Applies the table view on the current record as the table view for the form, report, dataport, or XMLport.

SETTABLEVIEW(Record)

The table view is the view of the table that you present to the user. You determine what records the user can see by setting filters, determining the sorting order, and selecting the keys.

This function only narrows the view of the table that was set through the SourceTableView Property of the form, or through the DataItemTableView Property of the data item.

If you use this function and the SaveTableView Property of the form is set to "Yes", the current table view in the setup file will not be saved.

Ex:
Record.SETCURRENTKEY(Key-field1, ...);
Record.SETFILTER(Field, Filter);
Report.XXX; // Any user-defined function.
Report.SETTABLEVIEW(Rec)
Report.RUN()