Difference between revisions of "Hidden report generator columns"
From Catalyst
| 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??]]}}. | ||
Revision as of 14:25, 18 October 2013
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 ranges?
- What is a Report Generator variable?
- Accessing the values of other columns.
