The ExpressView designer is data discovery and reporting tool that simplifies grouping, sorting, filtering, and aggregating data with a drag-and-drop interface. A chart can be added with a single click, and ExpressViews can be styled and saved as PDF, RTF, CSV, or Excel files.
Making an ExpressView
ExpressViews allow you to quickly see data and make reports without concern for the minutiae of old-fashioned report building.
To make an ExpressView:
Click the New Report
icon and select
ExpressView.
Info. The ExpressView designer is divided into the Data pane on the left, and the Design pane in the middle. The Data pane comprises all of your accessible data categories, containing groups of related data fields. For more information, see Data categories and fields.
Expand a category by clicking the arrow
icon. This shows the fields in
that category.
Drag a field onto the Design pane to add it to the ExpressView. This expands the field into a data column. It will only show placeholder data initially.
Continue to add fields as desired. Fields can be added or removed at any time.
Note. As you add fields, unrelated fields will become unavailable. To learn about how fields relate to each other, see Joins.
When you are satisfied with your data selection, click
Live Data to populate the ExpressView
with data. You can now page through your data using the navigation icons
in
the toolbar.
Click the Save
icon to save the ExpressView. In the Settings window, enter a Name
and select a folder where it should live. Then click Save Report
Info.
These steps illustrate how quick it is to make a tabular report from scratch using ExpressView. But ExpressViews can be more than just basic reports. You can make groups, charts, calculations, and customize the look of the report. And it is all designed to be easy to use. The following sections will describe how to use these powerful features.
About the radial menu
Throughout this topic you will see references to a menu called the radial
menu. The radial menu is a menu of options for each data column and group, which
is accessed by clicking the colored Radial
icon on the top
left of the column or group.
...
... 
Using the radial menu
Each radial menu has four options, arranged in a circle around the center.
When you are prompted to select a radial menu option, you will be
asked to "use
radial>direction".
Direction is one of the four cardinal directions corresponding
with one of the four options: left,
right, up,
down.
For example, "use
radial>left"
means to open the radial menu and select the left option. To do this, you have
two options:
To close the radial menu without selecting an option, click in the center.
Grouping and summarizing data
Grouping a column of data breaks up the rows into sections which share a common trait. Each iteration of a group is a unique row in a data column. Grouping data allows you to easily identify rows with common factors. You can perform calculations on groups, such as counting the rows, or adding up the data in each iteration.

Grouping data in an ExpressView
Making a group
To create a group from a column, use
radial>up.
This turns the data column into a group column, and organizes the other columns
by each unique row in the group. Each row in the data column becomes a group
section, or iteration, and the rows in other columns are grouped by the
section which they are related. The group is also given a new color to
distinguish it from the data rows. Remember to turn Live Data
on to see your actual data and verify that this is the grouping you
want.
To ungroup a column, use
radial>left.
This turns the group column back into a data column.
Groups can be created inside other groups. These are called nested groups. To make a nested group, simply add another group to an ExpressView which already has one. This creates another grouping inside the existing group. Additional levels of nesting can be made as needed.
Changing group level
If you have two or more levels of grouping, you may decide that they are nested improperly. For example, if you had Products grouped by Orders, then you add another grouping on Employees, you may end up with Products grouped by Employees grouped by Orders.

Improper grouping of data fields
However, it makes more sense to have Orders grouped by Employees instead,
since Employees have multiple Orders, but Orders does not have multiple
Employees. To move the Employees group up one level, use
radial>up
on the group column.

Proper grouping of data fields
Summarizing group data
Each iteration has a footer, which contains summary calculations, also known as aggregates, for each column. The ExpressView also has a report footer, which calculates the aggregate across all the groups. You can choose between several options for which calculation you want to appear in the footer for each column.
To change the calculation for a column, click a footer and select one of the following options:
Sum
Totals the data values in the iteration. Only available for numeric fields.
Min
Shows the smallest data value, or first value alphabetically, or earliest date in the iteration.
Max
Shows the largest data value, or last value alphabetically, or latest date in the iteration.
Count
Counts the number of values in the iteration.
Distinct Count
Counts the number of distinct values in the iteration.
Avg
Takes the average, or arithmetic mean, of the values in the iteration. Only available for numeric fields.
Hiding data rows
If you only want to see the summary calculations, you can hide the data rows, either per-iteration, or for every group in the ExpressView. This does not remove the data or alter the summaries. It only hides the rows from view.
To hide the rows for one iteration or several iterations, click the group header for each iteration to toggle whether its rows are shown or hidden.
To hide or show all the rows in the ExpressView:
icon.
Hide All Group
Content to hide all the rows, or
Show All Group
Content to show all the rows. If you have nested groups, this hides all but the top level groups.
Managing data
You can exercise some fine grained control over the actual data that appears in the ExpressView. You can choose how the data appears, you can filter down the rows to appear, and you can change the order of rows in their respective sections.
Formatting data
Formatting allows you to specify a data type for specific data fields, and choose how that data displays.
To change the data type for a field:
Click the Formatting
icon to open the Formatting
page.
Click the data rows to format. They will highlight in blue.
Click the Data Format tab.
From the Format Type list, select a data type from the following options:
General
Format the data using the default settings for your environment. The application will assume the data type.
Number
Format the data as a number. Continue to step 5.
Date
Format the data as a date, time, or date and time. Skip to step 6.
Text
Do not apply any formatting to the data, and show it exactly as it appears in the database.
If the data field cannot be formatted as a number or date, then selecting one of those options will have no effect on the appearance of the data.
Reordering data rows
Sorting allows you to set the order that the data rows appear in each
section. Click the Sorts
icon to open the list of sorts.
Every data column in the ExpressView that is not a group column is
automatically sorted.
You can choose which columns take precedence for sorting. The order of fields on the Sorts page is their order of precedence, from highest to lowest. Their order is also indicated by a number on the right of the column headers: The lower the number, the higher the precedence.
To set the sort precedence of data fields, either:
radial>down
to give a field the highest precedence. You can choose which direction to sort the data for each data field:
ascending or descending. A field's sort direction is indicated by an arrow
on the right of the column header: Up
for ascending, down
for descending.
To change a field's sort direction, either:
For more information on sorting data, see Sorts.
Narrowing your data
Filtering allows you to narrow the scope of your ExpressViews by restricting the amount of data shown. You can filter data by only showing rows whose values satisfy certain conditions. These are Standard filters. You can also filter data to only the rows with the top or bottom values, for either data fields or data summaries, per group iteration. These are Top N filters. For more information, see Filters.
Click the Filters
icon to open the list of filters.
The filters page has two tabs: Standard and
Top/Bottom.
To show only the data that satisfies several conditions:
On the Filters page, click the Standard tab.
To add a data field to filter, either:
Use
radial>right
on a data column or group.
Drag a data field from the Data pane to the Meet all of the following conditions pane.
Note. This allows you to filter any accessible data field, not just those on the ExpressView.
Choose a filter operator from the list. See Filters for details.
Enter a filter value or values, or select them from the list.
Repeat steps 2-4 for every filter condition that the data must satisfy in order to show.
To show only the data that satisfies at least one of several conditions:
On the Filters page, click the Standard tab.
To add a data field to filter, either:
Use
radial>right
on a data column or group. Then drag the filter to the meet any of
the following conditions pane.
Drag a data field from the Data pane to the meet any of the following conditions pane.
Note. This allows you to filter any accessible data field, not just those on the ExpressView.
Choose a filter operator from the list. See Filters for details.
Enter a filter value or values, or select them from the list.
Repeat steps 2-4 for every filter condition, of which the data must satisfy at least one in order to show.
To show only the top or bottom values, for either data fields or data summaries:
On the Filters page, click the Top/Bottom tab.
Select the Limit the report to the top/bottom values check box.
Select either Top or Bottom, for whether you want to show the top or bottom values.
Enter a number for how many values you want to show.
Choose how you want to limit your data:
If you want to show the rows with the top or bottom data values for a field or group, select Values from the list.
If you want to show the groups with the top or bottom summary values for a parent group or the ExpressView, select one of the summary calculations, Sum, Avg, Min, Max, Count, or Distinct Count, from the list. See Grouping and summarizing data for details on the calculations.
Note. Only numeric data fields support Sum and Avg calculations.
Select the data field or group field to filter from the Of list.
Optional: To show the top or bottom values for each iteration of a group:
Click
Add
Group.
Select a group field from the For Each list.
Making visualizations
Charts allow you to showcase your data in a visual format. They allow you to quickly scan your data for patterns and trends. Charts can be easily made and customized in ExpressViews, in as little as one click.
To add a chart to an ExpressView:
Click the Show Visualization
icon. A bar chart is added
and populated with the data from your ExpressView.
In the Visualizations pane, select the type of chart you want to use. The chart immediately swaps to that type.
Click on a chart series to drill down into the data for that series. This filters the data columns to only the series you select.
You can add many more personal touches, small or large, to the visualizations you create. See the following sections for details on how to customize your visualizations.
Choosing chart data
When a visualization is first added, the application presets the chart fields to try to match the ExpressView data as closely as possible. This may not always match the data that you want the chart to use.
To see the chart data fields, click the Visualizations
icon, then click the Data
tab. There are two fields: Labels and
Values.
Labels
The Labels field is a group of data values, each iteration of the group represented as a series on the chart. For example, using an Employees group field as the label field represents each employee as a series.
Several charts allow an additional labels field. This is useful if you have a nested group, which represents common series to be measured across several groupings. For example, to compare the number of sales per product per employee, you could add a nested Product field as a second label to the aforementioned employees chart.
To add a chart label, either:
Add
Label, then select a field from the Field list.
Values
The Values field is the data values to plot on the chart for each iteration of each labels group. For example, the number of sales per employee.
Several charts allow for multiple values fields. This is useful if you have common series to be measured across several groupings, and the values fields are in the same data row. For example, the number of sales and number of lost sales per employee.
To add a chart value, either:
Add
Value, then select a field from the Field list.
Customizing appearance
ExpressViews can be styled in a variety of ways. Click the Formatting
icon to see your
available options.
Using a premade theme
If there are any available, you can select a premade theme to use for the ExpressView, or to use as a baseline for further customizations. On the Formatting page, click the Theme tab. Then select a theme from the Theme Selector list:
Legacy
This is the default theme.
Custom
This option indicates that you are not currently using a premade theme.
Selecting a premade theme overrides any custom styling you have. Be sure to save the ExpressView first, so that you can retrieve your styling if you accidentally override it.
Styling data cells
Data columns and group columns can be styled independently, using the Style tab on the Formatting page. You can style the data cells, as well as group headers and footers.
To style a data cell:
You can also use the Formatting page to edit the header names of the data columns. To do so:
icon on the header.
Changing data row colors
The background colors for the data rows can be customized, and you can set the pattern by which the colors alternate. This affects every data section in the ExpressView.
To set the background colors:
to delete all the colors except
one.
to add more colors.
Changing group colors
The headers and footers for group columns are prefixed by a different color depending on the level of grouping. These colors can be customized, and you can set the pattern by which the colors alternate. This affects every group header and footer in the ExpressView.
To set the group level colors:
to delete all the colors
except one.
to add more
colors. Data categories and fields
The data pane is organized into data categories, which you can expand to see their fields. To learn about data categories, see Categories.
To locate a specific data field, type the name of the field into the Search
field and press Enter. To see all the data fields, click
to clear the search
field.
You can show only data fields of a certain type by clicking one of the type icons under the Search field:
text
numeric
date/time
other All available data categories are usable on an ExpressView. You do not have
to worry about adding categories manually or thinking about join structure.
Adding a data field is as simple as dragging it onto the Design pane.
This turns it into a data column. Use
radial>left
to remove a data column.
Exporting an ExpressView
ExpressViews can be used as a starting point to quickly add fields to a report, before delving into some of the more advanced reporting capabilities. The ExpressView format is not compatible with the report designer, but you can export it to an Advanced Report and edit the copy.
To export an ExpressView to an Advanced Report:
icon.
If you to save an ExpressView as a file, it be exported as PDF, RTF, CSV, or Excel. Each format has some advantages and disadvantages.
Export settings
You can make some customizations to the appearance that the exported files will take. With the Settings page open, click the Export Settings tab to see the available options:
Page Options affect the size which PDF, RTF, and Excel exports will show on a screen and on print.
General Options allow you to restrict available export types, and choose a default type.
Other Options:
Include Setup Info: Choose whether to include some information about the fields, sorts, and filters in the body of the file.
Use Group Color Styling: Choose whether to include the group header colorings in the output file.
'No Data Qualified' Mode: If the ExpressView returns no data, choose whether to render an empty file, or show a user message instead.
Flatten Groups in Excel and CSV: For Excel or CSV files, choose whether to automatically ungroup, or "flatten" all group columns into data columns. This may make the output more suitable for data analysis.
Keep Cell Styling in Excel: For Excel files, choose whether to show styling, such as font and row shading, or to show only the bare data.