How do I set filter on this report?

QuickWE

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.

mohana_cse06

What are the Dataitems available in your report?

QuickWE

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

What is the problem in setting at second tab?
Do you want to remove Work Center tab at first position?

QuickWE

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 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

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.)