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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you make changes to SP - if yes...

Remove duplicates from SP
 by removing unneeded unique row column values and use distinct...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AshokSr. Software EngineerCommented:
In the section expert try using a formula like this in the suppress field to hide the extra rows


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.
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

AshokSr. Software EngineerCommented:
Which version of Crystal Reports are you using?
Star79Author Commented:
crystal 11
AshokSr. Software EngineerCommented:
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

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.
I have had to format 'Summary' reports in the past not using the 'Detail' portion of report. Can you target Header and footer areas?


May need to try processing input data using 'WhilereadingRecords' or WhilePrintingRecord' and build record comparison logic.
Mike McCrackenSenior ConsultantCommented:
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?

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.