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
- 9076 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 do you understand by the term 'aggregate cache'?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
What is difference between content store and content manager?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are products of cognos?
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!
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
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
what are slowly changing dimensions? Why we are used scd?
--------------Diff b/w ODS and OLAP?
write a query to display the departments with no employee?
What DB View and Bus View?
Explain what is the difference between microstrategy and cognos reporting tool?
Write various indexes used in cognos?
What is meant by drill down?
