Cannot implement column link for this detail SQL query. Converting to group
Dear All,
Im working on the oracle aging report, my report has 2 data models. 10g database.
in the 2nd data model im using case function to get the buckets column. And when i trying to link the above error is appearing. Below is the code which i have used.
(case when trunc (trunc (sysdate)-trunc (trx.trx_date)) <= 60 then '1-60 Days'
else (case when trunc (trunc (sysdate)-trunc (trx.trx_date)) <= 120 then '2-120 Days'
else (case when trunc (trunc (sysdate)-trunc (trx.trx_date)) <= 180 then '3-180 Days'
else (case when trunc (trunc (sysdate)-trunc (trx.trx_date)) <= 365 then '4-365 Days'
else '5-365+ Days' end) end)end)end) bucket
The same how can i use in the decode function to aviod the problem, please can any one help me this query.
tnxs
Siva.