|
You can customize your data appearance on the list/view/print
pages using formatting options on the "View as" settings dialog. To control
the field appearance on the page click right button over the field
and choose Properties.
Depending on selected format you will see different
box-dialogs.
"View as"
settings
You can control the field appearance on the list page. Choose
between the following formats:
Short Date - dates will
be displayed in short format ( 02/17/2003 )
Long Date - dates will
be displayed in long format ( 17 February 2003 )
Time - datetime values
will be displayed as time ( 14:22:03 )
Currency - numeric
values like 14000 will be displayed as $14 000.00 ( actual
format depends on your system regional settings like currency
symbol, decimal symbol etc.)
Percent - Example: 0.38
will be displayed as 38%.
Hyperlink - choose this
format if you store hyperlinks in this database field. Those
hyperlinks will be made clickable automatically.
Email Hyperlink -
choose this format if you store email addresses in this database
field. It will be converted into mailto HTML code automatically.
File (available for
Text and Binary fields)
Depending on field type (text or binary field) you will be able
to choose either URL prefix to folder where files are located or
field name that stores filenames.
Here are some examples of URL prefix usage:
images/ - images folder is located in output directory
/images/ - images folder is located under website root
../images/ - images folder is located one level above
http://www.abc.com/images/ - full path to images folder
Note: in most cases URL prefix ends with forward slash.
Mercedes-Benz-CL-500.jpg will be automatically converted into
<img src="images/Mercedes-Benz-CL-500.jpg" border=0>
In case of Binary field you need to choose a field that stores
filename. This filename is required to set correct file type when
you retrieve uploaded file from the database. If you don't choose
filename field or leave it empty you will be presented with
Open with ... dialog every
time you download this file from the database.
Image (available for Text and Binary
fields)
Binary field
- if you store images in the database,
ASPRunner.NET creates a code that extracts images from database on
the fly. Supported image formats are JPEG, GIF and BMP. If
you want to display the thumbnail then you should select the
appropriate checkbox and choose the field name that holds the
thumbnail.
Text field - choose image
size and URL prefix similar to View as type File. If you want to display the
thumbnail then you should select the appropriate checkbox and
choose the thumbnail prefix. For example, if the original image
file's name is example.gif and thumbnail file's name is
th_example.gif correspondingly then the thumbnail prefix should
have the value of "th_".
If you want to display the images using iBox plugin check corresponding
checkbox.
More info about iBox
plugin here.
US phone number
- formats number as a US phone
number. Supports 7-digit or 10-digit numbers (123) 456-7890 or
123-4567
Number - choose this format if you like to format
this field as number. Two digits after decimal point
implied.
HTML - use this view type when you store formatted
HTML code in database field and wish to display this HTML code on
the list page.
Checkbox - use view
format to present field value as a checkbox. Works best with the
following datatypes:
MS
Access: Yes/No field
SQL
Server: TINYINT or BIT field
MySQL:
TINYINT
Oracle:
NUMBER(1)
|
