Coalesce in teradara and output in pdf

[ranjankumar]

Hi ,

In report level i have splitted 2 queries( A, B )  and associated to one Main query (C) . Join is A left outer join  B . numeric values are taken in both query . so when i do left outer join output will be ...

A.Ccolumn1  A.column2             B.COLUMN1
ID1              25                       NULL

I display this is main query  for one column by adding two columns like
( A.column2    +   coalesce( B.COLUMN1 , 0 )  ) .

So the reult output shud be
A.column1   Common_column
ID1            25

But it displays
A.column1   Common_column
ID1             NULL

i tried with missing values , coalesce, nullifzero .... but it does not works .Note this it works in HTML... but not in PDF .my backend is teradata .Kindly let me know your solution.