## Browse and Paste Data dialog box

This dialog box appears when you click the Browse Data button in the Formula Editor.

Use the Browse and Paste Data dialog box to preview the data type, length, and content of any field and to paste a value into your formula or selection criteria.

- The source of the field (alias) and the field name appear as the title for the dialog box.
- The data type for the field (string, number, and so on) appears just below the title.
- A list of field values appears in the scroll box.

When you are finished reviewing the field data, click the Done button or select a value and click the Paste Data button to paste the value into your formula.

Note:

- If you need to select multiple values (for example, if you want to include records in which the field value is one of three values), the insertion point automatically moves to the next box after you paste data in the current box.
- When you browse a field, by default you see the first 500 unique values of the field. You can change this for the current report by clearing the Select Distinct Data for Browsing option in the Report Options dialog box. You can change the default setting by clearing the Select Distinct Data for Browsing option on the Database tab of the Options dialog box.

If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records.

Note: Note that since most SQL servers do not support selecting distinct records for long data types such as memo and blob fields, selecting and browsing distinct records are not supported for such fields.

If you fail to connect to a database because it is unavailable or password-protected, you can still browse on saved data.

###### Related topics

Browse Data dialog box

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com