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
Can you define metrics designer?
Define datastores in cognos?
What is Metrics designer?
What are the methods by which it non-durable model could be changed into the durable model?
What do you understand by the cognos?
How to publish a package by running Java Script?
Can you define a query subject?
What are the roles defined by cognos platform?
Can you explain the advantage of using shortcuts?
Can you explain cognos planning?
What are the types of studio?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What is the deployment requirements used in cognos?
what are the special features in cognos reportnet?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!