• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4162
  • Last Modified:

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.
0
Star79
Asked:
Star79
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
5teveoCommented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
AshokCommented:
Which version of Crystal Reports are you using?
0
 
Star79Author Commented:
crystal 11
0
 
AshokCommented:
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
 
5teveoCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now