<div>
<div class="content wysiwyg-content">
I'm trying to do a report with the SQL Server 2000 Report Services extension for Visual Studio 2003. &nbsp;One column of the report is the peoples' social security number. &nbsp;The number is stored as a string, but without the two hyphens. &nbsp;I'd like it to &nbsp;display using those hyphens.<br />
<br />
Originally, the column data was...<br />
=Fields!SSN.Value<br />
<br />
I changed it to..<br />
=Format(Fields!SSN.Value,&quot;<wbr />###-##-###<wbr />#&quot;)<br />
<br />
When I run the report, all I see is the string ###-##-####. &nbsp;IOW, no numbers, just pound symbols.<br />
<br />
What am I missing?<br />
<br />
__Birm<br />

</div>
</div>


I'm trying to do a report with the SQL Server 2000 Report Services extension for Visual Studio 2003.  One column of the report is the peoples' social security number.  The number is stored as a string, but without the two hyphens.  I'd like it to  display using those hyphens.

Originally, the column data was...
=Fields!SSN.Value

I changed it to..
=Format(Fields!SSN.Value,"###-##-####")

When I run the report, all I see is the string ###-##-####.  IOW, no numbers, just pound symbols.

What am I missing?

__Birm


SQL Server Report Services, Format SSN (Using Visual Studio 2003)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.