Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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
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 !