Skip to Content
Former Member
Sep 19, 2008 at 01:59 PM

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!