Multiple lines

[former_member424792]

I am creating a report that one field can have more than 1 entry, currently my report is pulling the data in to more than one lines. For tract ID 2 the report has 2 line of data to show both "Unit Names". What I want to do is create a formula to have the multiple fields show up in to one line and have a "," between the 2 different units.

Instead of seeing this

Martin Unit

(New line) Kirk Unit

I need to do this: Martin Unit, Kirk Unit

Thank you in advance,

[abhilash_kumar · Accepted solution]

Matt,

I misunderstood how the records show up.

Modify the formula like so:

WhilePrintingrecords; 
stringvar sub;
numbervar x := x + 1;
IF x = 1 THEN 
sub:= {DUE_DIL_MASTER_VW.UNIT_NAME} 
ELSE( IF NOT ({DUE_DIL_MASTER_VW.UNIT_NAME} IN SPLIT(sub,',')) THEN 
sub:=sub&','&{DUE_DIL_MASTER_VW.UNIT_NAME} ); 
sub

Modify the Rest formula to:

WhilePrintingrecords; 
stringvar sub := '';
numbervar x := 0;

-Abhilash

[former_member424792 · Accepted solution]

As always you are a HUGE help, thank you much for the modification to my original formula.