Formatting the Zip code depending on size

[SSirica]

I have a report (trdp) with a zip code field.  some of the data has the zip code saved as 5 digits some have 9 (ie. 12345-4578).  If the data length is 5 I want the report to display 01245 if it's length is > 5 I want to display 01245-7845. 

How would one acomplish this without using a user defined function?

[Neli]

Hello SSirica,

 

You can use the Conditional Function IIf and the Text Function, Len, to check for the length of the zip. Then you need Substr to get the substrings from the zip code. The expression may look as follows:

= IIF(Len(Fields.Zip) > 5 ,
Substr(Fields.Zip,0,5) + "-" + Substr(Fields.Zip,5,4),
Fields.Zip)

You can also check the attached report which demonstrates the approach.

Regards,
Neli
Progress Telerik