The following section explain how to open, edit, and format your Tabular View:
Insert data into the table by adding items. All available items are listed in the
panel, on the left side of the Ad Hoc Editor.The following parameters are available in the
panel are:, which can be added to the table as columns or groups.
, which are specialized fields that contain data values.
NOTE:Most of the Measures display GUIDs in Tabular view and some display measures.
To add items from fields and measures as columns to a table:
In the
panel, click the required item from the s or s to add to the table.Drag the selected item into the
box in the Layout Band.The selected item is added to the view as a column in the table.
To remove an item from a table:
In the Layout Band, click
next to the field or measure's name.You can display summary data for any column in your table. Summary data can be in the form of various functions, such as the following:
Sum
Count
Distinct Count
Average
For example, in a table with a list of Bundle Sizes grouped by Bundle Type, you can display the minimum, maximum, average, or sum of the bundle size, using this function.
To add a summary to a specific column:
In the table, right-click the column for which you want to calculate a summary, then select
.The summary information is added to the group header, or is added to the bottom of a column if no groups are included in the table.
To remove a summary from a specific column:
In the table, right-click the column with the summary that you want to remove, then select
.To add or remove summaries from all columns:
Click then select
.For Tabular reports, you can edit a column or header label directly in the Ad Hoc Editor.
To edit a column or header label:
In the
panel, right-click the column or group header.Click
.In the text box, delete the existing name and specify the new name.
Click
.To delete a column or header label:
In the Ad Hoc View, right-click the column or header.
Click
.When you delete a label, it still displays in the Ad Hoc Editor, but does not display in the report.
To re-apply a label:
Right-click the column or header.
Click
.Specify the label name.
Click
.You can change the size of the columns in the table to use space more efficiently.
Select the columns that you want to adjust by clicking at right end of the column.
To resize a column:
In the
panel, select the column that you want to resize.Move the cursor to the right end of the column.
When the resize icon () is displayed, click and drag until the column is adjusted to the required size.
To change the spacing between columns:
In the
panel, under , click .Drag the spacer into the
box in the Layout Band, between the names of the two columns that you want to move apart.A spacer column, labeled , displays in the table.
To remove a spacer, right-click the spacer column then select
.To use spacers to create table margins:
In the
panel, click .Drag the spacer into the
box in the Layout Band.Add the spacer to the right end of the table.
In the
panel, right-click the column that you want to move.Click
or .In the Ad Hoc Editor you can sort the rows of a table by any field.
Click .
The
panel is displayed.To add a field to sort on, double-click the item in the
panel, or select the item and click .To sort by, select one or more items.
Select each field in the
panel, then click the , , , or .To remove an item from the
panel, select the field, then click .Click
. The table will display the rows sorted by the selected fields.You can also sort a table using the following methods:
Right-click a field in the
section of the panel, then click . In this case, the table is sorted by a field that is not in the table; you must note the sorting fields in the title.Right-click a column header on the Canvas of the
panel, then click .NOTE:If a column is already being used and you want to stop using it or change the sorting, right-click the column, then click Change Sorting.
Above the table, select
.Specify the title in the text box.
You can change the formatting for columns containing numeric data, such as dates and bundle size.
In the Ad Hoc View, right-click the column for which you want to change the data format.
Click
.Select the format that you want to use.
These options vary, depending on the type of numeric data contained in the column.
You must select a new data source for your table. Ensure that all view data and formatting is saved before selecting a new Topic or Domain. Any changes to the view are also lost if you navigate to another page.
At the top of the
panel, click , then selectSelect a different Topic or Domain connection.
Click
to apply the new data source.You can control the data displayed in the grid by using the Grid Detail Selector. The Grid Detail Selector includes the following options:
, which displays table detail only.
, which displays the table totals only.
, which displays both the individual and the total table.
To change the displayed table details:
Place the cursor on .
Select the option that you want to apply to the table.
The Ad Hoc Editor displays the data as requested.