Split gifts showing as duplicates in Crystal Report

Peter McKay 2

Hello All,



I am trying to get our monthly cash report to export as one big crystal report, and the onle thing really hanging me up is split gifts. they are showing up in duplicate on my report. the columns I'm exporting are the following:

    Fund Fund $  Fund1 Fund$1 John Doe Annual Fund $5,000  Restricted $5,000
The total gift being $10,000



But in crystal reports I get this:

  John Doe  Annual Fund $5,000 John Doe  Annual Fund $5,000 John Doe  Restricted $5,000 John Doe  Restricted $5,000   Total $20,000
I've tried various grouping of gift id and fund, with different left-outter join combos but keep getting the same result of four gifts of $5k each.  



Any advice would be much appreciated.  Thanks!

Alan French

Hi Peter,



I've just tried to replicate this and I don't get the same problem, I only get the 2 lines I was expecting. The way you've described your export with the two splits appearing side-by-side rather than on separate lines suggests that it's to do with the way you're exporting your data - can I ask how you're doing it? (e.g. gift export in MDB format, which is what I used)



This is what the fields in my export looked like:







and this is what it looked like in Crystal (the total gift is £8 split equally between 2 funds; I've included both the split amount and the total gift):

Peter McKay 2

Hi Alan,



Thank so much. I was exporting mutliple fund fields. Just a bone headed mistake I think. Ugh.. Thanks again

Alan French:

Hi Peter,



I've just tried to replicate this and I don't get the same problem, I only get the 2 lines I was expecting. The way you've described your export with the two splits appearing side-by-side rather than on separate lines suggests that it's to do with the way you're exporting your data - can I ask how you're doing it? (e.g. gift export in MDB format, which is what I used)



This is what the fields in my export looked like:







and this is what it looked like in Crystal (the total gift is £8 split equally between 2 funds; I've included both the split amount and the total gift):