Hello All,
I have an issue with the report when I moved reports from cognos 10.2 to cognos 10.2.1 for below query,
CASE WHEN ([Country of Origin] in ('England', 'Northern Ireland', 'Scotland', 'Wales', 'United Kingdom')) THEN ('United Kingdom')
WHEN ([Country of Origin] in ('China (Excludes SARs and Taiwan Province)')) THEN ('China')
WHEN ([Country of Origin] in ('Taiwan (Province of China)')) THEN ('Taiwan')
WHEN ([Country of Origin] in ('Hong Kong (SAR of China)') ) THEN ('Hong Kong')
ELSE ([Country of Origin])
END
The error message is :
RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0004 Found an internal error on node 'V5Query'. xtab on relational style query should be handled by single query approach.
I tried to replace Case with decode and if..else statement but NO Success.The error remains same.
Is there is any other ways to rewrite this logic ?I really appreciate help guys!
Regards,
Jo