SUPPRESS DUPLICATE ROWS FROM REPORT

Is there a way to suppress duplicate rows from a report.
My Sp is returning multiple rows becuase of a left join.Is there a way to suppress the duplicate rows.
Thanks.
Star79Asked:
Who is Participating?
 
5teveoConnect With a Mentor Commented:
Can you make changes to SP - if yes...

Remove duplicates from SP
 by removing unneeded unique row column values and use distinct...
0
 
AshokCommented:
In the section expert try using a formula like this in the suppress field to hide the extra rows

{table.IDfield}=previous({table.IDfield})

HTH
0
 
Star79Author Commented:
Steveo, I feel I wouldnt be able to do a distinct on the Sp as Iam selcting a text value in my query.
Any way I can remove them on the report.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
AshokCommented:
Which version of Crystal Reports are you using?
0
 
Star79Author Commented:
crystal 11
0
 
AshokConnect With a Mentor Commented:
To suppress duplicate rows because of description variations

Select the field that is duplicated, use the section expert, be sure to choose “details”,insert formula in the Suppress (no drill-down) formula field (X-2)

Insert formula (based on the duplicated field) =previous, second field statement must be in parenthesis!
 
My sample formula
{PART_RECENT_WORK_ORD.PART_part_no}=previous({PART_RECENT_WORK_ORD.PART_part_no})
 

Save, and refresh and they are gone!
 
The action of the  formula is if the field you choose is the same as the previous row the complete row is suppressed.
0
 
5teveoConnect With a Mentor Commented:
I have had to format 'Summary' reports in the past not using the 'Detail' portion of report. Can you target Header and footer areas?

or

May need to try processing input data using 'WhilereadingRecords' or WhilePrintingRecord' and build record comparison logic.

http://scn.sap.com/thread/1715251
0
 
mlmccCommented:
Is this the detail that is showing the duplicates?

Can you add a group to the report and show the details in the group header?

mlmcc
0
All Courses

From novice to tech pro — start learning today.