Latest Topics...
 |
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
|
|
|
|
|
|