Ambigous problem with a setfilter

sabzam
Member Posts: 1,149
Dear All,
I have created a perfectly-working report. Today I have decided to add a new set filter which is the item ledger filter. By commenting the code the report works perfectly but when removing the code it simply get stuck even though actually it is not being used.
SETRANGE("Date Filter",PeriodStartDate,PeriodStartDate[i+1] - 1);
SETFILTER("Item Ledger Filter",'Negative Adjmt.');
SETFILTER("Sales Type Filter", 'Stock');
CALCFIELDS("Sales (Qty.) - Sales TYpe", "Sales (LCY) - Sales Type", "Avg. Cost (LCY) - Sales Type");
Can anyone explaing to me this thing since I can't explain why this is happening. Please note that I have created the item ledger filter column and therefore am more than sure that it is not affecting anything.
Best Regards,
Stephen
I have created a perfectly-working report. Today I have decided to add a new set filter which is the item ledger filter. By commenting the code the report works perfectly but when removing the code it simply get stuck even though actually it is not being used.
SETRANGE("Date Filter",PeriodStartDate,PeriodStartDate[i+1] - 1);
SETFILTER("Item Ledger Filter",'Negative Adjmt.');
SETFILTER("Sales Type Filter", 'Stock');
CALCFIELDS("Sales (Qty.) - Sales TYpe", "Sales (LCY) - Sales Type", "Avg. Cost (LCY) - Sales Type");
Can anyone explaing to me this thing since I can't explain why this is happening. Please note that I have created the item ledger filter column and therefore am more than sure that it is not affecting anything.
Best Regards,
Stephen
0
Comments
-
-Did you add the field "Item Ledger Filter" to the calcformula of the different flowfields you calculate?
-And did you add the field used in the calcformula to the index used in the underlying table to calculate the flowfield?Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
and is "Item Ledger Filter" of type Option or Code? If Option, then your usage of filter is not correct... :whistle: (do not forget to multilanguage and other things...)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions