Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Many SumindexFields >100
JedrzejT
Member Posts: 267
I need to take totals on about 120 fields in one table for 2 reports.
They will be used these reports about 10,15 times a month
Once in a month they entered about 2000-3000 record in this table
I need sumindexfield on this key:
"Document No.,Employee No.,Organization unit,Cost account,Emp type,List type,Payout date,Document date"
All sift level maintain!
What i should do?
Create fields:
Employee No. 2,Employee No. 3,Employee No. 4,Employee No. 5
On insert Trigger put code:
Eployee 2,3,4,5 = Employee no.
Create keys.
Doc No.,Emp No.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 1.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 2.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 3.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 4.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No.5,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
And for all create 20 sumindexfield = 120
OR
Simply Sum field along loop for this reports.
They will be used these reports about 10,15 times a month
Once in a month they entered about 2000-3000 record in this table
I need sumindexfield on this key:
"Document No.,Employee No.,Organization unit,Cost account,Emp type,List type,Payout date,Document date"
All sift level maintain!
What i should do?
Create fields:
Employee No. 2,Employee No. 3,Employee No. 4,Employee No. 5
On insert Trigger put code:
Eployee 2,3,4,5 = Employee no.
Create keys.
Doc No.,Emp No.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 1.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 2.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 3.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No 4.,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
Doc No.,Emp No.5,Orgunit,Cost acc,Emp type,List type,Paydate,Doc date
And for all create 20 sumindexfield = 120
OR
Simply Sum field along loop for this reports.
0
Comments
RecRef.OPEN(54019);
FOR I:=1 TO RecRef.FIELDCOUNT DO BEGIN
FldRef:=RecRef.FIELD(I);
EVALUATE(FieldValue[1],FORMAT(FldRef.VALUE));
END;
So,I have made it in this way
Regards.
I traded my sanity for a railgun