rahartigan
Technical User
I'm trying to display on a report the defendant name and the plaintiff name separately. The field that distinguishes them is involvement type. I can display the Plaintiff name but the Defendant isn't working. I know I am missing something easy as this is one of the more complex formulas I need to do. Any assistance is appreciated. The formula I am trying is below.
Thanks.
WhilePrintingRecords;
stringVar Defendant;
If {Civil_Name.Involvement_Type}= 'Defendant' then Defendant;
if not isnull ({Civil_Name.Business_Name})
then Defendant := {Civil_Name.Business_Name}
else Defendant := {Civil_Name.Name_Last};
If not isnull ({Civil_Name.Name_First}) THEN Defendant := Defendant & " " & {Civil_Name.Name_First};
If not isnull ({Civil_Name.Name_Middle}) THEN Defendant := Defendant & " " & {Civil_Name.Name_Middle};
If not isnull ({Civil_Name.Name_Suffix}) THEN Defendant := Defendant & " " & {Civil_Name.Name_Suffix};
Defendant := TRIM(Defendant);
Defendant;
Thanks.
WhilePrintingRecords;
stringVar Defendant;
If {Civil_Name.Involvement_Type}= 'Defendant' then Defendant;
if not isnull ({Civil_Name.Business_Name})
then Defendant := {Civil_Name.Business_Name}
else Defendant := {Civil_Name.Name_Last};
If not isnull ({Civil_Name.Name_First}) THEN Defendant := Defendant & " " & {Civil_Name.Name_First};
If not isnull ({Civil_Name.Name_Middle}) THEN Defendant := Defendant & " " & {Civil_Name.Name_Middle};
If not isnull ({Civil_Name.Name_Suffix}) THEN Defendant := Defendant & " " & {Civil_Name.Name_Suffix};
Defendant := TRIM(Defendant);
Defendant;