Print this page

Autonumber is not sorting as expected in a report.

Knowledge Article Number 000187512
Description If an auto-number is created without a format (See Example below), it will not sort in order within a report or list view.

This is considered working as designed as the report/list view cannot determine what each digit means.
 

Auto-Number Formatting Examples

Use these examples when setting the display format for auto-number fields.

FormatDisplayed Values
{0}3 66 103
{000}003 066 103
Sample- {00000}Sample- 00003 Sample- 00666 Sample- 10023
Value- {00} {MM} {DD} {YY}Value- 03 12 02 04 Value- 76 03 03 04 Value- 123 11 09 04
PO #{0} {MM}-{DD}-{YY}PO #12233 12-20-04 PO #25 06-07-04 PO #3 07-07-04


 
Resolution The easiest way to resolve is to recreate the auto-number field while including a format such as one in the Description Example.




promote demote