surpress duplicates

[sandeejh]

This might be easy however I have been researching all day long and cannot find the answer I need. I'm almost done with my report, I need one more formula to finish...
I thought I finished my report. All the formulas were in place all the calculation looked beautiful then my supervisor came in and said "oh we need to see the clients email".. I said fine linked up a couple more tables and BAM! the clients email appeared.

Now the problem is, some of the clients have duplicate email in the field which I’m pulling the data from. I noticed when the client has duplicate email, the calculated amount doubled.When they had 3 emails the amount tripled.

I’m looking for a suppression formula that will only use one of the emails so the calculated amount will be correct


All the report data is on the GF1, because I need the report to export to excel for further analysis and I have one formula that needs to be in the GF1 (part of a three formula trick). I have 3 formula summarized in the GF1

 

[lbass]

Suppression will not eliminate the problem with the calculations. The simplest solution might be to add a subreport in the group footer that is linked on client ID and in the subreport, limit records to one of the email addresses (using a maximum, or dragging the e-mail address into the subreport footer). Then suppress all but the section containing the email address. Remove the border and attach the subreport to both horizontal and vertical guidelines just as you would for exporting other fields. The corners don't turn red, but you can test attachment by moving the guidelines. Before attaching, make sure all fields within the footer section are the same vertical size (format->make same size->vertical) and then align the fields, too before attaching.

-LB