Difference between revisions of "Hidden report generator columns"
From Catalyst
m (Link to C01) |
(Bulk update) |
||
| (8 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 == | ||
| − | *[[How do I use | + | * [[:Category:Reports & Settings Report Generator functions|Report Generator functions]] |
| − | *[[REF:rprgvc01|Accessing the values of other columns.]] | + | * [[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.
