Jet Essentials - Report Doctor - Proper Filter technique with Summary reports

  Рет қаралды 4,172

DataCrew (formerly Onyx Reporting)

DataCrew (formerly Onyx Reporting)

Күн бұрын

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

Пікірлер: 1
@joseblazquez2178
@joseblazquez2178 8 жыл бұрын
Boy, You are good!!!!Don't even use the wizard anymore, can tell you know the fields names by heartThanks for taking the time to make this great videos!!!!
Jet Essentials - working with Field Cache
7:00
DataCrew (formerly Onyx Reporting)
Рет қаралды 1,1 М.
Jet Essentials - understanding 1:M and M:1 when Filtering multiple tables
8:44
DataCrew (formerly Onyx Reporting)
Рет қаралды 3,6 М.
Amazing Parenting Hacks! 👶✨ #ParentingTips #LifeHacks
00:18
Snack Chat
Рет қаралды 22 МЛН
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 1,6 МЛН
Jet Professional Basics - NAV FlowFields
16:51
DataCrew (formerly Onyx Reporting)
Рет қаралды 10 М.
Introduction to Jet Reports: Everything You Need To Know
43:45
Report Options with Jet Reports
6:46
Reports Your Way
Рет қаралды 6 М.
Jet Reports for Microsoft Dynamics GP | Sikich
16:38
Sikich
Рет қаралды 3,8 М.
The Home Server I've Been Wanting
18:14
Hardware Haven
Рет қаралды 70 М.
Domo+DataCrew - Unlocking Automation with Domo Workflows
1:24:03
DataCrew (formerly Onyx Reporting)
Рет қаралды 464
Jet Professional - NL(First) with Multi Company NAV
18:09
DataCrew (formerly Onyx Reporting)
Рет қаралды 2,2 М.