Bitmap

Description

Displays the specified image file.

For computed fields only

You can use the Bitmap function only in a computed field.

Syntax

Bitmap ( string )

Argument

Description

string

A column containing the image files, a string containing the name or URL of an image file (a BMP, GIF, JPEG, RLE, or WMF file), or an expression that evaluates to a string containing the name or URL of an image file


Return value

The special datatype bitmap, which cannot be used in any other function.

Usage

Use Bitmap to dynamically display an image file in a computed field. When string is a column containing image files, a different image can display for each row.

Examples

These examples are all expressions for a computed field.

This expression dynamically displays the image file contained in the column named employees:

Bitmap(employees)

If the employees column is column 3, this next expression gives the same result as the expression above:

Bitmap(#3)

This expression displays the tools.bmp file:

Bitmap("TOOLS.BMP")

This expression displays the tools.jpg file through an URL address:

Bitmap("http://172.16.5.175/tools.jpg")

If the image file has no file extension, the method will check whether the file is a valid image file (a BMP, GIF, JPEG, RLE, or WMF file). For example, this expression displays the person file if it is a valid image file.

Bitmap("E:\images\person")

This expression tests the value in the column named password and then uses the value to determine which image to display:

Bitmap(If(password = "y", "yes.bmp", "no.bmp"))

See also

Example 3: creating a row indicator