Formatting Social Security Numbers

Posted on 2010-01-06
Last Modified: 2012-05-08
Hello Experts,
I am currently using the following formula in a report to format social security numbers:
{idntdfndt.ssn} [1 to 3] + "-" + { idntdfndt.ssn } [4 to 5] + "-" + { idntdfndt.ssn} [6 to 9]
Is there a way to modify this formula (or another formula) to display social security numbers as:  XXX - XX  1234 ?
If it matters at all, the report queries an Oracle database.
Question by:jsmith08
    LVL 6

    Accepted Solution

    walk around:  'XXX - XXX - ' + ToText ({RE_INSURANCE_ACCUM.PERS_NUM}) [6 to 9]
    since the first six charachter not displayed anyway

    Author Closing Comment

    Thank you! This is what I need.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now