Answer / krishna

Use conditional block

Answer / pradeep

create a dataitem ib the query like...

case
when ?first? = 'Product Line' then [Product]
else
?Product?
end

use this dataitem in the filter condition for product

what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,

---

8. Can you use calculations in report headers and footers? How?

1 Answers  

---

What is a Complex report and explain?

4 Answers   IBM, Satyam,

---

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,

---

what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,

---

How to create Events?

1 Answers  

---

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

---

Tell me about Schemas?

4 Answers  

---

what are summary filters? grouped filters?

3 Answers   IBM,

---

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

---

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,

---

Is it possible to apply access manager user rights in impromptu?

1 Answers  

---