Crystal Reports-Multiple lines

Karen Couch
Karen Couch
Fourth Anniversary Facilitator 1
in Raiser's Edge NXT Discussions

I'm trying to create a report of gifts for a campaign. Individual give multiple report to multiple fund. I cannot get the Individual and all the gifts to only appear once on one line, each gift shows up on a separate line (John Doe, $25000 to ABC Fund, next line John Doe $5000 to DEF Fund-Same campaign) How can I merge these 2 lines into 1?

Tagged:

Comments

  • Chelsea Powell
    Chelsea Powell
    Eighth Anniversary Kudos 1 Participant Facilitator 1

    Could you group by Constituent ID and then by the campaign?

  • Karen Couch
    Karen Couch
    Fourth Anniversary Facilitator 1

    This is how it shows up

    Name Capital Chapter Loyalty

    Jerry Steiner Capital Campaign $0 $0
    Jerry Steiner $0 Eta Fund $0
    Jerry Steiner $0 $0 Loyalty Fund

    This is how I need it to show up

    Name Capital Chapter Loyalty
    Jerry Steiner $30000 $30000 $30000

    I'm exporting only the Capital Campaign gifts. I cannot get each gift to show up on one line

  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant

    This amazing article should help. Instead of {Gf.Gf_Type} = “Cash” use something like Fund = “Loyalty Fund”. Then make two more formula fields for the other funds. Depending on what else you have in the report you might also consider using a Cross tab report, or a RE pivot report.

  • Karen Couch
    Karen Couch
    Fourth Anniversary Facilitator 1

    solicited to date gift info_julian part 2.pdf

    This is what my current report looks like

  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant

    Thanks, can you send a screen shot of the design tab? Might need to do some grouping and summary fields.

  • Karen Couch
    Karen Couch
    Fourth Anniversary Facilitator 1
    e02884b5d9bae6c6053d4ba11ccf4309-huge-im
  • Karen Couch
    Karen Couch
    Fourth Anniversary Facilitator 1
    8ea84a2df276e95cd244a5c510a84e58-huge-im
  • James Andrews
    James Andrews
    Tenth Anniversary Kudos 2 Participant Facilitator 1

    You have a couple of options here. The first is to export each of the gifts separately so you'll have them in separate tables, so you'll have CnGf–1 and CnGf−2 etc. then you'll be able to put them on one row.

    Your other option is to go ahead and export all the gifts in one table like you're currently doing, and do a subreport for each fund. Each subreport filters for only the gift you're looking for, and you put each subreport on the same line.

Categories