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:

Form Menu Description
Layout You can save changes to the current layout or save it as a new layout with a different name. In either case, you can designate a layout as the default layout for a DataView.

You can also delete and select existing layouts.

Display Use these options to manipulate the data in the results grid:
  • Expand All: This option displays all rows of data.
  • Collapse All: This option displays only the top level rows of data.
  • Choose Columns: This option launches the Choose Columns dialog box, in which you can designate which columns are to display and which are to be hidden.
  • Custom Columns: This option launches the Custom Columns dialog box, in which you can create new columns from existing columns in the data results.
  • Expression Columns: This option launches the Edit DataView Expressions form, in which you can create or edit expressions.
  • Expression Summaries: This option launches the Edit DataView Expression Summaries dialog box, which you can use to maintain expression summaries.
  • Show/Hide Options: These options display or hide the Group By Area in the DataView header, as well as the Summary, Filter, and Pin Column icons in the column header.
  • Show/Hide Group By: This option displays or hides the Group By Area in the DataView header.
  • Show/Hide Column Scroll Lock: This option displays or hides the Pin Column icons in the column headers.
  • Show/Hide Filters: This option displays or hides the Filter icons in the column headers.
  • Show/Hide Summaries: This option displays or hides the Summary icons in the column headers.
  • Show/Hide Extended Captions: This option displays or hides extended captions in the column headers. An extended caption consists of any default caption (or caption override), followed by the property name in parentheses.
Print This menu consists of these entries:
  • Print Preview - This option generates a preview of the DataView as it will appear when printed. This preview displays in a separate window.
  • Print - This option launches the Print dialog box, which allows you to print the DataView display to any local system-enabled printer.
Send To Use this menu to export the DataView output.

This option uses the current state of the DataView for export. Features such as column order and visibility, filters, and summaries are preserved and supported in the output.

Output options include these:

  • Excel - This option formats the output as a spreadsheet file and then opens it in Excel (or other compatible spreadsheet application).
  • XPS - This option converts the output to XPS format and saves it as an XPS file.
  • PDF - This option converts the output to Portable Document Format (PDF) and saves it as a PDF file.
Note: The web client only supports export to Excel and PDF files, not XPS.
Data Use the options on this menu to process the data displayed by the DataView. The menu has these options:
  • Refresh - This option requeries the data using the same search criteria as the current display.
  • Get More Rows - When the number of records available exceeds the record cap for a query, this option allows you to requery and return more records.
  • Prompt for Inputs - For DataViews that have input parameters with no supplied values, this option allows you to perform a new query using different input parameter values.
Setup This option launches the DataViews Setup form pre-filtered for the current DataView.
Note: If you do not have permission to see the results, an authorization message is displayed instead of the results.
Related topics