Sorting Can Not Be Done

MaxNavision

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.

pavithrap0992

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/

MaxNavision

There is no option "SQL Data Type"

saravanans87

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.

MaxNavision

Hello,

Its not a report, its a page

binilabraham

Check the Field property in Table, there you can find "SQL Data Type" property.

MaxNavision

binilabraham wrote: »

Check the Field property in Table, there you can find "SQL Data Type" property.

There is no SQL Data Type" in field property

MaxNavision

Bump. Someone?

sorenhinrup

Have you added the flowfield to a page, or to the source table?

MaxNavision

Source Table

mohana_cse06

@MaxNavision did you get solution for this?
Anyone?

ama

What version of NAV?

mohana_cse06

NAV2016