In this scenario by using DECODE()function we can solve this problem Ex

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?

Question Posted / bash

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

Please Help Members By Posting Answers For Below Questions

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2019

How the Bursting happens in same report and how to Print the bursting Report?

1867

Why cognos scenario is used?

1066

What do you mean by Drill down and Drill Up?

996

What is meant by Reportstudio shortcut?

2188

How to publish a package by running Java Script?

2084

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1926

what is degenerate key in oracle ?whare do we use it?

2563

how can I test reports in cagnos?

1153

Can you define confirmed dimension?

1082

i have one file i saved in csv how can i take these file into framework manager

2082

What is the enterprise class platform architecture of cognos 8?

1028

What do you understand by the term 'aggregate advisor?'

962

What are all the advantages of Cognos?

1037

-----------With out using DrillThrough how to do Reports?

2047