Report.Which filter first-DataItemTableView OR DataItemLink

randrews

Hi.
Anybody know priority of filters in
DataItemTableView, DataItemLink?

Would be (KEY="First Field","Second field") the best in this example :

Property DataItemTableView in report item have filter on "First Field"
Property DataItemLink in report item have link on "Second field"=FIELD("Field from another table")

giulio.cipo

i don't know the exact order but i make some test for performance problem and i think that before there are datitem link and after dataitem view

randrews

Thanks

philippegirod

Care ! If priority means which one will be used, you can test it easily : both are cumulated...
If on a DataItem "Cust. Ledger Entry" linked to the DataItem Customer you add a DataItemTableView to have only the entries for Customer Toto, if in the fist DataItem, you filter is different from "No." = Toto or empty, you will see no lines..... Because it applies the 2 filters DataItemTableView filter then DataItem Link filter .

giulio.cipo

in the Application designer guide there is the appendix b
Report flowchart", so the right order is:
CLEAR DATAITEM
SET DATAITEM TABLEVIEW
SET DATAITEM REQFILTER
TRANSFER DATAITEM LINK section with

for more information you could verify on the manual that is on the navision installation CD

randrews

Thanks a lot, giulio.cipo
I'd better read ADG in future