Features: Report Formatting
The Interactive Viewer lets users reformat and make other changes to reports. These changes include formatting column headers and other labels, formatting data, applying conditional formatting, and setting or removing page breaks.
Defining Headers, Labels and Page Breaks
The Interactive Viewer lets users perform multiple tasks related to editing and formatting report text and labels.
- Edit Text Labels - changes text in labels that are not protected.
- Modify Label Formatting - modifies characteristics such as font, color, type size.
- Set and Delete Page Breaks- sets breaks before or after grouped data if report design has grouped data.
Data Formatting
The Interactive Viewer lets users modify default data formatting.
- Resize a Column - changes column width.
- Change Data alignment in a Column - aligns column data to the left, center, or right.
- Hide, Show, Delete, or Reorder Columns - arranges, hides, deletes or re-orders columns.
- Suppress Duplicates - prevents repeat values from appearing consecutively in a column.
- Set Text Characteristics - modifies font, color, style, and other text properties.
- Change Case - formats labels to appear in all upper or lower case.
- Change Data Value Default Formatting - selects and changes default data formatting within rows.
- Format Data Types - changes data types such as numeric values, currency, percentages, or scientific numbers.
Conditional Formatting
The Interactive Viewer for End Users can be used to change data formatting when a certain condition is true; for example, in a report that shows customers' past-due invoices, a user can highlight in red any customer name that has an invoice 90 days or more past due, and then highlight in blue any customer name that has an invoice 60 days or more past due.
- Conditional Formatting - sets up to three conditional formatting rules for a single column, and removes or modifies conditional formatting.
- Cross-column Conditional Formatting - affects the formatting of one column based on the value in another column; for example, if CustomerName is the selected column, a user can base the condition on the CreditRank column so that conditional formatting applies to the customer name if the customer's credit rank is of a particular value.
- Numerous Comparison Types - sets up comparisons, including null or false; compares a column value to one or two other values; checks whether a value is between or not between two values.