Duplicate data on Report

Shaun Grace

Hi,


I am hoping someone can help me with this. I have a custom report done with Crystal Reports that is a gift log. It is grouped by constituent and the detail is the gift record(s).


I use the following formula to display fund details:


{CnGf_1Fnds_1.CnGf_1Fnds_1_Description} & " (" & {CnGf_1Fnds_1.CnGf_1Fnds_1_Fund_ID} & ")" & if ({CnGf_1.CnGf_1_Amount} = {CnGf_1Fnds_1.CnGf_1Fnds_1_Amount}) then "" else (" - " & {CnGf_1Fnds_1.CnGf_1Fnds_1_Amount})


This works fine unless it is a split gift, when it duplicates the information displayed. For example:


Fund Description A - $1,000.00

Fund Description B - $1,000.00

Fund Description A - $1,000.00

Fund Description B - $1,000.00


I have tried suppressing duplicates without success.


I also display soft credits using this formula:


{CnGf_1SfCrdt_1.CnGf_1SfCrdt_1_Constit_Name} & " (" & {CnGf_1SfCrdt_1.CnGf_1SfCrdt_1_Constit_ID} & ")"


This works fine unless there is more than one soft credit recipient, and then it only displays one (the second one on the gift record).


Thanks so much!

Shaun

Joshua Bekerman bCLO bCRE

You'll need to put your fund information in a subreport within the details section.  You'll probably need to do the same thing with soft credits.

Shaun Grace

Joshua Bekerman bCLO,:

You'll need to put your fund information in a subreport within the details section.  You'll probably need to do the same thing with soft credits.

Thanks Josh, I had a feeling I would have have to do that. Was hoping there was another way!


Shaun

Brenda Anderson

Shaun Grace:

Hi,


I am hoping someone can help me with this. I have a custom report done with Crystal Reports that is a gift log. It is grouped by constituent and the detail is the gift record(s).


I use the following formula to display fund details:


{CnGf_1Fnds_1.CnGf_1Fnds_1_Description} & " (" & {CnGf_1Fnds_1.CnGf_1Fnds_1_Fund_ID} & ")" & if ({CnGf_1.CnGf_1_Amount} = {CnGf_1Fnds_1.CnGf_1Fnds_1_Amount}) then "" else (" - " & {CnGf_1Fnds_1.CnGf_1Fnds_1_Amount})


This works fine unless it is a split gift, when it duplicates the information displayed. For example:


Fund Description A - $1,000.00

Fund Description B - $1,000.00

Fund Description A - $1,000.00

Fund Description B - $1,000.00


I have tried suppressing duplicates without success.


I also display soft credits using this formula:


{CnGf_1SfCrdt_1.CnGf_1SfCrdt_1_Constit_Name} & " (" & {CnGf_1SfCrdt_1.CnGf_1SfCrdt_1_Constit_ID} & ")"


This works fine unless there is more than one soft credit recipient, and then it only displays one (the second one on the gift record).


Thanks so much!

Shaun

This is only one of the reasons we do not split gifts.  When a donor changes installment dates on pledges when one pledge fund has one date and the other needs a different installment due date, it becomes confusing.  We find it is better and more transparent to and enter them as 2 pledges, or 2 gifts or 2 payments.