Report Auto Filters

ravi_navision

Hi,

Here is my Problem.

I created a new report with Data Item "Sales Line". No filters on "sales line" Data Item.
I ran the report and selected the Blanket Order No. field on request form, Clicked on lookup; lookup form showing only some of the Blanket orders.

When I checked at the table filters; it shows

Field	                 Filter
Document Type         Blanket Order
Type	                 ' '
No.	                 ''
Bill-to Customer No.   ''
Sell-to Customer No.  ''
Document No.

How these filters applied automatically?
I re-compiled the report. Still showing the same filters

Thaks,
Ravi

DaveT

Hi Ravi,

There is a lookup function called in the onlookup trigger of the blanket order no. (at table level) This is designed to do a lookup from entering a sales line but not a report. If you want a clean lookup then drop it onto the request form and add lookup code.