Can filter the dataitem just load specific value in report

TienTien Posts: 4Member
edited 2019-12-02 in NAV Three Tier
Hi Guys,
I have a NAV report as below:
- Dataitem is a table has more records many types: 1, 2, 3...
- Need to create a report just load the type = 1 when openting the report.
Note: Do not allow using the Request page.
nfwec7si1h4r.png
Could I do it with dataitem not use the request page?
Please give me some advices.
Thanks,

Answers

  • ShaiHuludShaiHulud Posts: 75Member
    If you want to hard-code a filter, you should add code to "G/L Entry - OnPreDataItem()" trigger and it should be something line:
    SETRANGE("Document Type", "Document Type"::Payment);
    
    Arturas Kulsinskas
    NaviLogic
  • TienTien Posts: 4Member
    ShaiHulud wrote: »
    If you want to hard-code a filter, you should add code to "G/L Entry - OnPreDataItem()" trigger and it should be something line:
    SETRANGE("Document Type", "Document Type"::Payment);
    

    Hi ShaiHulu,
    Thanks for your advice!
    I mean that it need to filter when I open the Request page not running the report.
    wk2f0tx50hus.png

  • krikikriki Posts: 8,836Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
Sign In or Register to comment.