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
how u will design the report if the objects are available
What are the advantages of cognos?
What is called Cognos powerplay?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Explain about scorecarding?
What is difference between data mart and data warehouse?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
Give me any example of semi and non additive measures?
What are the message flows?
What are slice and dice?
What is the deployment requirements used in cognos?
What do you understand by the term 'dynamic cube'?
How can we create a dynamic column name in cognos?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
------------------What is Inline Query?