IBM Support

How to display the number of records in a report

Technote (troubleshooting)


Problem(Abstract)

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 CRPT_TMP0001.id 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

130272102

Document information

More support for: Rational ClearQuest
Reporting

Software version: 2002.05.00, 2003.06.00

Operating system(s): Windows

Reference #: 1129450

Modified date: 29 August 2005