- Summary Values
/documentation/pages/Guides/Mobile and Web Components/Grid/Grid Fields/Grid Field Properties/Summary Values/index.xml
Summary values display various types of information about a field as it appears throughout the entire table.
- Compute summary Values
/documentation/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/List Properties/listprops/Fields/Server-side/Compute summary values.xml
Computing summary values on the server-side.
For List controls that are based on SQL data, you can specify that summary data (e.g. total, avg, count, min and max - total and avg are only available for numeric fields) should be computed for certain columns in the List control.
- Grid Fields
/documentation/pages/Guides/Mobile and Web Components/Grid/Grid Fields/index.xml
The Grid Fields page is where you define what fields you will use in your grid, insert special controls, and set properties for individual controls.
- Grid Fields
A rundown of options for creating and manipulating grid fields in the Grid Component builder.
- The Grid Component
/documentation/pages/Guides/Mobile and Web Components/Grid/index.xml
Guides on how to use the grid builder, grid properties and features, example pages, and more.
- Grid Component Capabilities
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component Capabilities.xml
Web publishing applications only. A grid component displays reads from and writes to your database and displays the data in a web page. The Grid Builder is a genie that you use to create grid components.
The HTML Editor allows you to place grid components into A5W pages (an A5W page is a hybrid HTML/Xbasic page that is processed by the Application Server ).
Grids have many optional capabilities that you can enable or disable through menus. Many properties of a new grid component have default properties. If you wish, you can set different default property values.
- Grid Component SQL Database Credentials
/documentation/pages/Server/Guide/Design/View/Grid/Grid Component/Grid Component SQL Database Credentials.xml
By default all users who use a Grid component connect to the SQL database using the same credentials. These credentials are defined in the a5_application.a5i file which is automatically published when your application is published. The a5_application.a5i file defines how each named connection string in your application should be resolved at runtime.
- Creating a Grid Component - Tutorial
/documentation/pages/Guides/Mobile and Web Components/Grid/Introducing the Grid Builder/Tutorials/Creating a Grid Component - Tutorial.xml
Covers a range of topics including selecting a database, creating a grid component, selecting data to use and display in the component, and how to view the component in a browser.
- Sorting a Grid on Multiple Fields
/documentation/pages/Server/Guide/Design/View/Grid/Sorting a Grid on Multiple Fields.xml
The default behavior of a grid component allows the user to sort on any column (or row) value by clicking the column (or row) header. What do you do when you want to sort on multiple fields? This example demonstrates a technique.
This page contains two components: a dialog with a drop down list box and a grid displaying fields from the AlphaSports sample database.
- Ordering Lookup Entries - Grid Component
/documentation/pages/Server/Guide/Design/View/Grid/Ordering Lookup Entries - Grid Component.xml
Often you will want to display a list of values selected from a table. It is often desirable to specifically order these entries, instead of allowing them to display in record order or alphabetically.
Here is a technique for solving this problem. This example uses a drop down list box on a dialog component, but the technique works equally well with a list box on a grid component.