Sorting Can Not Be Done

MaxNavision
Member Posts: 27
Hello,
I added a flowfield ( text 30 lenght ) and all is working fine, except ordering.
Navision shows this error, and can't find the solution for it on google, so hopefully
someone knows how to fix this error.

Greetings.
I added a flowfield ( text 30 lenght ) and all is working fine, except ordering.
Navision shows this error, and can't find the solution for it on google, so hopefully
someone knows how to fix this error.

Greetings.
0
Answers
-
Hi, I think this link will help you
https://nav-skills.com/2016/08/18/tip-56-fix-error-sorting-cannot-be-done-based-on-the-xx-fields/0 -
There is no option "SQL Data Type"0
-
are you able to compile this report??? i believe you are trying to give a field name to the property which wouldn't be there in the specified table.Software Developer,
Archerpoint India Pvt. Ltd,Chennai.0 -
Hello,
Its not a report, its a page0 -
Check the Field property in Table, there you can find "SQL Data Type" property.Software Developer,
Archerpoint India Pvt. Ltd,Chennai.0 -
binilabraham wrote: »Check the Field property in Table, there you can find "SQL Data Type" property.
There is no SQL Data Type" in field property0 -
Bump. Someone?0
-
Have you added the flowfield to a page, or to the source table?0
-
Source Table0
-
@MaxNavision did you get solution for this?
Anyone?0 -
What version of NAV?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