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


Please Help Members By Posting Answers For Below Questions

What is catalog and types of catalogs in cagonos and which is better?

737


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

1748


which type of project we r going to snowflake schema

1781


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

815


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..

2028


how to perform single sign in cognos by using url?

788


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

858


---------------Describe OLAP Reporting and RDBMS Reporting?

1904


What is called Cognos powerplay?

849


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.

1664


--------------Diff b/w ODS and OLAP?

2983


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

1774


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

1829


how to perform back drill through in cognos 8 what is the use of it

2278


What is the difference between a data mart and a data warehouse?

808