SQLEXP  is a function used by the program to generate reports which makes it possible to report information not available in the original RecordSet of a report. This way, you can include information from other tables and registers in reports for individual user reports.

Syntax:

SqlExp('<SQL stavek>')

Because the names of RecordSets and fields in the RecordSets could differ in each report, you must check the name of the RecordSets and fields for each concrete report.

 An Example of a Collective Invoice Created from the Collective Invoice of a Consignment Report

In the chapter on SQLEXP - Reporting Serial Numbers in a Collective Invoice, we saw an example of reporting linked serial numbers when a collective invoice is created directly from issue documents. We stressed that the report of the collective invoice or the overview of serial numbers does not give information about the received or issued serial numbers of items from the collective invoices because these serial numbers were already received or issued with an issue document.

But you can use the SQLEXP function to report a list of received or issued serial numbers (see Using SQLEXP Stamements in Reports).

It's a little different when you report werial numbers in a consignment supplier's collective invoice which you've created using a different collective invoice (see Consignment Reports) and not directly from the documents where the serial numbers were recorded. 

1. Create a new record from the report of an already existing report for an invoice. Add a new Field with Statement by clicking the icon:

2. In the Statement field, enter the SQL sentence:

SQLExp('exec dl_HE_PrtSerialNoKomOdjava ''' + tbIzpisPrometPoz.Kljuc + ''' , ' + tbIzpisPrometPoz.Poz)

This statement refers to the stored procedure dl_HE_PrtSerialNoKomOdjava, which is why it is somewhat shorter than the other examples for reporting serial numbers. In this example, a predefined stored procedure is useful. A different, user stored procedure could also be used.

Report:

1. Form

2. Example of a Report

From this example, you can see that serial numbers are reported one on top of another. The issued quantity for an individual serial number appears in parentheses.