meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:v8_0_0:designer:menus:accueil:nouvellerequete:champs [2020/07/09 14:09] jacobt |
en:v8_0_0:designer:menus:accueil:nouvellerequete:champs [2020/07/09 14:56] (current) jacobt [At the cell level] |
||
---|---|---|---|
Line 20: | Line 20: | ||
The wizard allows you to browse the query tables to select the fields to be returned. | The wizard allows you to browse the query tables to select the fields to be returned. | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-175840.png?nolink&450}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-141045.png?nolink&450}} |
An additional tab allows you to add calculated fields to the output, either operation on the fields or fixed values: | An additional tab allows you to add calculated fields to the output, either operation on the fields or fixed values: | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-180211.png?nolink&450}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-141136.png?nolink&450}} |
Use the right-hand arrows to change the order of the fields. | Use the right-hand arrows to change the order of the fields. | ||
Line 54: | Line 54: | ||
==== Formatting ==== | ==== Formatting ==== | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-180438.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-141327.png?nolink&400}} |
=== At the line level === | === At the line level === | ||
One or more conditional formats can be applied to a rendered line. All the columns of a row that satisfies the criterion will be formatted in this way. | One or more conditional formats can be applied to a rendered line. All the columns of a row that satisfies the criterion will be formatted in this way. | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-150110.png?nolink&550}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-141550.png?nolink&550}} |
=== At the cell level === | === At the cell level === | ||
Line 66: | Line 66: | ||
The dialog screens are similar to those at the row level, except that if the field has automatic descriptions, a first dialog window proposes to apply the formatting not only to the field itself but also to its descriptions. | The dialog screens are similar to those at the row level, except that if the field has automatic descriptions, a first dialog window proposes to apply the formatting not only to the field itself but also to its descriptions. | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-150755.png?nolink}} | + | == Data Format == |
+ | When you press the button ''Data Format'', if this field has associated labels (JDE/World only), then a first dialog box asks if the formatting concerns : | ||
+ | * the field itself | ||
+ | * the associated description 1 | ||
+ | * the associated description 2 | ||
- | == Data Format == | + | <WRAP round important> |
+ | This window is not displayed if there is no associated description. | ||
+ | </WRAP> | ||
+ | |||
+ | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-141907.png?nolink&600}} | ||
Here you can finely manage case and space management | Here you can finely manage case and space management | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200615-180607.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-144751.png?nolink&400}} |
The following values are possible for case: | The following values are possible for case: | ||
Line 96: | Line 104: | ||
* use the add button to choose a field among the tables, subqueries or calculated fields | * use the add button to choose a field among the tables, subqueries or calculated fields | ||
* Select a field already present in the list ''Fields to edit'' and click on the button ''A+Z↓''. | * Select a field already present in the list ''Fields to edit'' and click on the button ''A+Z↓''. | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-151429.png?nolink&500}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-142748.png?nolink&550}} |
The green-up or blue down arrow indicates whether the sort on this field is ascending or descending. | The green-up or blue down arrow indicates whether the sort on this field is ascending or descending. | ||
Line 107: | Line 115: | ||
- | ==== Breakup ==== | + | ==== Level Break ==== |
- | The button ''Break'' allows you to specify whether or not a sort field is also a broken field. | + | The button ''Level break'' allows you to specify whether or not a sort field is also a broken field. |
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-154403.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-144948.png?nolink&400}} |
=== Description === | === Description === | ||
Line 117: | Line 125: | ||
The Description is what will be displayed on the report at the time of the break. This title can be formatted (see [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs#Format de données|Data format]]) | The Description is what will be displayed on the report at the time of the break. This title can be formatted (see [[:en:v8_0_0:designer:menus:accueil:nouvellerequete:champs#Format de données|Data format]]) | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-154520.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-145126.png?nolink&400}} |
=== Breakup Results === | === Breakup Results === | ||
Line 125: | Line 133: | ||
For each operator, there is a list of fields on the right where the operation can be applied. | For each operator, there is a list of fields on the right where the operation can be applied. | ||
- | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200618-155208.png?nolink}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-145251.png?nolink&400}} |
=== Conditional Breakline Shaping === | === Conditional Breakline Shaping === |