Duplicate Records Exception

[bo5i]

Hi, how to do exception reporting. If i have duplicate records in my table, i would like to show uniquely that these are duplicates.

Order_Id,Order_Date,Order_value , Combination of this is duplicated in the table by whatsoever reason. How can i get the report to do exception saying that these order numbers are duplicated.

Order_Id,Order_Date,Order_value
100,12/12/2003,1000
100,12/12/2003,1000

I need to show a single record in my exception report like
100,12/12/2003,1000

Thanks

 

[skrandel]

You should include a measure defined as Count(*). Then you could simply write a report that puts the measure in the condition section of the query panel. Compare it to > 1.

What you'll see in the SQL is
Select col1, col2, col3
From table
Having count(*)>1

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com