3 Replies Latest reply: Aug 25, 2010 3:55 PM by GOKULA KRISHNA MAKKAPATI RSS

How can I remove duplicate records?

Maria Carey
Currently Being Moderated

I wanted to know if you could assist me.  I am now responsible for reporting our inside sales activities which includes (each month), outbound calls made, opportunities created, opportunities won $, etc.  We use SalesLogix as our tool.  I have been working with Business Objects and have pretty much created the report I need.  The only problem I have is it will pull in duplicate records because my query is based on u201Ccampaign codesu201D attached to SLX opportunities.  When an opportunity is created in SLX, it automatically assigned an opportunity ID (ex: OQF8AA008YQB) which is distinctive.  However, when we attach more than one u201Ccampaign codeu201D it duplicates the opportunity.


Is there a way to remove duplication in Business Objects?  I have no luck finding this information internally or elsewhere.  Would you be kind enough to help me out here?