Interested to Buy Any Domain ? << Click Here >> for more details...
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'
- 2 Answers
- 6215 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Explain what is the difference between native sql and cognos sql?
how to perform back drill through in cognos 8 what is the use of it
Why cognos decision stream is used?
Can you define snapshot?
Why cognos scenario is used?
How do we convert from Numeric to be Words?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
how to create cubes in transformer ?
How to create model and how to test model?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What are initial page components of Cognos connection?
5. Which type of report you build more, list, crosstab or chart and why?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What are the types of studio present in Cognos?
-------------What is Coditional Prompting?
