Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need help with duplicate records


I'm using VS 200 and the bundled CR. Also, I'm using SQL Server 2005 CE v3.5 for a database, which is an ADO.NET DB (can't use stored procedures).

I am selecting records from one table based on criteria from another. Here's the selection forumla I'm using:

{tblVisitDates.PlayerType} IN {?PlayerType}

The problem is that I'm getting back duplicate records in the primary table. I only want to see the record form the primary table once, no matter how many matching records there are in the child table.

I saw several other posts on this subject, but most seem to deal with the full version of CR, or specify a stored procedure as the solution. Is there a way to code the selection formula, or to group out duplicate records, in the report itself to solve this problem?

Thanks in advance!


Former Member

Hi Will,

You can try Below Formula:

Assume that you are getting duplicate records in detail section then:

1. Go to u2018Reportu2019 menu option >> Section Expertu2026

2. Select u2018Detailu2019 section

3. Click on formula(X-2) for Suppress and Write a formula for all the fields present in the detail section using conjunction u2018andu2019

For instance,

{Customer.Country} = Previous({Customer.Country}) and

{Customer.CustomerID} = Previous({Customer.CustomerID}) and



4. Click OK



0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question