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

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1077

What is the difference between a cascading report and drill through report?

1072

What is metric store database?

1000

What is a Pivot?

1148

What is the metric store database?

970

What is the deployment requirements used in cognos?

1654

What is the use of powerhouse?

1083

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

1075

Can you define pivot?

1110

What are the message flows?

983

When we save a report in report studio with what extn it save?

1066

Define query studio?

1003

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2421

What are the components of the report studio?

1178

how to merge 2 crosstabs thans

2641