Advanced field settings

Advanced field settings provide more granular control over what data is displayed in your report. They can be accessed by clicking on the gear icon to the right of any row on the fields tab or the summary tab in the report designer. You can select several options.

Setting Name

Description

Column Group

Applies a label to this column that can work over multiple consecutive columns. Any other column that shares the same label is included in the grouping.

Page Break After Field

If the Page Break After Field box is checked and this field is also a visual group, then it triggers a page break in a printed report every time this field has different value.

Multiline Header

Multiline Header allows a header to be multi-lined if the length of the header is longer than set width of the column. Each space between words works as a line breaker.

Hide this field

Hides the field from display when report the is ran. Useful for using expressions on multiple fields but when only one of the fields should be displayed.

Separator

Breaks out Analysis Grid by this field. Functions identically to VG in a normal table. Because VG is used to define the hierarchy of the Analysis Grid, Separator should be used to visually group the Analysis Grid.

Sort (z-a)

Sorts in descending order.

Italic

Sets whether the column is shown in italics.

Bold

Sets whether the column is shown in bold.

Width

Set the width of the column in number of pixels.

Label Justification

Sets the Column label to the left, right, or middle of the row.

Value Justification

Sets the Value of the field to the left, right, or middle of the row.

Subreport

Sets the drill-down child report. The list contains only reports that have a drill-down key set for them. Note: The Automatic option attempts to choose a sub-report by matching the drill-down key to the selected field and cannot discern between two sub-reports that use the same drill-down key.

Drill-Down Style

•

Link: opens in same browser window

•

Link (New Window): opens in new browser window

•

Embedded: embeds the drill-down results into the main report

•

Popup: opens the results on a pop-up screen

•

Hover: Shows the sub-report when you hover the mouse over the item that the sub-report is linked to.

•

ComboKey: Used in combination with one of the above. When this setting is chosen for the second drill-down key, the value of both fields is passed from the main report to the sub-report.

•

Header Link: Used in a pivot to pass the value of the header (a value derived from the grouping of the pivot header column) to a sub-report. Additional values from the left side of the pivot can be passed using ComboKey or can be incorporated and hidden into the pivot itself.

Url

Allows you to define a custom URL to redirect to when the value in this cell is selected.

SubTotal Function

Sets a customized function for subtotals displayed with this field. The default value is Sum. This only applies to the bottom sub-totals and not the side sub-totals. If set to Expression then a box appears allowing you to set an expression for the subtotal. This functions in the same fashion as the typical expression box.

Gradient Cells Shading

Sets whether cells will use a gradient or solid color for shading. The larger the value in the cell is, the darker the shading. This gradient is determined by establishing a range of X to Y, where X is the lowest value in the column and Y is the highest and shading them proportionally where X is the lightest shade and Y the darkest.

Text Highlight

Highlights the text for a given range. You can refer to the Styles tab for a list of valid colors or using an RGB hex code such as #ff0033. Syntax is given in the format a to b:color;c to d:othercolor:e to f;anothercolor and so on. For example: "5 to 6:Blue;7 to 10:Red". A colon is used to separate the range and value, semicolons are used to separate pairs of range:value arguments. A value given without a range after the first range:value pair acts as a conditional, for example: "1 to 10:Red;Blue" would color values between 1 to 10 red, and everything else blue. A range can be a single value. You may also use percentages to establish a range, such as 0% to 20%:Red.

Note: It is easy to end your statement with a semicolon like this: "1 to 10:Red;11 to 20:Blue;" This throws an index error!

Cell Highlight

Highlights the entire cell for a given range. This follows the same rules as text highlight. You can use both cell and text highlight at the same time to provide contrasting colors, for example if you change the cell to a dark color you might change the text in that cell to a lighter color.

Value Ranges

Lets you set text values for number ranges. (setting this to 0 to 10:Under displays the text "Under" when it encounters a value between 0 and 10 for that column). This follows the same rules as text highlight.

Expression **

Allows you to define a customized mathematical or SQL expression to show as the value for the column cells.

Expression Type

Allows you to specify the data type of this field. This is most useful when you are generating output with an expression and need to specify a data type.

Group By Expression

If checked, this field is included in the group by statement of the query. This is functionally the same as the Group function, except applicable to expression output within a field rather than to the field itself.