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
- 9008 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bash
In this scenario by using DECODE()function we can solve this
problem
Ex: Decode(column_name,' ','No-Data')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
Define report item?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What are the advantages of shortcuts?
What do you mean by Drill down and Drill Up?
Please explain the different stages in creating a report in cognos report net?
what are the errors faced while bursting the reports and how to solve those errors?
What is a dimension?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What is looping and how to avoid it in framework manager?
4. How many dimensions did you use in your reports?
How do we convert from Numeric to be Words?
What are the considerations regarding performance kept in mind while setting up cognos?
Why is auto-regression used in forecasting used on cognos platform?
Write various indexes used in cognos?
