we isnull select isnull(col name,'no data')

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 / nikhila reddy

Answer Posted / nikhila reddy

we isnull

select isnull(col name,'no data')

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

1. Explain your project.

2094

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2564

can you tell me what are the dimension tables are used in project

2354

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

2611

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2415

What are the types of studio?

1197

What you mean by drill across?

1073

Explain informatica architecture?

1049

What is the use of powerplay web viewer in cognos?

1131

Explain difference between powerplay transformer and power play reports?

995

How to apply securities for reports in cognos connection?

2581

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

1132

how to create measures and dimensions?

1174

What are all the components of Report Studio?

1154

Explain the difference between powerplay transformer and power play reports?

1077