Filters, keys and grouping
eYe
Member Posts: 169
On my report I loop through the Customer table, then through the Value Entry Table where Source No. = Cust."No."
The Key on my Value Entry table is setup to be <"Source No.","Document No.","Item No.">, grouping is done on "Item No.", so on the report the total for the item per document per customer is printed.
When the user filters on "Value Entry"."Posting Date", it should not print the grouped line if for that document in that period, the "Sales Amount (Actual)" is zero. If it is not zero, find the entries of that document that fall outside of the filter and do your calculations.
The Report works fine... Except it takes AGES to complete, because of the keys and the filters that are set in code on the data item. I can't change the key on the data item because of the grouping. I can't find any other way to do it... ](*,) ](*,)
The Key on my Value Entry table is setup to be <"Source No.","Document No.","Item No.">, grouping is done on "Item No.", so on the report the total for the item per document per customer is printed.
When the user filters on "Value Entry"."Posting Date", it should not print the grouped line if for that document in that period, the "Sales Amount (Actual)" is zero. If it is not zero, find the entries of that document that fall outside of the filter and do your calculations.
The Report works fine... Except it takes AGES to complete, because of the keys and the filters that are set in code on the data item. I can't change the key on the data item because of the grouping. I can't find any other way to do it... ](*,) ](*,)
Kind Regards,
Ewald Venter
Ewald Venter
0
Comments
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 324 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
