Using SQLEXP Expressions in Reports

SQLEXP is a function that allows you to access data that is otherwise not available in the orignal dataset of a report.

This way you can include data from other tables into user-defined reports.

SQLEXP is a function used by the Report Designer.

Syntax

SqlExp('<SQL statement>')

Because names of recordsets and recordset fields may be different in each report, check the names before writing SQL statements.

Usage

Add a new "Field with Expression" to the report by clicking the Expression button .

Enter an expression into the first field.

The expression may not exceed 255 characters. If you need a longer expression, user stored procedures. See SQLEXP - Showing serial number in consolidated invoices for consignors for such an example.

Examples

• SQLEXP - Customer Address in the Sales Order Report
• SQLEXP - Showing Serial Numbers in Consolidated Invoices
• SQLEXP - Showing Serial Numbers in Consolidated Invoices for Consignment
• SQLEXP - Showing Serial Numbers in Consolidated Invoices of Consignors