Data Browser - Viewing Site  The DataBrowser Forum Logged in as:  Guest  




           


SSRS 2005 Pad Left to a number
To pad a number left with zeros, use this function.
Replace '4' with your minimum desired width and '0' with your pad character.
Replace Fields!Number.Value with your number.
If the number is longer than the minimum, it will show the entire number.

Examples:
4 -> 0004
100 -> 0100
3994 -> 3994
87895220 -> 87895220

StrDup(4 -
IIf(Len(Cstr(Fields!Number.Value)) < 4,
Len(Cstr(Fields!Number.Value))
, 4), "0")
+ Cstr(Fields!Number.Value)

Created By: amos 12/31/2014 10:59:22 AM