The Ad Hoc View Panel

The Data Source Selection panel contains a list of available fields in the chosen Topic or Domain. If you are using a Domain, fields may appear in nested sets. Use the arrow beside the set name to expand or collapse a set of fields.

Available fields may be divided into two sections in the panel, Fields and Measures. You can use the search field in each section to locate a specific field or measure.

To hide this panel, click < in the top left corner; this is helpful when arranging content in a large Ad Hoc view. Click the same icon on the minimized panel to expand it.

For more information on working with fields, see Using Fields in Tables , Using Fields and Measures in Charts, and Using Fields in Crosstabs.

The Ad Hoc View Panel

The Ad Hoc View panel provides tools that allow you to control what data is included in a view, and how it is organized.

Along the top of the panel, there is a tool bar and a drop-down menu.

The drop-down menu contains options for displaying a subset of the available data (Sample Data), all available data (Full Data), or none of the available data (No Data) in the view. Using the sample data can make the design process quicker by loading less data. Use the subset for initial design; use the full set for refining layout elements such as column width. This drop-down menu is not available for charts, which use all available data.

By default, the editor displays only a smaller, sample set of the data in the table. Use the drop-down menu to select Full Data to view the full set of data.

Depending on its configuration, JasperReports Server may load a Topic, Domain, or OLAP connection’s entire result set into memory when you edit the view, or run a report from it. If the data policies and other options that control JasperReports Server’s memory are disabled, ensure that each Topic, Domain, or OLAP connection returns a manageable amount of data, given the environment’s load capacity. Alternately, you can change the server’s configuration.

The tool bar at the top of the panel provides access to many functions of the Ad Hoc Editor. The toolbar is described in Ad Hoc Editor Tool Bar Icons.

Ad Hoc Editor Tool Bar Icons




Display Mode

Click this icon to hide the editor interface. This mode provides a subset of the editor’s full feature set.


Place the cursor over this icon to open a menu of save options.


Place the cursor over this icon to open a menu of export options.

Get Embed Code Click to display the Ad Hoc View Embed Code dialog. See Getting the Embed Code for Visualize.js for more information.


Click this icon to undo the most recent action.


Click this icon to redo the most recently undone action.

Undo All

Click this icon to revert the view to its state when you last saved.

Switch Group

Click this icon to change the way groups are displayed. For more information, refer to Creating a View from a Domain.


When working with tables, click this icon to view the current sorting and to select fields for sorting data. For more information, refer to Sorting Tables

Input Controls

Click this icon to see the input controls applied to this view. For more information, refer to Using Input Controls.

Page Options

Place the cursor over this icon to open a menu of page-level options. You can:

Change whether to display the Layout Band.
Change whether to display the title area.
In crosstabs, you can merge or unmerge cells with the same data.

View SQL/MDX Query

For more information on viewing SQL queries, see Viewing the SQL Query

For more information viewing MDX queries, see Viewing the MDX Query

Select Visualization Type Click this icon to select the type of table, chart, or crosstab you want to use in your Ad Hoc view. For information on all the types of visualizations available, see The Visualization Selector for more information.

The Layout Band

Directly beneath the tool bar is the Layout Band. Here there are two fields. These fields have different labels and functions, depending on the type of view you are creating:

For tables, these fields are Columns and Groups.
For charts, these fields are Columns and Rows.
For crosstabs, these fields are Columns and Rows.

You can drag and drop fields and measures into these boxes to populate your view.

Managing Canvas Options

When working with a table or chart view, the Canvas Options selector appears below the Layout Band, to the left of the view title. This tool allows you to control the level of detail displayed in your table or chart. Click to display the options available for your Ad Hoc view type.

For tables, the Canvas Options selector includes the following options:

Detailed Data (default) displays table detail only.
Totals Data displays table totals only.
Details and Totals displays both details and totals.
Show/Hide Duplicate Rows, which displays only the distinct values in your table if you choose to hide the duplicate rows.

For charts, the Canvas Options selector includes the following options:

Chart Format displays formatting options.

Viewing the SQL Query

You may want to look at the SQL query for your view, to verify what data users are hitting. If you have the proper permissions, you can do this in the Ad Hoc Editor with the View Query button.

The query is read-only, but can be copied onto a clipboard or other document for review.

To view the SQL query:

In the tool bar, click .

The View Query window opens, displaying the SQL query.