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.
You can try "maximum" function for it
Thanks peewan. I'm new to report studio so how would I go about implementing that?
Sounds like a bad relationship in the report or in the model.