Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9925 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / naidu
1) click on query item that you have draged from the layer.
2) click on LIST it was in the properties
3) then in the properties you will find NO DATA CONTENTS
make it as YES
4) drag TEXT ITEM from tool box properties and type your
MESSAGE
5) Run the report
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / l m patel
Hi,
There are lots of option.
In Frame Work Manager :
In query you write like this
1]Ex: Decode(column_name,' ','No-Data')
2]EX: case when WORKORDER.SITEID is null then 'No-Data'
else WORKORDER.SITEID end as SITEID
IN Report Studio also write same expression :
In query you write like this
1]Ex: Decode(column_name,' ','No-Data')
2]EX: case when WORKORDER.SITEID is null then 'No-Data'
else WORKORDER.SITEID end as SITEID
3]EX:
a) click on query item that you have draged from the layer.
b) click on LIST it was in the properties
c) then in the properties you will find NO DATA CONTENTS
make it as YES
d) drag TEXT ITEM from tool box properties and type your
MESSAGE
e) Run the report
4]EX:
a.select the query item in the list which contains null value.
b.if it is char data type then click the data format in
properties.
c.select the format type text,
d.In the missing value enter the text as "no data".
e.so that you will get the output when it contain null values.
That's it ....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / muku
Is this informaica or any another reorting tool.
Please clarify
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nikhila reddy
we isnull
select isnull(col name,'no data')
| Is This Answer Correct ? | 0 Yes | 3 No |
what are the tabs in cognos ?
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.
How we check the errors before running the report?
How to create users and permissions in cognos?
If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com
What are the types of catalogs in cognos?
difference between imprompt and reportnwt1.1
how you create security to reports?
what is session parameters? what is use?
write a query to display the third record from the employee table?
What is a scope? can you tell me one example for scope?
How do add dynamic titles in PP?
Teradata 
