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.