Skip to main content
Solved

Report sorting issue with custom usr field

  • 24 July 2024
  • 1 reply
  • 26 views

Forum|alt.badge.img

Hello,

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.

This is the report outcome. But the sorting doesn’t work
Relationship
Sort condition

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.

View original
Did this topic help you find an answer to your question?

1 reply

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1608 replies
  • Answer
  • July 24, 2024

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings