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')

what is the use of layout calculation?

4 Answers  

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

How do we drill through from a powerplay cube to reportnet?\

0 Answers   IBM,

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

0 Answers  

wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

0 Answers  

-------------------What is Deployment?

2 Answers   IBM,

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers  

what is a query subjects item?

1 Answers   HCL,

What snowflake and Starschema?

2 Answers   HCL,

-------------How to create a PortalTab?

1 Answers   Cap Gemini,