Hide part of a ssn field to show only last 4

[James Gill]

I'm trying to find a way to set a preference on a report to show an ssn as either a full, partial (only with last 4 displayed) or all x's. How would I go about doing this?

[comment]

Set a global field for the preference and a calculation field for the result.

[James Gill]

How would I format the calculated field to display the results that I wanted? I'm relatively new to calcs so any help is appreciated.

[comment]

Try =

Case (

gPreference = "Full" ; SSN ;

gPreference = "Partial" ; Right ( SSN ; 4 ) ;

"xxx-xx-xxxx"

)

[James Gill]

Is it possible to add the proceeding xxx-xx- to the SSN inside of the Case formula or do I need to create a combine field?

[comment]

Ah. So how about =

Case (

gPreference = "Full" ; SSN ;

gPreference = "Partial" ; SerialIncrement ( "xxx-xx-0000" ; Mod ( SSN ; 10^4 ) ) ;

"xxx-xx-xxxx"

)

[James Gill]

Worked great! How the heck do you know all of this stuff?

[David Jondreau]

SerialIncrement ( "xxx-xx-0000" ; Mod ( SSN ; 10^4 ) )

Why do you choose that over "xxx-xx-" & Right(SSN;4)?

[comment]

We weren't told how the SSN's are stored (with hyphens, etc.) and I wanted to avoid the assumption that the last 4 characters were all digits.