Skip to Content

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

Need help with duplicate records

Hi,

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!

-Will

Former Member
replied

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

Regards,

Alpana

0 View this answer in context

Helpful Answer

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