: Cell Background Image

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Editing Permissions

Allow New Record Creation

Requires Table data is saved to and Primary Key of table to be set

Allow Record Editing

Requires Data Save Table and Primary Key to be set

Edit Multiple Records

Requires Table data is saved to and Primary Key of table to be set and Child Editor in Detail Grid turned off

Allow Record Deletes

Requires Table data is saved to and Primary Key of table to be set

Locking

Enter name of global variable holding user id
Redirect back on lock

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Display

Show Menu

Group Descending Hide Group Band Display this Field as Group

Group Rows Until Column

Show Details & RecNo

Child Editor in Detail Grid

Requires Table data is saved to and Primary Key of table to be set

Number of Columns:

Table Width 100%

Table/Cell Borders

Normal borders Flat style Flat style with frames

Allow Sorting

Show Column Headers

Snaking Columns

(eg. 3^2) Widths: (eg. 25%^20%) Mode:

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Date Formats

Captions

Filter Form Caption

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Store template file in applet/templates directory, and enter the file name below (leave out directory path)

Templates

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

To modify titles of individual columns, Go Back to Grid and click on white "e" icons next to column titles.

Title Levels (Field^ColWidth^Title^Color;)

Title Level 1

Title Level 2

Title Level 3

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Menus

Hide Menus

Hide Top and Bottom Menu	Hide Top Menu	Hide Bottom Menu
Hide Scrolling	Hide Scroll to End	Hide Filter/Search
Hide Sort Form

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Graph

Show Graph

Choose columns to graph

Image Width

Height

Graph Type

Bar Horizontal Bar Stacked Bar Line Pie

Data Series

Data series is stored in individual records

Background Colors

Color Gradient

Show Values

Title

X-Axis

Y-Axis

Scale

Image Map URL

(Only for bar charts)

Margins

Left Right Top Bottom

Axis Labels

Swap because values are negative

Cancel You can modify settings in multiple tabs before saving.

PHPLens: 4.9.2 Data: 0.02 DB: mysql adodb: 4.62 Compat: 2 PHP: 5.2.17 OS: Linux
License Type: Enterprise ID: (Natsoft;John Lim;jlim@natsoft.com) Valid Till: Never Expires

Notes

Set the color and background image of the column titles with the colorTitle property. The image is set to background=/php/phplens/img/granblue.gif (picture on right). Internally, the code generates the following:
<TD bgcolor=white background=/php/phplens/img/granblue.gif>

Set the color and background image of the data cells with the colorLens property. The image is set to /php/phplens/img/swirl.gif (picture on right). You can also have different images for each column.

More Examples: View Source: Cell Background Image

Free Download

Notes