I have a situation where when running a report, a patron and their gifts are listed twice. This normally means that there are 2 default salutations or 2 primary email addresses in the account (this has always been the issue in the past). Today however, those things are not the reason. Does anyone have any idea what else could cause a gift to appear twice in a report?
Are you joining to T_ADDRESS? If so, I find that I need to put and primary_ind='Y' in my select in case someone has more than one address.
Perhaps cut out each join from your select until you just get one line of data, this should give you an idea where your second line is coming from.
Good luck!
Siobhan