Post

2 followers Follow
0
Avatar

How to Combine multiple text field data to one

Hi Greetings 

 

I have 3 different data in 3 different text field. in final report I want to show all that in 1 text field 

for Eg

Text Field-01 " Consultant Comment  On 1st Inspection"

Text Field-02 "Consultant Comment  On 2nd Inspection "

Text Field-03 " Consultant Comment  On 3rd Inspection "

 

Out put I want in 1 text field as 

Comment-01 

Consultant Comment  On 1st Inspection

Comment-02 

Consultant Comment  On 2nd Inspection

Comment-03

Consultant Comment  On 3rd Inspection

 

I used 

Var a = (@Inst Visit-01 + " ")
Var b = (@Inst Visit-02 + " ")
Var c = (@Inst Visit-03 + " ")
Var d = ("Comment-01" + a)+("Comment-02" + b ) + ("Comment-03" + c ).join()
d
 
But getting error on it 
 
Please help 
 
Ravikishan Bhat

Please sign in to leave a comment.

2 comments

0
Avatar
Hi Ravikishan,
 
would be helpful to know which error you get. :) Also helpful: a screenshot of the calculation field.  I assume the error is caused by .join() which doesn't make any sense in your code, it must be removed. But this should work (the \n inserts a line break): 
 
var a = (@Inst Visit-01 );
var b = (@Inst Visit-02 );
var c = (@Inst Visit-03 );
var d = "Comment-01\n" + a + "\nComment-02\n" + b + "\nComment-03\n" + c ;
d
Rainer
Rainer Grabowski 0 votes
Comment actions Permalink
0
Avatar

Dear Rainer Grabowski

 

Thanks a lot it worked for me 

 

 

Ravikishan Bhat 0 votes
Comment actions Permalink