Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 9930 Views
- IBM, I also Faced
- E-Mail Answers
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
How do you improve the performance of the Cognos Analytics report
What are the components of report net?
What are the types of folder present in cognos?
What is zero-foot print?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
i was asked what are the caluclations done by you in your report? plz give reply
How to do Performence Tunning in Cognos Reports?
what is hints in cognos and where we use it.
what is a prompt value in report studio and variables ?
Explain the different types of views used in cognos.
What is the size of database for you project?
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?
what is online view?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
