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
- 8972 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 |
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Explain the different stages in creating a report in cognos report net?
How can we Maintain the Cube Security by Category level and Dimension level ?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
Sales person are there in one company How to do Bursting on this particular requirement?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
What is the enterprise class platform architecture of cognos 8?
How to perform single signon in Cognos by using URL?
when can i use the STAR Schema and SNOWFLAKE Scgena
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
wat is called Model dimension?
Teradata 
