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
Have a look at the output from the stored procedure using the same parameters. I would guess there is another field on there which isn't being shown on your report which is making it come out twice.
Wayne, I tried that and just can't find anything. The really weird part is that this patron has 2 memberships (2 different campaigns). If I run the report for the other campaign, she is only listed once in the report. No one else is duplicating when running the report using the original campaign we are trying to run. I'm totally confused and frustrated. Thanks for the suggestion.