Assigned Solicitor on Gift Data

Gary Nicholls

 I am having difficulty adding the current Assigned Solicitor (Constituent Relationship) to gift data in Crystal (not the Gift Solicitor). Using the following formula I end up with the gift data more than once if there is a historical Assigned Solicitor (i.e. assignment has an end date) and the subsequent rows showing Solicitor blank. Any ideas how I can suppress the unwanted rows?

 

if {GfCnRelSol_1.GfCnRelSol_1_Date_To} < "01/01/1900" then {GfCnRelSol_1Cn.GfCnRelSol_1Cn_Surname} &", "& {GfCnRelSol_1Cn.GfCnRelSol_1Cn_First_Name}

Many thanks

Gary Nicholls

University of Auckland

Joshua Bekerman bCLO bCRE

Gary Nicholls:

 I am having difficulty adding the current Assigned Solicitor (Constituent Relationship) to gift data in Crystal (not the Gift Solicitor). Using the following formula I end up with the gift data more than once if there is a historical Assigned Solicitor (i.e. assignment has an end date) and the subsequent rows showing Solicitor blank. Any ideas how I can suppress the unwanted rows?

 

if {GfCnRelSol_1.GfCnRelSol_1_Date_To} < "01/01/1900" then {GfCnRelSol_1Cn.GfCnRelSol_1Cn_Surname} &", "& {GfCnRelSol_1Cn.GfCnRelSol_1Cn_First_Name}

Many thanks

Gary Nicholls

University of Auckland

 Check your table links, they should all be "Left Outer Join"

Also try adding the Else part to the formula, such as ->   else '' 

and/or check your null settings under Report options (I think).

Just some thoughts off the top of my head, as I don't have access to CR until I get back to the office tomorrow.  I can check tomorrow if still needed.