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 Business View Manager , ProblemProduct
SAP Crystal Reports XI R2