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>

GET SOCIAL

QUICK TIP

When in the formula editor, Start out by typing the first charter of the function, press Ctrl-Space. The keyword auto complete will than show a list of the functions available beginning with the charter you typed in.

ADVERTISMENT