Options

Report.Which filter first-DataItemTableView OR DataItemLink

randrewsrandrews Member Posts: 135
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")

Comments

  • Options
    giulio.cipogiulio.cipo Member Posts: 77
    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
  • Options
    randrewsrandrews Member Posts: 135
    Thanks
  • Options
    philippegirodphilippegirod Member Posts: 191
    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 .
    My candle burns by both ends, it will not last the night,
    But oh my foes and oh my friends, it gives a lovely light
  • Options
    giulio.cipogiulio.cipo Member Posts: 77
    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
  • Options
    randrewsrandrews Member Posts: 135
    Thanks a lot, giulio.cipo
    I'd better read ADG in future
Sign In or Register to comment.