Overview

The Field Explorer is used to insert, modify or delete fields in a Crystal report.

To open the Field Explorer:
Crystal XI: Go to View > Field Explorer
Crystal 8.5: Go to Insert > Field Object

The Field Explorer displays a tree view of Database Fields, Formula Fields, SQL Expression Fields, Parameter Fields, Running Total Fields, Group Name Fields, and Special Fields that you have defined for use in your report.

Fields that have already been added to the report, or fields that have been used by other fields (such as formula fields, groups, running total fields, summaries, and so on) have a check mark in front of them.


Toolbar and shortcut menu

The toolbar provides buttons with tool tips and hot-key combinations. You can right-click any item in the tree view to bring up a shortcut menu.

The toolbar and the shortcut menu offer these functions:
  • Insert to Report - Use this option to add a field to the report. You can insert more than one field at a time by selecting multiple fields, right-clicking, and choosing Insert to Report. Alternatively, to insert a field, you can drag and drop it in the Design or Preview tabs.
  • Browse - Use this option to browse data for a Database Field.
  • New - Use this option to create a Formula Field, SQL Expression Field, Parameter Field or Running Total Field.
  • Edit - Use this option to modify an existing Formula Field, SQL Expression Field, Parameter Field or Running Total Field.
  • Rename - Use this option to modify the name of an existing Formula Field, SQL Expression Field, Parameter Field or Running Total Field.
  • Delete - Use this option to remove a Formula Field, SQL Expression Field, Parameter Field or Running Total Field. You can also select multiple fields, right-click, and choose Delete to remove them all at once.
  • Move Up (or Down) - Use this option to change the order of Parameter Fields. When you right-click a Parameter Field, all the functions except Browse Data are enabled.
  • Show Field Type - Use this option to see the field type (string, number, date, etc) when you're looking at a list of Database Fields.