<div>
In the section expert try using a formula like this in the suppress field to hide the extra rows<br />
<br />
{table.IDfield}=previous({<wbr />table.IDfi<wbr />eld})<br />
<br />
HTH
</div>


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

<div>
Steveo, I feel I wouldnt be able to do a distinct on the Sp as Iam selcting a text value in my query.<br />
Any way I can remove them on the report.
</div>


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.

<div>
Which version of Crystal Reports are you using?
</div>


Which version of Crystal Reports are you using?

<div>
Is this the detail that is showing the duplicates?<br />
<br />
Can you add a group to the report and show the details in the group header?<br />
<br />
mlmcc
</div>


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

<div>
<div class="content wysiwyg-content">
Is there a way to suppress duplicate rows from a report.<br />
My Sp is returning multiple rows becuase of a left join.Is there a way to suppress the duplicate rows.<br />
Thanks.
</div>
</div>


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.

SUPPRESS DUPLICATE ROWS FROM REPORT

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.