How to use a flowfield in a report

Peter_Verhoeven
Peter_Verhoeven Member Posts: 2
edited 2005-05-09 in Navision Attain
Is it possible in a report to use a flowfield as a requested filter field?

Comments

  • kine
    kine Member Posts: 12,562
    I think it is possible, but performance is very poor....
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Michael_Sprung
    Michael_Sprung Member Posts: 6
    :)
    Yes, of course it's possible. Check it out with FlowField "Sales (LCY)" from Table 18 - Customer: If you add this Field to the DataItemProperty "ReqFilterFields", it will appear in the relating RequestForm. In this context it will be a good idea to add the "Date Filter", too.

    If you want the user to enter a value not null, place a code like this in the "OnPreDataItem"-Trigger of the Report:
    IF GETFILTER("Sales (LCY)") = '' THEN
  ERROR('Please set Filter on Customer.Sales (LCY)');

Categories