I've got a collegue who's working on a crystal report. The report has the donor's Cumulative giving, primary solicitor, proposal status & proposal attributes. All that looks pretty good.

The part that is not coming out "right" is when they have a constituent attribute; and they have more than one of these attributes. She's only looking for one of four, but if they have more than those, the report is returning a separate row for each occurrence of that attribute on their record. Is this grouping issue?? Or should her formulas be revised?

As always, thanks for your help!

I've got a collegue who's working on a crystal report. The report has the donor's Cumulative giving, primary solicitor, proposal status & proposal attributes. All that looks pretty good.

The part that is not coming out "right" is when they have a constituent attribute; and they have more than one of these attributes. She's only looking for one of four, but if they have more than those, the report is returning a separate row for each occurrence of that attribute on their record. Is this grouping issue?? Or should her formulas be revised?

As always, thanks for your help!

This is simply the way that relational databases work. When you join the parent table to a child table, the parent information gets "duplicated" for each of the child records. If you join on multiple child tables, you get a "duplicate" for each combination of the child records.

The easiest way to handle these "duplicates" is to put the constituent attributes in a sub-report. If that doesn't work, then you'll have to do a group on the constituent. What you do after that depends on exactly what you want to display.

Drew

Which one of the four do you want? The first one?

DrewAllen;8758 wrote:


That is what I figured....so I did group by Constituent ID, but now, if the person has the attribute more than once, the report is only displaying the FIRST attribute from the attribute table. Basically, if they have the attribute more than once, she wants to see each occurance, just on the same row...any more ideas? I suggested a subreport, but I'm not sure she's that savvy in Crystal - I may just have to work on it for her.

paulmorriss;8760 wrote:


No - if they have it more than once, she wants to see them all - just on one row instead of duplicate rows. I think a subreport is going to be the answer...