Displaying DataView Results

DataView results can be displayed in three ways:

  • You can launch the DataView Results form from the DataViews form, displaying only predefined DataViews.
  • You can launch the DataView Form Results form from the DataViews form, displaying only form DataViews.
  • You can create an event to launch the DataView Results form directly from a form you choose.

Data

The DataView Results form and DataView Form Results form show data based on the properties that have been set on the DataViews Setup form and the DataView IDO Setup form. Properties differ by DataView and layout.

Options

Specify this information on the DataView Results form:

Layout
If permissions are granted, you can save the current layout as the default layout or under a new layout name. You can delete and select existing layouts.
Display
Use these options to manipulate the data in the results grid:
  • Expand All: Show all rows of data.
  • Collapse All: Show only the top level rows of data.
  • Choose Columns: Provide a full list of columns available to hide or display in the grid.
  • Custom Columns: Launch a form to create new columns from existing columns in the data results.
  • Show/Hide Options: Show or hide the Group By, Summary, Filter, and Column Pinning icons in the column header.
  • Show/Hide Group By: Show or hide the Group By icon in the column header.
  • Show/Hide Column Scroll Lock: Show or hide the Column Pinning icon in the column header.
  • Show/Hide Filters: Show or hide the Filter icon in the column header.
  • Show/Hide Summaries: Show or hide the Summary icon in the column header.
  • Show/Hide Extended Captions: Show or hide the full caption including property name in the column header.
Print
This menu provides standard print options.
Send To
Use this menu to send the data to an XPS or Excel file.
This option uses the current state of the DataView for export. Features such as column order and visibility, filters, and summaries are supported.
Note: The Group feature is not supported in the web client version. If a DataView uses grouping, you cannot export the data from a web client.

Also, the web client supports export only to Excel files, not XPS.

Refresh
When available, use this option to reload the results grid, as if you had closed and reopened it.
Setup
When available, use this option to launch the DataViews Setup form pre-filtered to the current DataView.

Notes

If you do not have permission to see the results, an authorization message is displayed instead of the results.

If you cannot view costs, and cost properties are included in the DataView layout, then no data is displayed. In this scenario, we recommend that you copy the DataView to a new name, and deselect the cost properties.

Related topics