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?
- 6 Answers
- 9006 Views
- IBM, I also Faced
- E-Mail Answers
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
what is online view?
What are the advantages of shortcuts?
What is the difference b/w macros and prompt?
What is meant by junk dimension?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
9. What was the most complex type of report you dealt with?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What junk dimension contains?
Is it possible to join multiple Databases in a Catalog?
how to create cubes in transformer ?
What is the function of cognos dispatcher?
Explain the difference between native sql and cognos sql?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is the function of model design accelerator?
