Previous 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 navigate to 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 this 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.