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
- 9079 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
What is catalog and types of catalogs in cagonos and which is better?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
which type of project we r going to snowflake schema
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
how to perform single sign in cognos by using url?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is called Cognos powerplay?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
--------------Diff b/w ODS and OLAP?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
how to perform back drill through in cognos 8 what is the use of it
What is the difference between a data mart and a data warehouse?
