BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Formulas

Using the picture function

The Picture Function can be used within a formula to print a string “2065555555″ in a telephone number format “(206) 555-5555″, or to print other strings in fixed formats. If you are using a database field as the string, it will only work if the field is of a fixed and known length.

Note: You cannot use an asterisk as a wildcard in the picture argument. If you put an asterisk in the argument, it will show up as an asterisk in the resulting string.

Here is an example of what the picture function can be used for:

Picture({customer.FAX},”(xxx) xxx-xxxx” )

//Prints the values in the Fax field in the following format:

(805) 555-5555, (313) 555-2555, and so on.

Tagged ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



To undo the last change made, press Ctrl + Z. You can use Ctrl + Z multiple times to delete numerous changes made.