Work with interactive reports

Interactive viewer is the environment in which you view interactive reports. When you open an interactive report, interactive viewer opens in a new tab.

With interactive viewer, you can customize reports based on your needs and preferences. You can do the following on reports containing up to 200 pages:

Modify the layout of the report
Create computed data
Move or delete columns
Create aggregate data
Modify tables displaying summary information,
Modify charts and graphs
Modify data in crosstabs
Rearrange data using simple menu options

In interactive viewer, select and right-click an area in the report. The context menu varies depending on the type of content selected. Options include the following:

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 client 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 clients by credit rank, then by clientname.
	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.

When you click tap the menu icon you can: