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 / uday

1.select the query item in the list which contains null value.
2.if it is char data type then click the data format in
properties.
3.select the format type text,
4.In the missing value enter the text as "no data".
5.so that you will get the output when it contain null values.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a cube in Transformer? What is the process? Please mention process thank u

1328


What is difference between data mart and data warehouse?

541


What are the main services provided by application tier?

560


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4076


What is the report studio?

588






9. What was the most complex type of report you dealt with?

1730


what are the dimensions that you have in your current project?list them?

1599


Why cognos scenario is used?

580


Define query items?

594


WHAT ARE THE DISTNICT VARIABLES?

1744


what is power prompt in cognos ep7series?what is the use of this?

3201


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1595


How do you improve the performance of the Cognos Analytics report

532


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1636


what is hints in cognos and where we use it.

1986