Search the Community
Showing results for tags 'reports'.
Hi, I am using 'Other' for Facit numbers and in my reports I am wanting to sort by Stamp.CatalogNumber. When I order by Stamp.CatalogNumber, all the numbers with a 1 as the leading digit come before 2. The first stamp listed is Facit 1, then Facit 10, then Facit 1002, and after all 1-leading stamps are listed, Facit 2 is next. When ordering by Stamp.ScottNumber, ordering is numerical. I do notice that if I add leading zeros, the Facit numbers are in order. Is there a way to get Stamp.CatalogNumber to order like Stamp.ScottNumber orders?