SSRS Report - sorting on CustomerID

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.

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: e:
We want to hear from you! Click here to leave a customer review

Try sorting by CInt(CustomerID)

1 Like