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
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items