SSRS Report - sorting on CustomerID

Epicor ERP 10
1

We are on E10 (10.1.400.20) and are using numbers with no leading zeros for our CustomerIDs.

Is there a way to sort correctly when printing a Aging Report? By correctly I mean 120, 11734, 115219, 120025

Currently the sort goes 115219, 11734, 120, 120025.

We realize that leading zeros would fix this, but we don’t want to add leading zeros.

2

Under the Tablix Properties you can go to Sorting and add CustomerID

Dora Chavarria
CAM, Consulting Manager
Mayan Technologies
t: +1 (972) 885-2995 x807
w: www.mayantechs.com e: dchavarria@mayantechs.com
We want to hear from you! Click here to leave a customer review

3

Try sorting by CInt(CustomerID)

1 Like