NAV Report Filters

By default, filters on tables from the request page will filter JUST the data in that specific table first, and then join the data as outer joins unless you use cal to explicitly apply the filter to the datasets in the prereport.

Eg.
Item No - OnPreDataItem()
"Item".SETFILTER("Item"."No.",'1000');