Header

Saturday, 21 September 2013

Webi : Showing two values in one cell , but in new line


In Web Intelligence to show values from two different object on to a single column you can use char(10) . ascii value of Char(10) is a new line character.

Example :-  there are two column Prodcut_Id(P0001) and Product_Name(CAR) to be merge into one.
you can create formula : MergedColumn =Prodcut_Id+Char(10)+Product_Name 
that will display result something like this in a single table cell-

 MergedColumn
 P0001
 CAR

No comments:

Post a Comment