Previous Topic  Next Topic

Insert Fields Dialog Box

You can use the Insert Fields dialog box to insert fields into a report, or add fields to control values of a list/drop-down list. This topic describes the options in the dialog box.

Designer displays Insert Fields dialog box when you select Insert > DBField/Formula/Parameter, select the ellipsis in the Value column of the Display Type dialog box or Web Options dialog box when defining the web options of a List/Drop-down List web control.

You see the following options in the dialog box:

DBField List

This box lists the data fields that you can insert into the report, or use to control the values of the list/drop-down list.

• Dataset
  Designer expands the node automatically if you specify to insert a DBField. It lists the tables and fields from the current dataset. If you want to insert DBField from another dataset, select the dataset from the dataset drop-down list. You can also select <Choose Data From...> from the dataset drop-down list to create a new dataset.
• Formulas
  Designer expands the node automatically if you specify to insert a formula field. It lists all the formulas in the current catalog. You can also select <New Formula...> to create one.
• Parameters
  Designer expands the node automatically if you specify to insert a parameter field. It lists all the parameters in the current catalog. You can also select <New Parameter...> to create one.
• Dynamic Resources
  Designer displays the node only when you are defining values for a list or drop-down list in a library component. It lists all the dynamic formulas in the current library component. You can also select <New Formula...> to create one.

All

Designer displays the option when you open the dialog box from the Display Type dialog box or Web Options dialog box. You can select it to add an "All" value to the list/drop-down list.

Insert Layout

If you select multiple fields to insert into a report, you can arrange these fields horizontally or vertically by selecting Horizontal or Vertical, or by selecting Default to apply the default layout.

• Vertical Space
  Specify the space between fields that are arranged vertically.
• Horizontal Space
  Specify the space between fields that are arranged horizontally.

Insert

Select to insert the specified fields in the report, or add the specified fields to control the values of a list/drop-down list.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top

Previous Topic  Next Topic