Open topic with navigation

Grid - Overview

Grid applications

Grid applications are powerful information analysis resource. Grid applications display data retrieved from a database using a SELECT statement. The displayed information is organized in a grid layout.

The grid applications generated are complete web reports with the following functionality:

Feature Description
Search
Search form associated to the grid. Use the search page to filter the displayed data.
Paging
Define the number of rows to display per page and page navigation.
Data Exporting
Generated grids can export data to many formats : RTF, XML, XLS and CSV.
Groups
In one click is possible to create break down lines and group data by N levels or fields.
Totals
Summarize columns using different functions such as: SUM , AVG , MAX , MIN.
Summary
Display a summary page based on groups and totals, displaying only the summary data.
Charts
Charts based on grid´s data can be displayed in different styles like: Bars, Columns, Pie , Dots and more
Sorting
Single sort is automatically created on reports columns header, cascade sort is also available at run time.
Fields selection
The end user can select at runtime which columns to display in the grid.
Printing options
Print the generated reports in PDF- or HTML-formats.
Links creation
Create links to other applications.
Events programming
Customize grid events PHP code, used to create calculated fields, business rules, etc.
Data formatting

Format the grid data, field types such as: date , currency , decimal values, integer values, images, text. Automatic data formatting can also be integrated to the regional settings.

 

 


Image1: Simple grid application running.


Image2: Grid application using group and total.


Image3: Grid's Search