/
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
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
Refresh the data to re-run the report.
Additional Information
, multiple selections available,
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