Nuclos report: single/collective output, Excel collective output, XLS template, run report, retrieval via URL /reports/.

Language: Deutsch · English

Reports

Complex evaluations as a report – output types, XLS templates and retrieval via URL.

On this page

What is a report?

Reports cover complex evaluations across several joined tables. The result is usually a tabular, possibly multi-page list – with headers/footers, column headings, grouping and arithmetic operations (e.g. sums).

Menu: Configuration → Report → Report

Output types

Single output: one output format to choose; all use the same data source (chosen in the general part).
Collective output: a separate data source per output format; on execution all are produced one after another.
Excel collective output: a special form; output is always XLS, all outputs go into different sheets of the same workbook (sheet name, template, target file).

Low-Code und Werkzeuge > Reporting Reports > report5.png

Report configuration (collective output).

The API cannot access Excel collective outputs – they are available on the client only.

XLS output format

Without a template a document with the sheet „Daten aus Nuclos“ is created. With a template Nuclos looks for the „Daten aus Nuclos“ sheet (or the name given in sheet name) and writes the data there – otherwise it is created.

Running & retrieving a report

The run reports action appears in the File menu if the user group has the „run report“ right. Template-based CSV/PDF reports can also be retrieved via URL:

<host>:<port>/<instance>/reports/<report-UID>/<output-format>.csv
http://localhost/nuclos/reports/<reportname>/<output-format>?parameter=value

Retrieval requires a login; the same permissions as in Nuclos apply.

Related pages

Report and form

Data source.

Open →

Forms

Forms.

Open →

Working with Jasper Studio

Design templates.

Open →