im having null data in one of the cell in my report
i have to display as "no data" when u run the report
how can i achive this problem?
Answer Posted / bash
In this scenario by using DECODE()function we can solve this
problem
Ex: Decode(column_name,' ','No-Data')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
whats the difference between previous version of cognos and cognos 8 BI?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
Define query items?
what is hints in cognos and where we use it.
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
Explain what is the difference between microstrategy and cognos reporting tool?
Why is auto-regression used in forecasting used on cognos platform?
What are the different types of important services used in cognos?
9. What was the most complex type of report you dealt with?
what are the dimensions that you have in your current project?list them?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is set to be Cognos configuration?
How do you Parametermap variables in Quiries?
What are all the advantages of Cognos?
what is power prompt in cognos ep7series?what is the use of this?