====== Output ======

There are two outputs modes :
  * Interactive output: user actively run the query
  * Batch output: all queries of a directory are run

These two modes are set up separately. 

===== Interactive Output =====
==== Output types ====
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-110705.png?nolink}}

=== Result Grid ===
Most used output

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-110817.png?nolink}}

[[en:v8_0_0:designer:menus:accueil:nouvellerequete:grille|see dedicated page]]


=== Printer ===
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111025.png?nolink}}

=== Excel File ===

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111056.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111134.png?nolink}}\\ 

[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution:excel|See dedicated page.]]

=== PDF file ===

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111506.png?nolink}}

[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:editeurimpression:start|See dedicated page.]]

=== Text File ===
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111700.png?nolink}}

=== Email ===
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111729.png?nolink}}


<WRAP center round tip>
It is possible to use parameters to populate the list of recipients
</WRAP>
=== Export to database ===
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-111815.png?nolink}}

==== Output layout ====

When printing, for example in a PDF, you can choose one of two types of output formats: grid format or report.

=== Result Grid setup ===

When you choose the [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:restitution|interactive output]], click on ''Setup...''

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112226.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112254.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112333.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112353.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112412.png?nolink}}\\ 
{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112437.png?nolink}}\\ 

=== Report setup ===
[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:editeurimpression:start|{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-112546.png?nolink}}]]

[[:en:v8_0_0:designer:menus:accueil:nouvellerequete:editeurimpression:start|See dedicated page]]


===== Batch Output =====

The batch output mode has a separate setting from the interactive mode, but the setting fields are the same.


<WRAP round tip>
In atch mode, you can choose not to produce an output if there is no data.

This feature is heavily used in the case of consistency check queries (searching for clients without a G/L key). The scheduled query runs every x minutes looking for the anomaly and for example sends a mail if the result is positive.
</WRAP>

[[:en:v8_0_0:howto:schedule|See scheduler page]]

{{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200722-113107.png?nolink}}

All output types __except grid__ are available, as well as grid or report output formats.