Can filter the dataitem just load specific value in report

Tien
Tien Member Posts: 4
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

  • ShaiHulud
    ShaiHulud Member Posts: 228
    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);
  • Tien
    Tien Member Posts: 4
    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

  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories