Difference between revisions of "Hidden report generator columns"
From Catalyst
(→See also) |
(Bulk update) |
||
| (7 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == How == | + | == 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. | A column with a {{DataPrompt|Position:}} of {{DataValue|0}} will not be included in the output of a report. | ||
| − | == Purpose == | + | === Purpose === |
Why have a column on a report that is hidden? | 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??]]}}. | * The value of a column can be used in another column using the column variable {{DataValue|[[REF:rprgvc01|C??]]}}. | ||
| Line 8: | Line 12: | ||
== See also == | == See also == | ||
| − | + | * [[:Category:Reports & Settings Report Generator functions|Report Generator functions]] | |
| − | + | * [[Column types in the report generator]] | |
| − | * [[:Category:Reports & | + | * [[How do I use calculation sequence?]] |
| − | + | * [[Why are there three report ranges?]] | |
| − | * [[Column | + | * [[What is a report generator variable?]] |
| − | * [[How do I use | ||
| − | * [[Why are there three ranges?]] | ||
| − | * [[What is a | ||
* [[REF:rprgvc01|Accessing the values of other columns.]] | * [[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.
