I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
Answer Posted / krishna
case when column_Name =0 then 'NULL'
else 'column_Name'
end
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
in u r data u having duplicates how to fetch the latest data in our report?
what is catalog and types of catalogs in cagnos and which is better?
What is the difference between the standard and metrics folder?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
-----------------What is Determination Model?
Define report item?
tell me two or three issues from client side and how to solve those issues?
Why is auto-regression used in forecasting used on cognos platform?
---------------Tell me about DWH Concepts?
----------------Diff b/w Dimensional modeling and Relational modeling?
How can we create a dynamic column name in cognos?
How can you link a query to a data container manually in Report Studio?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
How the Bursting happens in same report and how to Print the bursting Report?
What is cognos powerhouse?