Dedupe between two subreports

Options
Joshua Bekerman bCLO bCRE
Joshua Bekerman bCLO bCRE ✭
Tenth Anniversary Facilitator 3 Name Dropper Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
Hi!  I have a report that is a directory of board and trustees. I have their names, address, etc. in multiple detail sections.  In one detail section I have a subreport that lists phone numbers and emails that were exported from their main record (i.e. Bio 1).  In another detail section I have another subreport that lists phone numbers and emails that were exported from their Primary Business Information.  Is there a way to dedupe these two subreports so the main report does not show duplicate phone numbers?
Tagged:

Comments

  • Marie Stark
    Marie Stark ✭✭✭✭✭
    Ancient Membership Facilitator 3 Name Dropper Photogenic

    Joshua Bekerman bCLO,:

    Hi!  I have a report that is a directory of board and trustees. I have their names, address, etc. in multiple detail sections.  In one detail section I have a subreport that lists phone numbers and emails that were exported from their main record (i.e. Bio 1).  In another detail section I have another subreport that lists phone numbers and emails that were exported from their Primary Business Information.  Is there a way to dedupe these two subreports so the main report does not show duplicate phone numbers?

    Off the top of my head, maybe you could create shared variables for the phone numbers, and pass them all into the main report.

    Then you could to a formula to try and compare them in the main report, or suppress them if they are equal to another field.

     

Categories