Hi All!

I need some help.  I need to export names of our donors and a listing of all the different funds they have given to.

I built my query to show: Name, Total Given, First Gift Date, Last Gift Date,  Fund Description.  Then I built an Export so I can get the information to spread ACROSS not DOWN (I want one line for each constituent).

If I tell the Export to show me:  10 gifts for each constituent and for each gift 1 fund, I get the first 10 gifts they gave to, which could include duplicates.

What I want is a listing of every fund they ever gave to with the duplicates removed.  Any suggestions????

Thank you!

Relational database are "normalized" using a set of rules.  The very first rule is that all records must have the same number of fields.  What you are asking for is a table with records having a variable number of fields. It's not going to happen.

The best way to accomplish this is to write a custom Crystal Report grouping on the constituent with a crosstab in the group header for the consituent.

DRew

Thanks, Drew!

I love the "not going to happen"!  I usually want databases to do things they don't want to.

I haven't experience writing a custom Crystal Report yet. Time to get my manual out!