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
Explain informatica architecture?
What is cognos reporting tool?
How to join multiple db in catalog?
What is the difference between a cascading report and drill through the report?
What are slice and dice?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
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 are the components of the report studio?
What is the deployment requirements used in cognos?
what is catalog and types of catalogs in cagnos and which is better?
4. How many dimensions did you use in your reports?
Is it possible to join multiple Databases in a Catalog?
what is the role of cognos comsultant?what actually it means?pls reply
What are all the types of report?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.