New line character

[sankar_ganesh]

Hi,

I need to show the results of 2 expressions(sum(sales), sum(profit)) one by one, as shown in below , in a straight table.

chr(13) to insert a new line is not working in the chart expression , it works in text box only. Does any one have solution for this.

Country	Results
xxx	Sales: 1000 Profit : 150
yyy	Sales: 2000 Profit : 550
zzz	Sales: 3000 Profit : 1500

Thanks.,

Sankar

[Gysbert_Wassenaar · Accepted solution]

On the Presentation tab of the properties window you need to check the option Wrap Cell Text and set Cell Height to 2 lines. And make sure you put the Sales and Profit text in single quotes. Something like ='Sales: ' & sum(sales) & chr(13) & 'Profit: ' & sum(profit)

[sankar_ganesh]

Hi Gysbert,

thanks for your answer. but in Ajax mode, wrap cell text is not working in QV 11.0 version, which is a bug ,and fixed in QV 11.2 SR1

[agigliotti]

in the title text on the Caption tab multiline does works in v11.2 SR1 but in container on general tab -> Label for selected object the multiline works only with IE Plugin no with Ajax.

I hope it will be fixed in v11.2 SR2 !