Function SQL Exp
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.
Syntax
SQLExp('<SQL statement>')
Adding SQLExp onto report
Put text object onto report. Click on the object to open text editor. Write expression in the editor.
Save changes.
Report of the customer's address from the sales order
[SQLExp('select acAddress from tHE_SetSubj where acSubject = ' + dlQuotedStr(<qReportIzpisD."acConsignee">) + '')]