|
This section introduces Ontimize Grids which is a facility that allows users to maximise their data arrangement in the form of powerful customized tables which can be embedded in your Ontimize based software products..
Ontimize Grids makes it easy to create tables and grids with many records. It wraps your data and provides automatically all the markup data which normally you would have to add yourself. The data grid can help address concerns of data manipulation with large data sets by providing features like sorting, filtering, searching, pagination and even in-line editing for your tables. Moreover, Ontimize Grids has several utility functions and tools that you can use individually or in any combination, and adds support for interchangeable toolbars like sortable headers, filters, pagers, etc.
[As usual, click on images to zoom in]
Some of the technical features included with the grid are: • Sorting and order: Turn a standard grid into a sortable Ontimize grid, sorting multiple columns simultaneously by clicking one header and clicking a second, third or more column headers! • Advanced Filters: Ontimize provides you very simple ways to improve the views of all your tables with a search/filter function. QuickFilter allows user to enter a term and only the grid entries which contain it will be shown. Other advanced filters can match whatever pattern in whatever way the users want. • Resize: From time to time, you may stumble upon a large grid without any layout facilities. This Ontimize table feature can resize columns in the table adapting them to your requirements and hide columns which do not provide you relevant information, reusing that space for what you consider more important information • Grouping: Highly useful features are the key for successful data management to function optimally. Thanks to the Ontimize table grouping functionality, every data point you collect is categorized by your criteria allowing multiple-grouping to tabulate your outcomes. • DetailForm: Tables focus on things that users have found very useful or interesting, but sometimes more detailed information is needed. If configured, when double-clicked a detailed breakdown of the selected row can be shown with all the additional data related with that entry.
• Copy to clipboard: This table facility can be used by Ontimize users for short-term data storage and/or data transfer between single or multiple cells of the Ontimize table and applications or documents, via simple copy and paste operations, sending your data from one operating environment to another easily. • Export to Excel: Nearly every user needs to export data to an Excel-compatible format at one point or another to work with in other environments. Thanks to this Ontimize table facility users can download the data from the datagrid into an Excel spreadsheet for offline verification and/or computation. • Export to HTML: Sometimes we have the challenge of reporting our data in an HTML-compatible format. For that reason, the export to HTML button was created, which is actually very popular and useful. HTML Export table button allows you to take your grid data and export it to HTML. • Print grid: Transfer your data from the applications table to any popular format for web and paper to manage and distribute your reports to any destination in print form or via email. • Load and save layout: Ontimize users can configure the most useful layouts of their reports customizing them depending on their preferences of size, column order, visible columns, and so on. Moreover they can also save these layouts and load them back into the tables later. • Refresh: This button allow users to read the database information and immediately rewrite the information in the table. • Custom charts: Use the Ontimize computing power to produce unified table charts and graphics in many human readable formats. A wide array of formatting options to manage data is provided to allow presentation in the most relevant format. • Choose visible columns: This Ontimize table feature can hide columns in the table using the table button, and checking the required fields in the opened window. • Custom reports: A powerful yet simple to use commercial report manager, writer and analyzer is included with Ontimize applications. Ontimize reporting tools enable businesses to provide instant access to their information at all levels. • Total row configuration: Automate your work by selecting this operation to add an additional row which shows the result of some mathematical operation for numeric columns, such as the sum of all the entries in one selected table column. • Calculated columns: You can also automate your work when row operations are required, using the calculated columns facility. It adds prebuilt dynamic columns which perform operations on another table's columns, row by row. So, users are able to see real-time operation to calculate percentages of each row, get ratios, drop several rows, ... • Pivot table: Get very quick reports of your grid data by clicking the pivot table button, creating cross tables, sorting, counting, … thanks to the Ontimize business intelligence embedded in Ontimize grids. • Paging: Use the Ontimize paging table to avoid downloading all the data at the same time, allowing partial downloads so that clients can work on datasets without overtly stressing the network. This Ontimize table facility allows you very fast client-side processing, even on slower machines, involving large amounts of data. Moreover, all registers can be downloaded when desired. • Auto-insert table: Ontimize is dedicated to bringing you the information and tools you need to be successful in your work. In order to be quick and comfortable, Ontimize table includes an option to be able to fill your database with new entries filling the values in the same table that you want to check them. • Mixes: Of course Ontimize users may combine any of the aforementioned features together. • Renders: Ontimize grids will auto-detect most data types including numbers, dates, pictures, currencies, ...
The Ontimize wiki describes the techniques used for coloring table component's cells, using ToolTips, performing actions from the keyboard, changing table colors, formats and layouts, allowing multiple or single selection, adding custom operations from the right-click table menu, and so on ...
TRY
You can test the various grid features in the Ontimize QuickStart Demo. (user: "demo" password: "demouser")
</title> <meta name="GENERATOR" content="OpenOffice.org 3.0 (Win32)" /> <mce:style type="text/css"><!-- <! @page { margin: 2cm } P { margin-bottom: 0.21cm } > --></mce:style><style type="text/css" mce_bogus="1"> <! @page { margin: 2cm } P { margin-b
TECHNICAL FEATURES
Ontimize grid is a lightweight but rich and highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls. Here, we will take a look at some of the most popular Ontimize Grid features available:
• The Ontimize grid allows you to display your data in a simple and flexible way. It lets you implement nice looking tables and supports resizable columns, multi-sortable columns, drag- and dropable columns, scrollable columns, etc. Moreover, it also supports continuous-width layouts as well as preset fixed-width layouts and the ability to easily customize to any number.
• Ontimize table offers full integration support based on whatever data types from different databases.
• Flexible in response to user initiated font-size adjustments, although default layouts are also automatically given out.
• Focuses on simplicity: only a few lines of code are required to get your first table up and running.
• Defined in XML and Written in java, the Ontimize table is also easy-to-extend for adding custom features.
• Automatically populated with all the benefits of the JAVA tables, such us, single or multiple selection, cell selection, etc ...
• Aimed at turning basic software tables into advanced editable components with built-in inline editing, on-the-fly filtering, even in-line editing, sorting, searching, paging and grouping capabilities, and so on ...
• The Ontimize grid also has intelligent natural sorting capabilities and graphical user interfaces to get them.
• Moreover, as explained above, several datagrid behaviors are included in the Ontimize grid, such as: Copy to clipboard, Export to Excel, Export to HTML, Print grid, Load and save layout, Refresh, Custom charts, Choose visible columns, Custom reports, Total row configuration, Calculated columns, Pivot table, and so on ...
• Easy to populate with well-known detailed breakdowns of the selected row to be more precise in your applications.
• Powerful, inmediate response and easy-to-use Ontimize GUI which improves the default software application interfaces which is not as intuitive and responsive as a typical modern user requires.
• As normal for all Ontimize advanced components, it supports a full integration with Ontimize itself therefore provideing all the Ontimize advantages, such us, simplifying content creation using templates and wizards, easily creating your own screens, reporting utilities for process monitoring, and so on.
WATCH
|