<div>
Try these sites as they have code which you can use as a custom function in your report. Just add the code to the Code tab of the report properties and call the relevant function by using the expression '=code.function()' replacing function() with the name of your function<br />
<br />
<a href="http://www.vbexplorer.com/VBExplorer/tips/src36.asp" rel="ugc">http://www.vbexplorer.com/VBExplorer/tips/src36.asp</a><br />
<a href="http://vbcorner.blogspot.com/2007/10/convert-number-currency-to-word-part-i.html" rel="ugc">http://vbcorner.blogspot.com/2007/10/convert-number-currency-to-word-part-i.html</a><br />
<a href="http://www.vbforums.com/showthread.php?t=192290" rel="ugc">http://www.vbforums.com/showthread.php?t=192290</a><br />
<br />
Hope this helps<br />
<br />
Rob<br />
<br />

</div>


Try these sites as they have code which you can use as a custom function in your report. Just add the code to the Code tab of the report properties and call the relevant function by using the expression '=code.function()' replacing function() with the name of your function

http://www.vbexplorer.com/VBExplorer/tips/src36.asp [http://www.vbexplorer.com/VBExplorer/tips/src36.asp]
http://vbcorner.blogspot.com/2007/10/convert-number-currency-to-word-part-i.html [http://vbcorner.blogspot.com/2007/10/convert-number-currency-to-word-part-i.html]
http://www.vbforums.com/showthread.php?t=192290 [http://www.vbforums.com/showthread.php?t=192290]

Hope this helps

Rob



<div>
<div class="content wysiwyg-content">
Hello experts!<br />
I need a custom code function for Reporting Services that will convert a currency amount to spelled out words for a report I am generating that will print checks. &nbsp;The currency amounts are the sum of multiple fees in a group that are detailed in the statement on the top portion of the check. &nbsp;Does anyone know of a function I can put into Custom Code or a Reporting Services function that will convert the report amount to the words?<br />
<br />
Thanks,<br />
<br />
Susan
</div>
</div>


Hello experts!
I need a custom code function for Reporting Services that will convert a currency amount to spelled out words for a report I am generating that will print checks.  The currency amounts are the sum of multiple fees in a group that are detailed in the statement on the top portion of the check.  Does anyone know of a function I can put into Custom Code or a Reporting Services function that will convert the report amount to the words?

Thanks,

Susan

Convert currency to words in Reporting Services

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.