/
Duplicate results in a Crystal Report

Duplicate results in a Crystal Report



Description of Issue

Records are duplicating in Crystal Report



Context
  • Crystal reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients



Cause

There are many reasons for duplicate values, including but not limited to joins between views, the data present in views and the way views are designed.



Resolution
  1. In Crystal Reports application, click Database in the top menu and make select Select Distinct Records has a check mark to the left of it

  2. Refresh the data to re-run the report.



Additional Information












Related content

Master Article - Crystal Reports
Master Article - Crystal Reports
More like this
Cannot see all database views in Crystal Reports
Cannot see all database views in Crystal Reports
More like this
OH PERS - Names listed twice on Proof report
OH PERS - Names listed twice on Proof report
More like this
Update Crystal report to use new ODBC connection SaaS
Update Crystal report to use new ODBC connection SaaS
More like this
Update Crystal Report to use new ODBC connection
Update Crystal Report to use new ODBC connection
More like this
Actuals are doubled on the ytd project budget actuals report
Actuals are doubled on the ytd project budget actuals report
More like this