Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this
Company_Number & Chr(10) & Company_Name & Chr(10) & Company_Code
No I only got 2 rows
It is showing as 123Company
001
Did you add Chr(10) between Company Number and Company Name?
Yes
That is strange that it worked one time and not worked another time. Can you share a sample to show the issue?
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) & )))
Looks okay, may be someone else have ideas here.
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. 🙂