I want to set a table filter for a lookup (or drilldown) on a table, like the Customer table, for a Request Page on a report.
I want to set filter: 'Customer Posting Group' so that only customers for that posting group will show up in my lookup.
I want to do the lookup for the Customer.'No.' field. The field is added to the ReqFilterFields on the Customer.DataItem of the report.
I have set the 'Customer Posting Group' filter in the Request Page.OnOpenPage trigger. But it has no impact.
I do know that the same can be achieved by adding a dedicated Customer No. field on the Request Page and add functionality to the field trigger(s) with a page call and settableview, etc.... but the problem there is that I can't set a range, since each time, after you have set the Cust.No for the 'Begin-range' and go back to the lookup page to find the next customer no. for the end-range (like 100..200), the first custno (Begin-range) dissappears. You wouldn't have that for doing a lookup from a field, defined in the ReqFilterFields.
Any idea if it's possible?