Tuesday, February 19, 2019

NAV CAL - Add a variable filter on request page to filter calculated field


  • Report>RequestPage
    • Add Container Name
    • Add Group Name
    • Create Global Variable to store request input
    • Add field>Select Global Variable
    • This Variable will hold the input from the request page
  • CAL on Report
    • OnAfterGetRecord>
    • Compare Request page variable to report field and skip record if no match
    • IF Variable <> Reportfield THEN CurrReport.SKIP 

No comments:

Post a Comment