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

What is the metric store database?

928

---

what is stitch query in reportnet?

1051

---

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2098

---

What do you understand by the term 'dynamic cube'?

950

---

Why need staging area database for dwh?

1035

---

How do we convert from Numeric to be Words?

2959

---

How can I test reports in cagonos?

920

---

What is metric store database?

963

---

What is set to be Cognos configuration?

982

---

-----------With out using DrillThrough how to do Reports?

1998

---

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6831

---

-----------------What is Determination Model?

2101

---

Can you define fan trap?

1231

---

how to test reports in cognos?

976

---

i was asked what are the caluclations done by you in your report? plz give reply

2147

---