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.

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

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 ....

Answer / bash

In this scenario by using DECODE()function we can solve this
problem

Ex: Decode(column_name,' ','No-Data')

Answer / muku

Is this informaica or any another reorting tool.
Please clarify

Answer / nikhila reddy

we isnull



select isnull(col name,'no data')

How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

2 Answers   TCS,

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

1 Answers   IBM,

What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

0 Answers   DELL,

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers   TCS,

how can we improve performance of the reports?

6 Answers  

Write various indexes used in cognos?

0 Answers  

What is the difference between macros and prompt?

2 Answers   IBM,

how to merge 2 crosstabs thans

0 Answers   HCL,

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

0 Answers  

How you drill from powerPLay to Impromptu?Explain all Steps?

2 Answers  

What is limited local? and the uses?

2 Answers   Ness Technologies,

what happens when date function has taken as attribute

1 Answers   TCS,