Crystal Reports: Show Currency as Words in Crystal Reports

	Resources
	Best sellers: cView Report Analyzer cViewSERVER ReCrystallize

	Articles: Administration Advanced Basic Crystal eNL Database Financial Problems Solved Books: CR Books Database Books Developer Books
	Tools: Analyzers Bestsellers CR Schedulers CR UFLs CR Viewers DataBase Tools Graphics International Mail UFLs ReCrystallizePro
	Add'l: About us Contact Us cViewSUITE Ppt Support
	CrystalReports on Steroids

Crystal Reports: Currency As Words

Thanks to Steve Dowse of Crystal Decisions in Sydney for this technique to show your own currency in words when you use the ToWords function.

It also puts “and ” between words as well as displaying zero cents correctly.

He sent us a Crystal Reports version 9 report with a custom function called “Cheque” to display a dollar amount in words:

Function (currencyVar v1)
Local CurrencyVar RoundCents := round(remainder(v1,1)*100);
Local Stringvar Dollarpart := towords(int(v1),0);
Local Stringvar Centspart := towords(int(RoundCents),0);
if instr(dollarpart, "hundred") > 0
then dollarpart := Replace (dollarpart,"hundred" ,"hundred and" );
dollarpart + " dollars and " + centspart + " cents"

You could modify the custom function to display Euros, Pounds, Yen, Pesos, Francs, Krone, Rupee, Baht, Rand, etc.

The custom function is then invoked in a formula as:

ProperCase(Cheque( {table.currencyfield}))

Of course, if you are working with pre-version 9 Crystal, you can use the same logic in a formula.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.

If you're dealing with currency issues, then you are most likely distributing your Crystal Reports. Do all of the recipients have a Crystal Reports license? If not, you can still send reports in the native .rpt format and those recipients can read the reports. That's correct, if you have a Crystal Reports viewer.

cView is such a viewer. cView Features....

Administrator:

File Associations. You can install cView as the default viewer of rpt files. So if you send a rpt with saved data to a cView user, the user just needs to click on the rpt file to open and view inside cView.
Database Security. cView stores all the database security information prior to processing the report. You can lock this away from users, so they never see the database password.
Ease of Control. Manage a folder of reports, and use the local network security to decide who can view which reports.
Secure Subreports. If your report includes a subreport that requires a database password, cView can process the report. Some report viewers can't.

Now, as an administrator, start putting all of these pieces together. What emerges is a feature set that can make a big difference in your organization. For example:

Reduced TCO. Your total cost of ownership of your Business Intelligence reporting system is drastically reduced because cView is simple, flexible, and powerful. It has the functionality you need, without issues that force users to drive tech support nuts with trouble calls.
Inexpensive upgrade path.You're going to upgrade your version of Crystal Reports some time. Why make that process inherently expensive via a Web-based viewing solution when you can make it inherently cost-effective with a desktop-based viewing solution?
Ease in scalability. cView makes it easy to add seats to your business intelligence system. Just buy another low-cost licensing pack, and you're good to go. For repeat customers, we offer repeat purchase discounts and we provide options that eliminate complicated license management.

User:

Desktop Shortcut. You can create a shortcut on your desktop to run a report in cView with one click. The shortcut just needs to call cView, a function easily accomplished by file association.
Ease of Use. View is easy to use. It is as simple as clicking a toolbar button, or using a menu to do a File/Open on a rpt file.
Interactive Reports. If a report uses parameters, cView will prompt the user with the questions and allow them to select answers from pick lists. cView supports all parameter types including multi-value, range, and multi-value/range.
One-click Print and Export. With one click of the toolbar, cView will print or export the report without requiring you to preview it first.
Output Flexibility. A viewed report can be exported to other formats including PDF, Excel, Word, XML, and csv. The results can be printed, emailed, or saved in a disk folder.
Report Instances. cView can create a instance of your report. This is a report with saved data that you want to archive or store for later viewing.
Set Print Date. You can set the print date prior to running a report so the reports process at a specific time. This is useful for running reports at another historical point in time.

View History, Folder and Instances. You can select a view of all the reports in a folder, the history of the last ten reports, or all the reports in the instances folder. Then you just select the report and can print, view, or export that report.

You do have other options for report distribution, besides those provided by Business Objects. See our Crystal Report schedulers and distribution tools, as well as our Crystal Reports viewers.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.