Table Row Versioning
Row versions allow you to conditionally display rows of data in different format. They are used to make certain data stand out or to make your report more legible.
Row versions are either builtin or user defined and may be specified with a version key expression. They are applicable to header, detail, and summary rows
Built-in Row Versions
By default reports use the Standard row version. Here are the builtin row versions:
|
Row Versions |
Description |
|
Standard |
Default row version |
|
First Only |
Applies only to the first instance of the row. Good for showing header information without using an upper level detail row. |
|
Reprint |
Applies every page after the first. Good for one time headers or (continued) indications to save space. |
|
Alternate |
Applies every other row. Good for grey-bar reports by changing the background color. |
|
TopN Others |
Applies to count number of rows in a TopN sort. Using "include others" will then distinguish between TopN and non-TopN rows. |
|
Split Header |
Applies to headers that has been split due to excessive height. Good for providing "Continued" type indicators. |
|
Custom |
Create your own. Must be selected manually or in conjunction with the row's Version Key property |
User Defined Row Versions
User defined row versions are identified by a string based name. They will be used when the Row Version Key expression is a string that matches the row version name.
Row Version Key
The Row Version Key is an expression that must return a string. If that string equals the name of a row version, either builtin or user defined, that version will be used. An invalid string will default back to normal builtin row version behavior.
Row Version Example
|
1. |
Add a custom row version. scheduled, in this case. |
|
2. |
Select your row and customize it |
|
3. |
Specify Table Row Version Key. Tip: start with the expression "scheduled" to try out your custom row version before using more complex expressions. In this case we use: IF comment = "Scheduled maintenance" THEN use our custom row version. comment=="Scheduled maintenance"?"scheduled"
|
|
Tip |
When using an IF condition for row versioning leave out the ELSE. Your table will then still respect builtin row versions. If you defaulted the ELSE to "Standard", none of the builtin versions such as Alternate would ever appear. |
|
Tip |
Make sure that you're happy with the Standard row version before you create other row versions. This will save you time as other versions begin as a copy of Standard. |
