<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
It looks like I could use the =System.Text.RegularExpres<wbr />sions.Rege<wbr />x.Replace(<wbr />Fields!Pho<wbr />ne.Value, &quot;(\d{3})[ -.]*(\d{3})[ -.]*(\d{4})&quot;, &quot;($1) $2-$3&quot;) in SSRS 2005 report.<br />
But when I try to do it, =System.Text. didnot have the RegularExpressions object.<br />
It doesn't show up in the dropdown.<br />
<br />
I have this field in this format ((xxxxxx*)) xxxxx*, I want to grab the ((xxxx)) part using the regular expression. I want to look for (( &amp;&nbsp;)) and grab everything between them.<br />
<br />
Thanks.<br />
<br />

</div>
</div>


hi,

It looks like I could use the =System.Text.RegularExpressions.Regex.Replace(Fields!Phone.Value, "(\d{3})[ -.]*(\d{3})[ -.]*(\d{4})", "($1) $2-$3") in SSRS 2005 report.
But when I try to do it, =System.Text. didnot have the RegularExpressions object.
It doesn't show up in the dropdown.

I have this field in this format ((xxxxxx*)) xxxxx*, I want to grab the ((xxxx)) part using the regular expression. I want to look for (( & )) and grab everything between them.

Thanks.



regularExpression in SSRS report?

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.