Рет қаралды 4,172
Jae Wilson from OnyxReporting.com shares how to improve report performance with proper filter technique.
The rules:
Always put filter criteria in the TOP LEFT
Each NL() summary function (Rows, Columns, Sum) must have the same number of filter criteria
Never filter on the same field twice
If a filter only affects a region of the report, move the filter to that region