Cry about...
MS-Windows Troubleshooting


Group specified on non-recurring field


Symptom:

Attempting to generate a report with Crystal Reports (8) the following error is generated and no report produced:

Group specified on non-recurring field

This error has been observed when attempting to run a report using Crystal Reports 8 that had previously been produced and run without problems using Crystal Reports 7.

Cause:

The error means that whilst there are one or more groups defined in the report that one (or more) of these groups does not have a valid group by condition. (This is either an incompatibility between Crystal 7 and 8 or a change in behaviour.)

Remedy:

For each group check that it has a group by condition. Do this by re-specifying the group:

  1. Open the report in Design mode.
  2. From the menu select: Report > Change Group Expect ...
  3. For each group in turn, click the group name and then click on [Options...] (or simply double click the group name).
  4. On the 'Change Group Options' dialog select a field that the report is to be sorted and grouped by, then click '[OK]'.


About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.