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
- 10118 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the methods by which it non-durable model could be changed into the durable model?
How to join multiple db in catalog?
Can you define snapshot?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is a Query Subject?
What is the difference between set functions and filter function in dimensional data?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is model?
in u r data u having duplicates how to fetch the latest data in our report?
How to apply securities for reports in cognos connection?
Which studio is used to create reports?
What is the difference between static and dynamic conditions?
WHAT ARE THE DISTNICT VARIABLES?
Explain what is the difference between microstrategy and cognos reporting tool?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
