Crystal Reports for Eclipse Designer Guide

Format Strings

The ToText and CStr functions can use format strings to control how the Number, Currency, Date, Time, or DateTime value passed to the x argument will appear when converted to a String. This section describes how to create format strings for the various data types.
Format strings for fractional Numbers and Currency values
The following characters are used to create format strings for fractional Numbers and Currency values:
Character
Description
Comments/Examples
#
Represents numerical digits or spaces.
When the original number is converted, # characters are ignored unless the number of # characters in the format string extends beyond the number of significant digits in the original value. Then, for every additional # that appears, a space is added to the string.
If your original value is 125.34:
0
Represents numerical digits or zeros (0).
When the original number is converted, 0 characters are ignored unless the number of 0 characters in the format string extends beyond the number of significant digits in the original value. Then, for every additional 0 that appears, a zero is added to the string.
If your original value is 125.34:
comma (,)
Indicates where a thousands separator should appear.
The actual character that appears as a thousands separator in the resulting string can be changed.
decimal point (.)
Indicates where a decimal separator should appear.
The actual character that appears as a decimal separator in the resulting string can be changed.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/