How do I eliminate duplicates in reports?

[kaylynny]

I am reading the VM_Vendor_Contacts table and there are multiple contacts per company.   

From a reporting perspective only, how can I show only the first occurrence of a company in this table?  

[Adam Stout]

How do you determine the first?  Do you want to list all the contacts or just one per company?  Is this a standard list report or something else?

[kaylynny]

It doesn't have to be the first occurrence.    Just need one occurrence.   Currently, I'm using the standard list report.  

[Neel13]

I am struggling with a similar issue.

I have a table which lists all Software on all Servers and the Server record has the Business Application mapping. 

I am trying to list UNIQUE software for each Bus Appl. (I am seeing duplicate results in my report since the same software is installed on multiple servers that the Bus Appl runs on).

Thanks.

[Neel13]

Hey, were you able to resolve this ?

I am building a report off a table , list view and I want NOT to display "duplicate" rows.