Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Multiple Gifts cause other fields to repeat in Crystal

Last post 10-23-2009 1:28 PM by Patrick Manning. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 10-22-2009 4:46 PM

    • Kathy Correia
    • Top 500 Contributor
    • Posts 20
    • Organization: Rhode Island Community Food Bank
    • Products:  The Raiser's Edge

    Multiple Gifts cause other fields to repeat in Crystal

    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. 

    Filed under:
  • 10-22-2009 4:55 PM In reply to

    • Patrick Manning
    • Not Ranked
    • Posts 12
    • Organization: College of Charleston
    • Products:  The Raiser's Edge

    Re: Multiple Gifts cause other fields to repeat in Crystal

    Move the address fields into the sort key Group Header.

  • 10-23-2009 8:49 AM In reply to

    • Kathy Correia
    • Top 500 Contributor
    • Posts 20
    • Organization: Rhode Island Community Food Bank
    • Products:  The Raiser's Edge

    Re: Multiple Gifts cause other fields to repeat in Crystal

    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?

    Filed under:
  • 10-23-2009 1:28 PM In reply to

    • Patrick Manning
    • Not Ranked
    • Posts 12
    • Organization: College of Charleston
    • Products:  The Raiser's Edge

    Re: Multiple Gifts cause other fields to repeat in Crystal

    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.

Page 1 of 1 (4 items)