Difference between revisions of "Hidden report generator columns"
From Catalyst
(New page: {{Stub}}) |
(Bulk update) |
||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | == Summary == |
| + | This article explains how to hide the results of a report column and how this can be useful. | ||
| + | |||
| + | == More Information == | ||
| + | === How === | ||
| + | A column with a {{DataPrompt|Position:}} of {{DataValue|0}} will not be included in the output of a report. | ||
| + | |||
| + | === Purpose === | ||
| + | Why have a column on a report that is hidden? | ||
| + | * The value of a column can be used in another column using the column variable {{DataValue|[[REF:rprgvc01|C??]]}}. | ||
| + | * If you are using a variable that is time consuming to evaluate (e.g. Period totals) and you use it more than once on a line, having it stored in a hidden column and accessing that column would mean that time consuming variable would only be evaluated once. | ||
| + | |||
| + | == See also == | ||
| + | * [[:Category:Reports & Settings Report Generator functions|Report Generator functions]] | ||
| + | * [[Column types in the report generator]] | ||
| + | * [[How do I use calculation sequence?]] | ||
| + | * [[Why are there three report ranges?]] | ||
| + | * [[What is a report generator variable?]] | ||
| + | * [[REF:rprgvc01|Accessing the values of other columns.]] | ||
| + | |||
| + | {{KB_Tags|hidden report generator columns}} | ||
| + | {{MClass}}{{KB_RGen}} | ||
Latest revision as of 05:29, 12 April 2019
Summary
This article explains how to hide the results of a report column and how this can be useful.
More Information
How
A column with a "Position:" of '0' will not be included in the output of a report.
Purpose
Why have a column on a report that is hidden?
- The value of a column can be used in another column using the column variable 'C??'.
- If you are using a variable that is time consuming to evaluate (e.g. Period totals) and you use it more than once on a line, having it stored in a hidden column and accessing that column would mean that time consuming variable would only be evaluated once.
See also
- Report Generator functions
- Column types in the report generator
- How do I use calculation sequence?
- Why are there three report ranges?
- What is a report generator variable?
- Accessing the values of other columns.
