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
What is the deployment requirements used in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
How to apply securities for reports in cognos connection?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
what is stitch query in reportnet?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What are the considerations regarding performance kept in mind while setting up cognos?
What are cognos connection initial page components?
What do you understand by ‘ibm predictive maintenance and quality’?
Define query items?
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 is difference between page break and section report?
i was asked what are the caluclations done by you in your report? plz give reply
how to perform back drill through in cognos 8 what is the use of it
What is the size of database for you project?