Work with interactive reports

Icon

Label

Function

Change text

Change the text, alignment, or font of the report header.

Header

Change text, alignment, or font.

Group

Add a group or delete an inner group as well as define page breaks before or after groups.

Freeze

Column

Change the width of columns, move or remove columns to improve presentation or change the order of data in a report. You can also sort data in a column in ascending or descending order, organize data columns into groups, and create computed columns.

Aggregation

Create aggregate data such as sums, standard deviations, rankings, and differences.

Filter

Often, a report or report element provides more information than you need. You can display specific rows of a report by using a filter. For example, instead of listing all customer sales, you can create a filter to list only the sales data for a particular week or a specific region. Filtering data helps you work effectively with large amounts of data.

Sort

Sort data to display report content in a more meaningful order. You can sort data in ascending or descending order, and you can sort by as many as three fields. For example, you can sort a list of customers by credit rank, then by customername.

Alignment

Align left, right, or center

Format

Modify the font or copy the style.

Export Content

You can export content to different formats: Excel, Word, PDF, PostScript, PowerPoint, or extensible HTML.

Hide and display report elements

You can hide columns as well as report elements based on your needs. You can also hide duplicate data rows in a column, or a group.

Display calculated data

You can create calculations to count items in a warehouse or provide more complex financial data, such as tracking stock portfolio performance over time.

Analyze

You can modify crosstabs using a tool called Interactive Crosstabs. You can add, remove, reorganize, and customize the data in a crosstab to examine relationships and trends.