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
- 9966 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 |
-----------Types of Fact Tables?
6 Answers Bank Of America, CTS,
What is dtm?
What is slowely changing dimensions?why we are used SCD?
What is the difference between Open Connection command ang Open Session Command?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What do you mean by drill through report?
Is it possible to join multiple Databases in a Catalog?
what is the difference between list report and crosstab report?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
In an existiing Framework model, how will you add a new column to the existing table?
What is the difference between group and associare?
Teradata 
