Viewing: Running Reports and the Report Viewer > Overview of The Report Viewer > Column Menu

Column Menu

Reports that contain table components are enabled for user interactivity. Table components are defined in Jaspersoft Studio or from Ad Hoc Views. When a table is enabled for interactivity, column formatting, filtering, and sorting are managed from a menu displayed by clicking the column you want to apply changes to. These menu icons are described in “Export File Types”.

Column Formatting Icons

Icon

Name

Description

 

Formatting/Show column/Hide column

Select Formatting to open the Format Column box.

Select Show column or Hide column.

 

Column filters

Click to open the Filter column box.

 

Sort ascending

Click to sort fields in the selected column in ascending order.

 

Sort descending

Click to sort fields in the selected column in ascending order.

 

Column size

Click and drag this icon to make columns wider or narrower.

Data Snapshots

Some reports have an optional data snapshot feature enabled. A data snapshot is a cached copy of the data included in a specific report. Data snapshots allow you to access a report's data (including input control settings) without having to retrieve it from the data source, which in some cases can save a significant amount of time.

When a report is opened in the Report Viewer, data is retrieved from the data snapshot. If the snapshot does not exist, then a live query is made to the data source. A snapshot is created when a report is saved from the viewer, or via the scheduler. The Report Viewer UI displays a date and time stamp that indicates when the report data was last refreshed with live source data.

The system administrator can enable or disable the data snapshot feature.

It should be noted that a report can have only one snapshot. For instance, if you edit and save a report that already has a snapshot associated with it, a new snapshot overwrites the previously-created snapshot.