User Tools
en:handbuch:kapitel_3:3.6._fortsetzung_3
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:handbuch:kapitel_3:3.6._fortsetzung_3 [2009/12/08 13:24] admin |
en:handbuch:kapitel_3:3.6._fortsetzung_3 [2019/10/25 14:11] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | [[|{{|previous}}]] [[handbuch:handbuch|{{|Home}}]] [[|{{|next}}]] | + | [[|{{|previous}}]] [[en:handbuch:handbuch|{{|Home}}]] [[|{{|next}}]] |
| - | ====== 3.06 Reportgenerator "ReportMaker" (Fortsetzung) ====== | + | ====== 3.06 Reportgenerator "ReportMaker" (continued 3) ====== |
| - | ===== Functions of the ReportDesigners (continued) ===== | + | ===== Functions of the ReportDesigners ===== |
| Next, the field 'status' is loaded and rearranged. | Next, the field 'status' is loaded and rearranged. | ||
| Line 13: | Line 13: | ||
| The comparison operators and the operand can be adjusted in the field "Compare" in the format dialog. The values can either be implemented textual (TEXT) or by color (foreground or background color). | The comparison operators and the operand can be adjusted in the field "Compare" in the format dialog. The values can either be implemented textual (TEXT) or by color (foreground or background color). | ||
| - | {{:handbuch:kapitel_3:3-295.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker51.jpg|}} |
| The following comparison operators are currently supported: | The following comparison operators are currently supported: | ||
| Line 21: | Line 21: | ||
| | **1** | **!=** | Check field content for inequality | | | **1** | **!=** | Check field content for inequality | | ||
| | **2** | ***~** | Check, whether the field content ends with the value | | | **2** | ***~** | Check, whether the field content ends with the value | | ||
| - | | **3** | **<** | Check, whether field content is smaller than the value | | + | | **3** | **>** | Check, whether field content is greater than the value | |
| - | | **4** | **<=** | Check, whether field content is smaller or equal to the value | | + | | **4** | ** >=** | Check, whether field content is greater or equal to the value | |
| - | | **5** | **=** | Check field content to equality | | + | | **5** | **=** | Check field content for equality | |
| | **6** | **<** | Check, whether field content is smaller than the value | | | **6** | **<** | Check, whether field content is smaller than the value | | ||
| - | | **7** | **<=** | Check, whether field content is smaller or equal to the value | | + | | **7** | **< =** | Check, whether field content is smaller or equal to the value | |
| | **8** | **contains** | Field contains a multiple selection | | | **8** | **contains** | Field contains a multiple selection | | ||
| | **9** | **~** | Check, whether field content contains the value | | | **9** | **~** | Check, whether field content contains the value | | ||
| | **10** | **~*** | Check, whether the field content starts with the value | | | **10** | **~*** | Check, whether the field content starts with the value | | ||
| - | The example for the field 'status' the value "active" (internal active) with yellow background is realized and the value "passive" (internal passive) with red background color. | + | In the example for the field 'status', the value "active" (internal active) is assigned a yellow background and the value "passive" (internal passive) with red background color. |
| - | {{:handbuch:kapitel_3:3-296.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker52.jpg|}} |
| The desired color can be selected from the ... | The desired color can be selected from the ... | ||
| - | {{:handbuch:kapitel_3:3-297.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker53.jpg|}} |
| ... the color palette ... | ... the color palette ... | ||
| - | {{:handbuch:kapitel_3:3-298.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker54.jpg|}} |
| - | ... and related (here for active and passive). | + | ... and assigned (here for active and passive). |
| - | {{:handbuch:kapitel_3:3-299.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker56.jpg|}} |
| - | All status information, which include the value "Live" will be implemented with a green background color (all projects, which are completed). | + | All status information, which include the value "Live" will be assigned with a green background color (all projects, which are completed). |
| - | {{:handbuch:kapitel_3:3-300.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker57.jpg|}} |
| - | After saving and closing the dialog, dialog can be done using the action "Show preview" of the ... | + | After saving and closing the dialog, the report can be performed ... |
| - | {{:handbuch:kapitel_3:3-301.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker58.jpg|}} |
| - | ... Report. | + | ... using the action "Show preview". |
| - | {{:handbuch:kapitel_3:3-302.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker55.jpg|}} |
| - | Afterwards some fields are rearranged in the report and by using of functionality {{:handbuch:kapitel_3:ok.gif?nolink}} a formula is defined. The new column 13 should be the result (residual value) from the difference in the offer value and the invoice amount and should be added up. | + | Afterwards some fields are rearranged in the report and by using the functionality {{:handbuch:kapitel_3:more.gif?nolink}} a formula is defined. The new column 14 should be the result (residual value) from the difference of the offer value and the invoice amount and also output the sum. |
| - | {{:handbuch:kapitel_3:3-303.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker59.jpg|}} |
| - | The two intermediate results (column 11 and 12) should not be listed in the report, therefore in these values can these values, the check boxes can be set "visibly" to false (not marked). | + | The two intermediate results (column 9 and 13) should not be listed in the report, therefore for these values, the check boxes can be set to "visible" is false (not marked). |
| - | + | {{:en:handbuch:kapitel_3:reportmaker60.jpg|}} | |
| - | {{:handbuch:kapitel_3:3-304.gif?direct}} | + | |
| - | In the column number format a format for all numeric values can be enforced. In the example, enforces the notation #,##0.00 the thousands separator and two decimal places. | + | In the column "number format", a format for all numeric values can be forced. In the example, the notation #,##0.00 sets the thousands separator and two decimal positions. |
| - | {{:handbuch:kapitel_3:3-305.gif?direct}} | + | {{:en:handbuch:kapitel_3:reportmaker61.jpg|}} |
| Here, the thousands separator and decimal point are set only for the installation and are still dependent on the user language. When installed with the German language setting then a point is used as a thousands separator and as a decimal point a comma is used, even if the user language is English. | Here, the thousands separator and decimal point are set only for the installation and are still dependent on the user language. When installed with the German language setting then a point is used as a thousands separator and as a decimal point a comma is used, even if the user language is English. | ||
| Line 85: | Line 84: | ||
| | 0.00% | 0,234 | 23,40% | | | 0.00% | 0,234 | 23,40% | | ||
| - | [[3.6. Fortsetzung 4|... continued]] | + | [[3.6. Fortsetzung 4|... continued page 4]] |
en/handbuch/kapitel_3/3.6._fortsetzung_3.1260275067.txt.gz · Last modified: 2019/10/25 14:09 (external edit)
