Can't (want to) change sorting order in the Budget Form 113
Vytek
Member Posts: 4
Hello,
There is Budget form (ID113) with matrix control. I want to sort records
for ex. in descending order or change the current key, but sorting order
doesn't change. There is something i don't know? :?
Budget form has a SourceTable "Dimension Code Buffer" (ID367)
and Matrix has the same MatrixSourceTable.
(i saw another forms with matrix in them, but form's and matrix's
source tables were different, and sorting order was changing by
changing current key in those forms)
I even created my own "Dimension Code Buffer" table with additional field
"Sort No." and made it my primary key. In this field i put numbers according to them i want to sort records in the Budget form.
Of course, in the code of the form, i have changed "Dimension Code Buffer" variable to my table, i have appended "CopyDimValToBuf" function with code line which assign numbers to the field "Sort No."
I have changed SourceTableView property to "SORTING(Sort No.)".
But form doesn't sort records by "Sort No." field, it sorts them
by field (Dimension) "Code" in alphabetical order. (I can see, there are
assigned numbers to the field "Sort No."!)
Any ideas?
(i'm not sure, if Budget form (113) is a standart form in most countries,
i hope so
but maybe anybody had solved similar problem?
Thank you.
Vytek
There is Budget form (ID113) with matrix control. I want to sort records
for ex. in descending order or change the current key, but sorting order
doesn't change. There is something i don't know? :?
Budget form has a SourceTable "Dimension Code Buffer" (ID367)
and Matrix has the same MatrixSourceTable.
(i saw another forms with matrix in them, but form's and matrix's
source tables were different, and sorting order was changing by
changing current key in those forms)
I even created my own "Dimension Code Buffer" table with additional field
"Sort No." and made it my primary key. In this field i put numbers according to them i want to sort records in the Budget form.
Of course, in the code of the form, i have changed "Dimension Code Buffer" variable to my table, i have appended "CopyDimValToBuf" function with code line which assign numbers to the field "Sort No."
I have changed SourceTableView property to "SORTING(Sort No.)".
But form doesn't sort records by "Sort No." field, it sorts them
by field (Dimension) "Code" in alphabetical order. (I can see, there are
assigned numbers to the field "Sort No."!)
Any ideas?
(i'm not sure, if Budget form (113) is a standart form in most countries,
i hope so
Thank you.
Vytek
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions