Products Navigation

Advanced Excel Report

• choose your database tool
•  
• SQL Studio
• SQL Studio for MySQL
• SQL Studio for PostgreSQL
• SQL Studio for SQL Server
• SQL Studio for IB/FB
• SQL Studio for Oracle
•  
• MySQL Tools
• SQL Studio for MySQL
• SQL Manager for MySQL
• Data Export for MySQL
• Data Import for MySQL
• Data Pump for MySQL
• Data Generator for MySQL
• Data Comparer for MySQL
• DB Comparer for MySQL
• DB Extract for MySQL
• SQL Query for MySQL
•  
• SQL Server Tools
• SQL Studio for SQL Server
• SQL Manager for SQL Server
• Data Export for SQL Server
• Data Import for SQL Server
• Data Pump for SQL Server
• Data Generator for SQL Server
• Data Comparer for SQL Server
• DB Comparer for SQL Server
• DB Extract for SQL Server
• SQL Query for SQL Server
•  
• PostgreSQL Tools
• SQL Studio for PostgreSQL
• SQL Manager for PostgreSQL
• Data Export for PostgreSQL
• Data Import for PostgreSQL
• Data Pump for PostgreSQL
• Data Generator for PostgreSQL
• Data Comparer for PostgreSQL
• DB Comparer for PostgreSQL
• DB Extract for PostgreSQL
• SQL Query for PostgreSQL
•  
• InterBase / Firebird SQL Tools
• SQL Studio for IB/FB
• SQL Manager for IB/FB
• Data Export for IB/FB
• Data Import for IB/FB
• Data Pump for IB/FB
• Data Generator for IB/FB
• Data Comparer for IB/FB
• DB Comparer for IB/FB
• DB Extract for IB/FB
• SQL Query for IB/FB
•  
• Oracle Tools
• SQL Studio for Oracle
• SQL Manager for Oracle
• Data Export for Oracle
• Data Import for Oracle
• Data Pump for Oracle
• Data Generator for Oracle
• Data Comparer for Oracle
• DB Comparer for Oracle
• DB Extract for Oracle
• SQL Query for Oracle
•  
• DB2 SQL Tools
• SQL Manager for DB2
• Data Export for DB2
• Data Import for DB2
• Data Pump for DB2
• SQL Query for DB2
• Data Generator for DB2
• DB Extract for DB2
•  
• Tools&Components
• Advanced Data Export VCL
• Advanced Data Export .NET
• Advanced Data Import VCL
• Advanced PDF Generator
• Advanced Query Builder
• Advanced Excel Report
• Advanced Localizer
• Source Rescuer
•  

Our Partnership Status

OnCalcExpression

Example

Applies to

TEXLReportGroupHeaderBand object

Declaration

property OnCalcExpression: TEXLReportCalcExpressionEvent;

TEXLReportCalcExpressionEvent = procedure(Sender: TEXLReportBand; var GroupValue: String) of object;

Description

Use the OnCalcExpression event to set grouping by some expression value. This event takes place before writing each data row to the report. Data are grouped by the output parameter GroupValue.

See also:

FieldName property