Add hyphen to a number 2

[tkschief]

Hi,

I'm using CR 11 and I cannot figure out how to format a number field to include a hyphen after the first 2 digits in the number. Is this possible?

For example, T_CASE_INCIDENT.INCIDENT_ID displays as 1001281 in my report. I need it to display as 10-01281.

Thanks for any help you can provide!

T

 

[briangriffin]

You'll end up with a text value, not a number:

left(totext({yourfield},"#",0),2) + "-" + right(totext({yourfield},"#",0),len(totext({yourfield},"#",0))-2)

 

[lbass]

If the number is always the same length, another solution would be:

picture(totext({table.number},0,""),"xx-xxxxx")

-LB

 

[tkschief]

Thanks - both of these answers work!