I am trying to create a new crystal that includes the last 12 gifts (along with date, type, appeal). The report is grouped by the Constituent's sort key and I have included address information in the details section. I am trying to enter the gift information in the detail section. It has been a long time since I have worked on a report of this type and I don't claim to have Crystal mastered but I can't seem to understand why if a donor has more than one gift, the gifts are listed separately (instead of lining up one after the other) and the address fields repeat. I suspect that this is probably something simple, but as I mentioned, my Crystal skills are somewhat limited.
Move the address fields into the sort key Group Header.
Thanks. That worked great. The only problem I have now is that I want to add the notes field and there are multiple notes. Where do I put that field in order to ensure that the gifts all don't split between the notes? What is the rule of thumb for inserting fields with multiple values?
In those situations I usually create a Subreport, which is essentially a report within that report. You would link the Subreport to the main report using that Sort Key and insert the Subreport in either the Group Header or Footer, so it prints once per constituent.