| 1 | How do I create a summary report? By default, all Report Writer reports show detailed data, where a single row on the report represents a single data item, for example a contract. However, it is also possible to produce summarised values in a report. A report will be automatically summarised if you insert a Total field on a report in the Detail section. |
| 2 | How can I show an expanded text description for a code? Clicking the Advanced button brings up a group of prompts. There is an Extra SQL prompt. This should only be used by people with knowledge of the SQL language. It allows the normal column value to be overridden with whatever is entered as the Extra SQL. This extra SQL is useful for translating codes into narration i.e. use CASE statement e.g. =CASE when cmy54_type = 'A' then 'Approval' when cmy54_type='C' then 'Confirm' END. Validation is performed when you click OK, and the field will change its appearance to reflect the modifications made. |
| 3 | How can I show associated description with an ITAS piece of data that is a static code e.g. Port code ? DOCDES rules are part of Properties, can select *descr, *full, *text which will be applied on the appropriate data field e.g. phys01_portdest*descr |
| | |