1272632 - How to display only duplicate records

SAP Knowledge Base Article - Public

1272632 - How to display only duplicate records

Symptom

How to display duplicate records only

Reproducing the Issue

Environment Details:

Crystal Reports Version: X,XIR1,XIR2,2008

Operating System: Windows

Resolution

Steps to follow:
  • Create a static Boolean parameter with values True,False
  • Enter Prompt Text as Show Duplicates Only:
  • Right click on details section and go to section expert and write the suppress condition by clicking on X+2
  • Write the condition as follows:

if not({?My Parameter}) then
false
else
(if (OnFirstRecord) then
(
if {field}=next({field}) then
false
else
true
)
else
if (OnLastRecord) then
(
if {field}=previous({field}) then
false
else
true
)
else
if {field}=Previous({field}) or {field}=next({field}) then
false
else
true
)

Keywords

How to display only the duplicate records in report

, KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI R2