Use options from tab "Miscellaneous".


In section "Module options" can to use some jqGrid and Module adjustments.

Module Caption - [ Here can to change jqGrid caption ]
Add table info? - [ Add to caption linked table name with its unique field name, used mostly for special or debug reasons ]
Grid width options - [ Define jqGrid width using following options:

Set width - [in available below text box] - set explicit width and height in below fields
Set auto width - set auto width adjustment - equivalent to css auto
No set width - width cover all available to expand area - 100% width equivalent to css]
Module Width - [ Set via this control grid width if "Grid width options" is set to "Set width" selection ]
Module Height - [ Set initial height of module ]
Configurator Width - [ Set Configurator width ]
Configurator Height - [ Set Configurator height ]
Enable alternate rows - [ Enable alternate rows background which are set in respective controls for odd and even rows backgrounds, placed below ]
Odd rows background - [ Set Odd rows background color ]
Even rows background - [ Set Even rows background color ]
Enable rows coloring - [ Enable rows coloring to set All rows text color and background color ]
Rows text color - [ Set rows textcolor ]
Rows background color - [ Set rows background color ]

In section "Run a SQL" can to run a SQL ageinst linked database.

Run a SQL - [ Place in respective text box your SQL and submit by below placed button ]

In section "Some PDF options" can to configure some parameters of PDF file of exported data.

Enable header - [ Set enable header:
Above of grid table will be displayed header with the info which you can to provide from this section. ]
Orientation - [ Set paper orientation and available options are Portrait and Landscape - by default is set Portrait orientation ]
Margin top - [ Set Margin top ]
Logo - [ Set Logo image ]
Logo width - [ Set Logo image width ]
Header title - [ Set Header title ]
Header subtitle - [ Set Header subtitle ]
Creator - [ Set Creator ]
Author - [ Set Author ]
Title - [ Set Title ]
Keywords - [ Set desirable KeywordsSet desirable Keywords ]
Subject - [ Set Subject ]
Alternate rows - [ Enable Alternate rows ]

And here jqGrid with some "Grid width options" used, listed below:

Basically, in this case, grid rectangle dimentions are hard coded and set to 714 X 217
From section "More options":
Module Caption
Add table info?
Grid width options (Set width - 714 X 217)
Module Width
Module Height
Enable alternate rows
Odd rows background
Even rows background

From "Grid options part 2" tab and section "Themes"
Themes
Current Theme (Humanity style)


jqGrid with "Grid width options" set to "Set auto width", and rest listed below:

From section "More options":
Module Caption
Grid width options (Set auto width)
Module Width
Module Height
Enable alternate rows
Odd rows background
Even rows background

From "Grid options part 2" tab and section "Themes"
Themes
Current Theme (Le-frog style)


jqGrid with "Grid width options" set to "No set width", and rest listed below:

From section "More options":
Module Caption
Grid width options (No set width)
Module Width
Module Height
Enable alternate rows
Odd rows background
Even rows background

From "Grid options part 2" tab and section "Themes"
Themes
Current Theme (Excite-bike style)


  • t0
  • t1
  • t2
  • t3

In next article we will continue module setup with tab "Miscellaneous".

Previus article - Grid options part 1.

Create an account
v 4