Partners
PHP Generator for MySQL online Help
| Prev | Return to chapter overview | Next |
View properties
This options group allows you to define the way the column data to be represented on the List, View, Print and Export pages.
Display properties
Select the type of data representation. By default, the format of the column's data is the same as it is set at the Project options. To change the format of column data or/and set such additional options of the representation like text alignment, height and width of images, and others, use the corresponding dialog opened by the ellipsis button next to the Display properties. Moreover, along with representation properties available for editing within this dialog you can define your own properties with the Custom attributes option. The option allows you to specify the content of standard HTML style tag. For example, to set the background color of the column, enter style="background-color:yellow" as Custom attributes. To implement more difficult data representation, especially for conditional data formatting, it's recommended to use the OnExtendedCustomDrawRow event.
Available representations |
Additional options |
Result |
Text |
It's possible to set such style attributes as text alignment, and font options (bold, italic). The Max length value is the max number of signs to be visible on the generated webpage. You can also allow to replace CR+LF by <BR>, to use HTML and Word wrapping and specify several format options to be applied to the column data depending of data type (Number, Percent, String, Currency).
|
|
DateTime |
Select the type of date time format. |
|
Image |
If BLOB data will be represented as images, specify the size of all the column images with Resize type and Height and Width fields. Image hints are set with templates. |
|
File download |
If BLOB data will be represented as file downloads, set a Download file name and a Content type using templates. The Content type value is optional. To change the download image, generate the project and change the download.gif file in the images folder. |
|
Checkbox |
There are three display types of boolean data: check box controls, custom images, custom text values. Select the necessary option and specify the custom information (TRUE/FALSE captions or images). |
|
External file, External image |
To represent data in such a way, specify the Source prefix and Source suffix.
Example Suppose there is a 'product' column with such data: firebird_maestro, sqlite_maestro,
There are image files with the following paths: D:\Images\firebird_maestro_62x62.jpg D:\Images\sqlite_maestro_62x62.jpg
To represent these images at the 'product' column on the generated page, Select External Image as View Properties and set Source prefix=D:\Images\ Source suffix=_62x62.jpg |
|
Display as hyperlink
To represent the column's data as hyperlink, check the Display as hyperlink option and specify the HREF Template. Target controls where the new document is displayed when a user follows the link.
_blank |
opens the new document in a new window. |
_parent |
is used in the situation where a frameset file is nested inside another frameset file. A link in one of the inner frameset documents which uses "_parent" will load the new document where the inner frameset file had been. |
_self |
puts the new document in the same window and frame as the current document. "_self" works the same as if you had not used TARGET at all. |
_top |
loads the linked document in the topmost frame... that is, the new page fills the entire window. |
Use the Header hint field to specify the the column caption's hint. By default, it is a comment to the table/view column.
Fixed column width
To set a fixed width of the grid, check the Fixed width, specify the Width, and select the Units.
Units |
Meaning |
em |
The 'font-size' of the relevant font. |
px |
(pixels) Relative to the viewing device. |
in |
(inches) 1 inch is equal to 2.54 centimeters. |
cm |
Centimeters |
mm |
Millimeters |
pt |
(points) The points used by CSS 2.1 are equal to 1/72nd of an inch. |
pc |
(picas) 1 pica is equal to 12 points. |
The Totals option allows you to enable a grid footer to display summaries (Sum, Average, Count, etc) for all or selected grid columns.
| Prev | Return to chapter overview | Next |
