Selecting QQube data in Crystal Reports | CLEARIFY

The Field Explorer

You can invoke the Field Explorer by clicking on View>Field Explorer

The Field Explorer contains 6 categories of data fields for use in your report.

• Database Fields - Your direct data source fields
• Formula Fields - Formulas that you create ,e.g. adding fields, parsing names, conditional expressions, etc.
• Parameter Fields - Allows you to filter your report on demand
• Running Total Fields - Create conditional summary operations
• Group Name Fields - Built in fields from the groupings you create (e.g. customer name, item name)
• Special Fields - Special Crystal Report built in fields e.g. Page N of M, Date report is run, etc.

Database Fields

These are pieces that represent the tables and fields that you either invoked thru the Crystal Reports Wizard, or will see once you open up one of the QQube Crystal Reports examples.  Each Table looks like a folder, and will expand to see the fields underneath it.

The field is what you drag and drop into your report.

Formula Fields

(We will be using the sales_(qqube10.x).rpt file for the following examples.) The power of Crystal Reports is implemented here with an unlimited palette of formula making capability.  These are user created, and will allow you to parse strings, multiply, create conditional results, etc.

Parameter Fields

Parameters are ‘filters upon demand’

When you open a report created with Parameter Fields, the user is prompted to give a value that will be used to filter the report.  For the Invoice Register by Shipping State example, the parameter prompt will look like this:

Running Total Fields

There are times where you would like to have a subtotal, but based upon certain conditions, say greater or less than a particular dollar amount.

Group Name Fields

Most every report is grouped by say, customer, or item, or sales rep.  Crystal Reports creates a special field, which you can use to segment your group, or use in formulas.

Special Fields

These are both internal and built-in ‘shortcut’ fields for current date, print date, page number, total page count, record number,etc. and are listed for convenience.