Browse Data Dialog Box
Use the Browse Data dialog box to preview the data type, length, and content of any field.
This dialog box appears when you right-click a database field in the Field Explorer and choose Browse Field Data, or when you click the Browse Data button in a dialog box. The source of the field (alias) and the field name appear as the title for the dialog box.
Note
To display the Field Explorer, click the Crystal Reports menu, click Field Explorer.
| Type | The data type for the field (string, number, and so on). |
| Length | The field length that is defined for the specified data type. |
| Scroll Box | A list of field values appears in the scroll 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. If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records. Note 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. |