I have a custom report which uses the InventoryItem dac and i want to sort it by the UsrReportLine custom field which is in the InventoryItem dac and it is a nvarchar type. I have applied the sorting but the sorting doesn’t seem to be working properly.
I have also attached the rpx file below. Please if anyone could check and let me know i would greatly appreciate it! Thanks.
Best answer by darylbowman
You’re attempting to sort a string in ascending order. It’s working exactly like it should.
You have two options:
Change the custom field to an int type (1, 2, 3, etc)
Pad your number strings (001, 002, 010, 011, etc)
Either of these should accomplish what you are expecting.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.