meta data for this page
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:v8_0_0:designer:menus:accueil:nouvellerequete:champs [2020/07/09 13:49] jacobt created |
en:v8_0_0:designer:menus:accueil:nouvellerequete:champs [2020/07/09 14:56] (current) jacobt [At the cell level] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Field Selection ====== | ====== Field Selection ====== | ||
| - | {{:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200707-143353.png?nolink&650}} | + | {{:en:v8_0_0:designer:menus:accueil:nouvellerequete:pasted:20200709-135440.png?nolink&650}} |
| This screen displays a list of all fields displayed, whether they come from a table, a field in a subquery, or a calculated field (operation, see [[:en:v8_0_0:opmanage:start|OPManage]]). | This screen displays a list of all fields displayed, whether they come from a table, a field in a subquery, or a calculated field (operation, see [[:en:v8_0_0:opmanage:start|OPManage]]). | ||
| 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 === | ||