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
- 9737 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 is the difference between set functions and filter function in dimensional data?
Explain informatica architecture?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
How can we do the unit testing?
What is zero-foot print?
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What are the ways to import data into catalog?
6. Which of them will increase the performance?
pls ans what are the filters we have in framework manager? filters in report studio?
Teradata 
