Nuclos transfer data source: SQL from designer, edit statement, $intid, delete schema name, preview, Report and form.

Language: Deutsch · English

Transferring a data source to Nuclos

Move SQL from the Jaspersoft designer into the Nuclos data source editor – incl. parameter and schema adjustments.

Auf dieser Seite

Transfer a designer data source to Nuclos

A data source created in the designer must be transferred to the Nuclos data source editor (Configuration → Data sources → Report and form).

Create a new data source and set name + description (mandatory).
In the SQL tab click edit statement and paste the query from the designer.
Create a parameter for filtering. Syntax: $intid (integer), '$Date' / '$String' (date/text).
Delete the schema name – needed in the designer, not in Nuclos.
Check the syntax via the test icon, then save.

Transferred data source in the Nuclos editor.

Test the data source functionally in the preview tab (set the $intid parameter to a value).

In the designer.

Nuclos data source.