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?
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 |
if there are list,crosstab,chart how can you apply a single filter to all object?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
whats the difference between previous version of cognos and cognos 8 BI?
Any Cognos planning Queries Rise
What is the difference between macro & Parameter
Can any one give the example for slicing and dicing of data ?(with simple query)
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.
What is Correlated sub-query? Please explain
Explain the difference between native sql and cognos sql?
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?