very Urjent !! Eliminate duplicate records in the report.

[Bhavana Reddy]

Hello Guys,

I am stuck in a problem where i need to report on a table ( consider 2 reference fields below)

1) Contract 

2)configuration item

we have so many records with duplicate values and i need to remove this duplicate values and show only one record in the report

Note : The main problem here one contract might also be linked to multiple configuration item ( see below screen shot configuration item is different )

SO when i create the report i need to group by both "Configuration item and Contract " so that all the duplicate entries will be filtered 

Note : The above table i am reporting on is  huge ( more than 2 lakh records and i need to consider performance also)

Please suggest me guys how i can eliminate duplicates

@Ankur Bawiskar @Aman Kumar @Mohith Devatte @shloke04 

[Bhavana Reddy]

Can anyone please suggest me 

[Uncle Rob]

In an m2m table there's nothing for the system to understand what a duplicate is.

If the duplicates are illigitimate, you're better off looking for ways to scrub the data.

[Bhavana Reddy]

Do you mean we do not have any solution except deleting the duplicate records from the table?

Currently due to some limitation we cannot delete the records but we need to remove them from the report and show only unique records

Please suggest 

[Uncle Rob]

Not via conventional reporting, no.
That's the harm of duplicate records in an m2m table.

[Bhavana Reddy]

I created a database view ( need to join 3 tables) and is there any place to remove the duplicates using the sql syntax?

Please guide me if i am wrong