Crystal Reports-Multiple lines

Karen Couch

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?

Chelsea Powell

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

Karen Couch

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

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

solicited to date gift info_julian part 2.pdf

This is what my current report looks like

Joshua Bekerman bCLO, bCRE

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

Karen Couch

Karen Couch

James Andrews

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.