How can I make report just for if Boolean True On my Page Item List (31)

sandysatriya
sandysatriya Member Posts: 6
in NAV Three Tier
I have this page Item List,

4861j2omc0mr.jpg

so I wanna create report just for 'Out Of Stock' is TRUE. So just record no 1001, and 1100.

Best Answer

Answers

  • kriki
    kriki Member, Moderator Posts: 9,127
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • sandysatriya
    sandysatriya Member Posts: 6
    sorenhinrup wrote: »
    Create the report with tabel 27 as dataitem, and in the dataitem properties set DataItemTableView as shown here with the blocked field.

    nalkz73p7jb2.png

    How if I filter with variable in Page List ?
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    edited 2018-08-01
    sandysatriya wrote: »
    How if I filter with variable in Page List ?
    If you add a filter on a Page you will filter records in this Page, not on any report
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • sorenhinrup
    sorenhinrup Member Posts: 136
    If you set your filters on the item list, and want the report to be run on these filters - then you need to code the function on the page.

Categories