If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos duplicates

Started by rdb86, 23 Aug 2019 10:38:45 AM

Previous topic - Next topic

rdb86

Hello.  I created a report in report studio to show sales data, including the customer phone number and email address, with the output being in excel.  Unfortunately, when there's both an email address and phone number, the row duplicates.  The first row contains both the phone number and email address, but I also get a duplicate row beneath the first that contains the email address, but no phone number.  Any assistance with correcting this issue would be much appreciated. 

peewan

You can try "maximum" function for it

rdb86

Thanks peewan.  I'm new to report studio so how would I go about implementing that?

dougp

Sounds like a bad relationship in the report or in the model.