How to display multiple field names as one column name ?

[claudialet]

 Hello  I  have 3 fields:   Company_Number ,  Company_Name and Company_Code 

Using this expression for field name : 

Company_Number  & '' &  Company_Name & '' &  Company_Code& ''

I get :   123Company001 

The result I  want  for a column header is 3 separate rows  :      123 

                                                                          Company 

                                                                              001 

[sunny_talwar]

How about this

Company_Number & Chr(10) & Company_Name & Chr(10) & Company_Code

[claudialet]

  No I only got 2 rows 

It is showing as               123Company

                             001

[sunny_talwar]

Did you add Chr(10) between Company Number and Company Name?

[claudialet]

 Yes 

[sunny_talwar]

That is strange that it worked one time and not worked another time. Can you share a sample to show the issue?

[claudialet]

 I am unable to share data but here is the expression for a column in a  QS pivot table. 

=if($(vFilter)=1 and DomesticFlag=0 , Company_Number & Chr(10) &  Company_Name & Chr(10) & Company_Code ,

if($(vFilter)=4 and DomesticFlag=0 , Company_Name & Chr(10) & Company_Code & Chr(10) & )))

[sunny_talwar]

Looks okay, may be someone else have ideas here.

[claudialet]

Is there any load function that should be used for the 3 fields : Company_Number, Company_Name and Company_Code to display it in 3 consecutive rows ?

[sunny_talwar]

If anything would work... it would be with Chr(10) or Chr(13)... you can try them... but not sure why Chr(10) will work once, but not twice. 🙂