[OBIEE 10g] Line Break In The Column

 

Line Break in the column

We need to display the text inside the column formula with a line break to show the data broken with horizontal pieces.

So as always we can call HTML into rescue for such situation.

We can replace the words blank spaces with a <br> tag like the one shown below-

 

Replace('Good Day To People',' ','<br>')

Result for the above code in the column formula-

 

The above piece of code holds good in the situtation where there is a line break after every space.

Supposing if we need to have a line break after few sets of words then the code should be like the below-

Replace('Good Day* To People Out* There','* ','<br>')

And the last piece of code without the Replace statement-

'Good'||'<br>'||'Day'

I used the below code to display the values as

'Good'||'<br>'||'Day'||'---->'||"Products"."Product"

NOTE - Please dont forget to change the Data format of the column in the column properties to 'HTML'