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 difference between Standard and Metrics folder?

1126

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2518

Explain the difference between native sql and cognos sql?

1087

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2286

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

995

Why need staging area database for dwh?

1117

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2369

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2090

What are all the components of Report Studio?

1154

----------------Diff b/w Dimensional modeling and Relational modeling?

15093

Name the types of report?

1010

how to create cubes in transformer ?

1119

What are the components of report net?

1320

faq's on cognos

4097

Can you define framework manager?

1064