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.

[former_member424792]

This does not work, however I may have figured out a way using this formula in the group footer section.

WhilePrintingrecords; global stringvar sub; IF ONFIRSTRECORD 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

In the group Header section I have a reset so the unit names do not build on one another:

WhilePrintingrecords; global stringvar sub; sub:=""

However the results I get are correct but there is a "," at the beginning and I cannot figure out why. The column is listing the multiple ID fields, ex. ,John Unit A, Kirk Unit B The issue is the "," before John Unit.

[abhilash_kumar]

Hi Matt,

Try:

Replace(Replace({string field},chr(10),"."),chr(13),".")

-Abhilash