How do I set filter on this report?

QuickWE
QuickWE Member Posts: 80
edited 2013-07-19 in NAV/Navision Classic Client
Dear All Expert

Please look at the picture ,I would like to set filter at Production Order No. but it 's not first DataItems on this report ,so how can I do?

Thank for every replies.

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    What are the Dataitems available in your report?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • QuickWE
    QuickWE Member Posts: 80
    mohana_cse06 wrote:
    What are the Dataitems available in your report?

    Please take a look at picture ,I would like to set filter at "Prod. Order Routing Line" as field "Production Order No.",(Actually "Production Order No." is requestfilterfields of this Dataitems.)

    Filter is available in second tab.
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    What is the problem in setting at second tab?
    Do you want to remove Work Center tab at first position?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • QuickWE
    QuickWE Member Posts: 80
    mohana_cse06 wrote:
    What is the problem in setting at second tab?
    Do you want to remove Work Center tab at first position?

    Thanks for your replies but my mention is ,I will press some button from any form and I would like to set filters by automatic ,look like press print on sales order so on. Settableview is support only filters was in the first dataitem. But for this case prod. order no. filter it was available in the second dataitems. That 's the main problems. http://www.mibuso.com/forumhttp://www.m ... 3&p=280147#
  • QuickWE
    QuickWE Member Posts: 80
    QuickWE wrote:
    mohana_cse06 wrote:
    What is the problem in setting at second tab?
    Do you want to remove Work Center tab at first position?

    Thanks for your replies but my mention is ,I will press some button from any form and I would like to set filters by automatic ,look like press print on sales order so on. Settableview is support only filters was in the first dataitem. But for this case prod. order no. filter it was available in the second dataitems. That 's the main problems. http://www.mibuso.com/forumhttp://www.m ... 3&p=280147#

    Issued already solved. Thank for all replies.
  • vaprog
    vaprog Member Posts: 1,163
    How did you solve it?

    You can set filters on (almost) any dataitem using Report.SETTABLEVIEW. (Almost because the filters are set on the first instance of any record type and you cannot specify that it should be set on any subsequent occurrence of that record type.)

Categories