Detailed View

Use the Detailed View widget to display multiple fields associated with a single record.

Detailed View widget properties

Use this property To do this
General tab
Name Provide an internal name for the widget.
Connection Name Specify a connection to a data source.
Scope Type Make the connection public or specify a named session.
Title Provide a title for the Detailed View widget box. If necessary, adjust the appearance of the title.
Title Bar Visibility

Specify the visibility of the widget title bar. Choose one of the following:

  • Above
  • Overlay
  • Hidden (outside Designer only)
Context Sensitivity Specify the context sensitivity. Choose from the following:
  • None
  • Receives Context
  • Provides Context
  • Custom

Context is provided on the selected record.

When receiving context, the number of records is filtered accordingly.

To specify context sensitivity options, click to access the context sensitivity properties.

Tile tab  
Background Color Specify the background color for the widget tile.
Text Color Specify the color of the title text.
Show Shadow Display a shadow on the widget.
Show Title Row Border Display borders around the title row of the widget.
Font Size Specify the size of the widget title.
Font Preview Shows you how your font selections will affect the widget title.
Bold Display the widget title text in bold.
Italic Display the widget title text in italics.
Style tab
Font Size Specify the size of the widget text.
Font Preview Shows you how your font selections will affect the widget text.
Bold Display the widget text in bold.
Italic Display the widget text in italics.
Fields tab
Add Statement Specify the fields to display.
  1. Click Add Statement.

    A blank statement is displayed.

  2. Continue to construct the query as necessary. See Statement Editor Functions for a list of available functions.
Add Table Columns Specify multiple columns to display.
  1. Click Add Table Columns.

    The Select A Table And Columns dialog box is displayed.

  2. In the Select a table list, choose the table with the columns that you want to include.

    The columns in the table are listed. By default, all of the columns are selected for inclusion.

  3. Clear the check box for any column that you don't want to include in the grid.
  4. Click OK.

    The specified columns are listed in the statement editor.

Options tab
Number Of Columns Specify how many columns that you want to display.
Advanced tab
Conditions Specify any conditions that must be met to return a value.
  1. Click Add Statement.

    A blank statement is displayed.

  2. Construct the query as necessary. See Statement Editor Functions for a list of available functions.
Sort By Filter the data to further narrow the scope of the query.
  1. Click Add Statement.

    A blank statement is displayed.

  2. Construct the query as necessary. See Statement Editor Functions for a list of available functions.
  3. Click Sort Ascending or Descending to adjust the order of displayed records.
Only select the top __ records Specify to select only a specified number of records with the highest values.
Button Visibility tab
Refresh Show or hide the Refresh button on the widget toolbar.
Events tab
Add Event Handler Add events to the widget.
  1. For When/On, specify when you want the event to occur.
  2. For Then, specify the action that you want to occur.

Last modified: Friday May 12, 2023

Is this useful?