IBM Support

How to display the number of records in a report

Technote (troubleshooting)


This technote gives directions for displaying the total number of records in a report when using IBM® Rational® ClearQuest® with Crystal Reports®.

Resolving the problem

In Crystal Reports, you can enable a feature, Grand Total, to display the total number of records in a report.

After completing the below steps, the number of records returned by the query will be printed at the end of your report.

Use these steps to display the record count:

  1. From the ClearQuest client, edit a report format
  2. This opens up the Crystal Report Designer
  3. Go to Insert -> Grand Total
  4. An "Insert Grand Total" window appears
  5. Click Count in the upper pane
  6. Leave or something similar in the bottom pane
  7. Insert the created field in the report footer
  8. Your report will now contain the total record count printed at the end

Historical Number


Document information

More support for: Rational ClearQuest

Software version: 2002.05.00, 2003.06.00

Operating system(s): Windows

Reference #: 1129450

Modified date: 29 August 2005